Let us learn how I use a quick trick to know the object property with the keyword OBJECTPROPERTY. Let us learn how we can figure it out.
Find Expensive Queries – SQL in Sixty Seconds #159
Earlier I wrote a blog post about SQL SERVER – List Expensive Queries – Updated March 2021. Let us learn how to Find Expensive Queries.
SQL SERVER – Maximum Column Per Index – 32
Well, the answer is you can have 32 Maximum Column Per Index but that does not mean you should have 32 indexes. Let us learn today.
SQL SERVER – Flush Data from Memory to Disk
One of my clients asked me how to Flush Data from Memory to Disk during a recent consulting engagement Comprehensive Database Performance Health Check.
The Monthly Mentor Returns 2021 – 3 Webcasts
I have recently built three FREE webcasts under the monthly mentor returns 2021 series for Quest. 2 of the earlier performed webcasts.
SQL SERVER – List Expensive Queries – Updated March 2021
One of my favorite scripts which I discuss with my client during Comprehensive Database Performance Health Check is how to get a list of Expensive Queries.
Case-Sensitive Search – SQL in Sixty Seconds #158
Earlier I wrote a blog post about SQL SERVER – Case-Sensitive Search. Lots of people said I should make a video on this topic.
SQL SERVER – Case-Sensitive Search
How to do a Case-sensitive Search? I was asked this by one of my clients of Comprehensive Database Performance Health Check.
SQL SERVER – Data and Index Compression – Real-World Conversation
Today we are going to see a real-world conversation about Data and Index Compression in SQL Server. I recently discussed this with my client.
Understanding Non-relational Data with Azure – Pluralsight Course
I am an expert at NoSQL as well as Non-relational databases. I have published a new course about Understanding Non-relational Data with Azure.