Can you please help me to understand this? I have a table with an identity column and a clustered index defined on this column.The fillfactor for...
Hi guys, we have some performance issues on the server and i see lot's of writelog waits all the time while we inserting transactions constantly...
Thanks a lot guys
Hi guys, we do have this threshold defined on the server (Transactions/sec: _Total value > 2000) and every morning i have a message from monitoring...
Thank you
Hi, where i can find info how to read records bellow? Thanks SQL Server Execution Times: CPU time = 0 ms, elapsed time = 0 ms. SQL Server...
quote:Originally posted by satya http://sqlserver-qa.net/blogs/tools/archive/tags/indexing/default.aspx fyi. Satya SKJ Microsoft SQL Server MVP...
Hi guys, Here is my problem: We do have an website application with 24/7. We should not have downtime even for 5 min. Currently we have a job for...
Thank you, I canceled restore and performed some testing. Just tried to create new database to see what will happen. It#%92s interesting that when I...
Hi, There is something going on with a server. I am trying to restore a 23G on the server where the actual database not exists. i used to be able to...
quote:Originally posted by satya Any reason for holding back that recommendation? This is the reason explained by MS: Looks like you are...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Is there a way to rollback truncate statement? i read on some sites that it is possible using 3rd party tools or something, but i am not sure.
quote:Originally posted by satya Are you using Vista by chance? Do you have any text or image fields query running at the same time? It's a...
Hi, today i found this error in the error log file: "Message A fatal error occurred while reading the input stream from the network. The session...
quote:Originally posted by MohammedU Most of the dead lock happens between two spid... Your update may cuase deadlock...it is hard to tell...depends...
quote:Originally posted by MohammedU Check the following... http://support.microsoft.com/kb/832524...
Hi, this is my first message on the forum.<br />We do have deadlocks happened on the system everyday all of the sudden. I run the profiler trace...
Separate names with a comma.
