SQLStudies

There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations....

2017-09-25

484 reads

Do what I say, not what I do

by Kenneth Fisher

SQLStudies

I told you not to use NOLOCK even though I use it sometimes.I told you not to shrink databases, even...

2017-09-20

436 reads

Uniquifier is a rather unique word isn’t it?

by Kenneth Fisher

SQLStudies

tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique.
Uniquifier is a rather funny name,...

2017-09-22 (first published: 2017-09-18)

1,657 reads

Help! My query is too fast!

by Kenneth Fisher

SQLStudies

Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of...

2017-09-20 (first published: 2017-09-14)

3,250 reads

Turn on/off Azure VMs with Powershell

by Kenneth Fisher

SQLStudies

T-SQL Tuesday has rolled up on us yet again. This month it’s Rob Sewell’s (b/t) turn to host and picked...

2017-09-12

449 reads

There EXISTS a place where SELECT 1/0 doesn’t return an error.

by Kenneth Fisher

SQLStudies

Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical...

2017-09-07

667 reads

SQL Homework – September 2017 – Create a home lab

by Kenneth Fisher

SQLStudies

As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something...

2017-09-05

397 reads

You might be a DBA if

by Kenneth Fisher

SQLStudies

I’d been trying to think of a fun post to write and an homage to Jeff Foxworth’s You might be...

2017-08-30

1,876 reads

Create an empty table from a SELECT statement but without the IDENTITY.

by Kenneth Fisher

SQLStudies

A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like...

2017-09-11 (first published: 2017-08-28)

3,089 reads

Changing the version of an SSIS package.

by Kenneth Fisher

SQLStudies

Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say...

2017-09-06 (first published: 2017-08-23)

3,475 reads

SQLStudies

Saving and restoring session options settings

Do what I say, not what I do

Uniquifier is a rather unique word isn’t it?

Help! My query is too fast!

Turn on/off Azure VMs with Powershell

There EXISTS a place where SELECT 1/0 doesn’t return an error.

SQL Homework – September 2017 – Create a home lab

You might be a DBA if

Create an empty table from a SELECT statement but without the IDENTITY.

Changing the version of an SSIS package.

Blogs

AI Experiments: Claude Solved a DAB Issue

Audit – Security Compliance Frameworks (Part 1)

Restore SQL Server Database to an OrbStack Container

Forums

Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened

What is CPU Usage?

Limiting Checkpoints

Question of the Day

Limiting Checkpoints