Tags » SQL Tips And Tricks

SQL SERVER - Configure the Backup Compression Default Server Configuration Option

When I get a chance to talk to Enterprise customers working with a really smart DBA team, I generally look out for options they use on a daily basis and are often missed in the bigger scheme of things. 350 more words

SQL Authority

SQL SERVER - What’s the Difference between ROW_NUMBER, RANK, and DENSE_RANK? - Notes from the Field #096

: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about T-SQL Window Functions. Kathi is an amazing instructor, she was the SQL author I have read in my early career. 577 more words

SQL Authority

SQL SERVER - FIX - Error: Alter failed for Server 'Server Name' in Check Integrity task

Recently I was getting ready for an upcoming demo session and found that my maintenance plan for CHECKDB were failing. When I executed manually, I got below error… 341 more words

SQL Authority

SQL SERVER - Transparent Data Encryption and Frequently Asked Questions

In the recent past, I have been traveling to Delhi to meet customers and also attend a few conferences which my company has been sponsoring. These travel experiences give me an opportunity to meet folks who read my blog regularly as a face-to-face interaction. 576 more words

SQL Authority

SQL SERVER – SPID is KILLED/ROLLBACK state. What to Do Next?

I always recall my fun days after talking to my friends and blog readers. Recently killed/rollback discussion came back when my close DBA friend called me for help. 455 more words

SQL Authority

Interview Question of the Week #034 - What is the Difference Between Distinct and Group By

Question: What is the difference between DISTINCT and GROUP BY?


A DISTINCT and GROUP BY usually generate the same query plan, so performance should be the same across both query constructs. 99 more words

SQL Authority