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