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...
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...
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...
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...
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...
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.
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...
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.