Thank you. I will check it tomorrow, but I tried once and I havent found anything special at the time of these strange peaks. Can it be... say,...
Maint.plans perform nightly backups, there are also trn.log backup every hour I guess. SQL server is dedicated. Database mirroring is ON. This is...
Hi, all My avg Queue length is usuall very low, <1 all the time, except sudden spikes. These spikes can trigger a real disaster (domino effect). May...
Try to replace substring() with LIKE '204%' or ... like '250%' etc
But if you store a hash, then you can decrypt SSN just because there are not so many combinations. For other data, if you store HASH value, then you...
Multiple Databases or Multiple Instances? http://www.sqlsolutions.com/articles/articles/Multiple_Databases_or_Multiple_Instances.htm
Again, I had never experienced any problem with counters affecting SQL server (even sometimes perfMon could not report sany statistics) But SQL...
Is he already fired? :)
You dont neeed to back up logs for databases in a SIMPLE mode However, you can restore them from a last full backup only
When SQL server is running slowly, there is always one reason of the following list: CPU I/O system (Reads, Writes) Locks You should check what SQL...
If you pass table name as a parameter then you need to use dynamic SQL (this is a big subject, dynamic SQL is not always bad, but it should be used...
If Duration was 970567, what were the values for CPU, Reads, Writes?If they were low, then it was a long running lock (use Deadlock Detector...
Always remember that you pay a performance penalty (sometimes - severe perf penalty!) for the encription. So encrypt only what you really need. Dont...
Separate names with a comma.
