Had a great time talking with Richard on RunAsRadio about Query Performance Tuning Strategies, check it out. How do you keep your SQL queries fast? Richard chats with Monica...
       2022-04-27 (first published: 2022-04-13)
 375 reads
           Quick Tip Remove CONVERT/CAST from your WHERE clauses and JOINS when comparing to variables of different data types. Set their data types to match your table definitions before using...
       2022-04-08 (first published: 2022-03-28)
 792 reads
           A command I like to use when performance tuning is DBCC INPUTBUFFER. If you have ever run sp_whoisactive or sp_who2 to find out what sessions are executing when CPU...
       2021-07-19 (first published: 2021-07-07)
 855 reads
           When using a Geo Replicated Azure SQL Database Readable Secondary  there are a few things to consider when it comes to performance tuning. Check out this episode of Data Exposed:...
       2021-07-12 (first published: 2021-06-30)
 271 reads
           “One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server and storage performance. No matter how many gerbils power your storage, you need to know...
       2021-03-25 (first published: 2021-01-19)
 571 reads