-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: June 2017

SQL Crossword : T-SQL Keywords : June 2017

I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked around and I’ve decided to make this a regular thing (end of the month or so) for a little while (till I get bored with it). I’m going… Read more

2 comments, 1,943 reads

Posted in SQLStudies on 28 June 2017

Temp table quiz

Brent Ozar (b/t) posted a pop quiz on twitter earlier today.

Go ahead and give it a shot .. I’ll wait.

So? What do you think? Did you get it right? I did, but I wasn’t 100% certain, nor did I initially think through all of… Read more

10 comments, 412 reads

Posted in SQLStudies on 26 June 2017

Dynamically generate the command line DMA statement for each database

If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run the DMA (Database Migration Assistant). If you are doing a BUNCH of upgrades at once (say 100 instances or something) then you probably don’t want to use the… Read more

0 comments, 359 reads

Posted in SQLStudies on 21 June 2017

Adding Identity to an existing column

A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He then ran into an issue where he had to have one. The easiest thing is to create a new int column with an identity column right? Unfortunately in this case… Read more

1 comments, 337 reads

Posted in SQLStudies on 19 June 2017

Turning ANSI_PADDING off, and why you shouldn’t

I ran into an interesting error the other day while doing a partition switch.

Partition switch failed because : column ‘xyz’ does not have the same ANSI trimming semantics in tables ‘a’ and ‘b’

It turned out it was because the ANSI_PADDING setting was different between the two tables (well,… Read more

4 comments, 2,133 reads

Posted in SQLStudies on 15 June 2017

Buzzword Bingo

Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS. (As he put it, it was either that or execution plans.) Now I’m not highly knowlegable about DevOps myself. I mean I have a general… Read more

0 comments, 559 reads

Posted in SQLStudies on 13 June 2017

UDP vs TCP

If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance on?”. You probably are aware that the default instance uses port 1433. You might also be aware that the browser uses port 1434. What’s the browser I hear you… Read more

3 comments, 326 reads

Posted in SQLStudies on 7 June 2017

Backup to NUL

Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In fact, one of the awesome bonuses of this location is that your backup will take up exactly 0 bytes of space. You got it, absolutely none! Now before you… Read more

6 comments, 185 reads

Posted in SQLStudies on 5 June 2017