Tag Archives: best practices
-
Turning ANSI_PADDING off, and why you shouldn’t
4June 15, 2017 by Kenneth Fisher
I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column …
Continue reading -
Why shouldn’t I shrink my database log file?
1May 15, 2017 by Kenneth Fisher
TL;DR: It’s pretty pointless and can cause performance issues. Let’s start by asking why you might want to shrink your …
Continue reading -
Dynamic SQL and the joys of QUOTENAME
5May 11, 2017 by Kenneth Fisher
I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even …
Continue reading -
Why is a Windows authenticated login more secure than a SQL authenticated one?
8April 26, 2017 by Kenneth Fisher
I had this question come up at work the other day and while I knew it was true I wasn’t …
Continue reading -
When should I add an index?
7April 19, 2017 by Kenneth Fisher
We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we …
Continue reading -
Limits vs Goals
1March 14, 2017 by Kenneth Fisher
It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us. …
Continue reading -
Using GROUP BY instead of DISTINCT
6March 6, 2017 by Kenneth Fisher
Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers …
Continue reading -
Event storming! It’s raining emails!
3March 1, 2017 by Kenneth Fisher
One of the most common ways to get an event notification is by email. So what happens when you get …
Continue reading -
Queries with optional parameters
11February 27, 2017 by Kenneth Fisher
These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
Continue reading -
What is COPY_ONLY?
2January 16, 2017 by Kenneth Fisher
You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up …
Continue reading
