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

I’ve gotten a transaction log full error but when I look it’s not full??

Every now and again I’ll get an error telling me a transaction log is full. This can be for any number of reasons (make sure you are taking log backups on your full recovery databases) but many of my co-workers (DBAs and others) get really confused when they check and… Read more

2 comments, 2,081 reads

Posted in SQLStudies on 16 April 2018

Deleting a lot of data

I recently had the task of deleting a bit over a billion rows from a table. Now I could have done just this:

DELETE FROM tablename WHERE createdate >= '1/1/2017'

But I have a few problems here. The table has no index on createdate, potentially causing problems with tempdb (the… Read more

5 comments, 1,780 reads

Posted in SQLStudies on 12 April 2018

Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101

Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. My initial thought was to talk about using solutions in SSMS but I’d already written about that. My next thought was to write about sp_DBPermissions and… Read more

1 comments, 182 reads

Posted in SQLStudies on 10 April 2018

SSMS’s Dark Theme

There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the answers really are yes, and no. And by that I don’t mean yes and no as in maybe. I mean litterally, does it exist yes and will it exist… Read more

3 comments, 254 reads

Posted in SQLStudies on 4 April 2018

SQL Homework – April 2018 – Indexes

This month we are going to look at a topic near and dear to both database developers and database administrators alike. Indexes.

Even if you don’t actually do everything on this list right now (and it’s a lot) make sure you at least understand it all and are capable of… Read more

0 comments, 204 reads

Posted in SQLStudies on 2 April 2018

What’s the difference between Files and Filegroups?

tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct used to store information (log & data) about the database.

When creating a database you’ll notice that each database is built of several components. There are two files, one for… Read more

0 comments, 613 reads

Posted in SQLStudies on 28 March 2018

Introducing The Blame Game

Introducing the Blame Game! Someone has messed up the new anatomy application’s (Mr. Body) performance and no one is willing to fess up. It’s up to you to place blame where it’s due.

8 Characters you’ll recognize from your own meetings.
6 Mistakes you’ve probably made (more than… Read more

4 comments, 172 reads

Posted in SQLStudies on 26 March 2018

Moving a table using BCP and native format

You need to move a table from one instance to another with the following requirements:

  • The instances are on separate domains. In fact, you might be shipping the table to a vendor or client.
  • The destination is an actual SQL Server instance.
  • Can be automated on either end.
  • Quick and…

Read more

3 comments, 219 reads

Posted in SQLStudies on 21 March 2018

GDPR – After the restore

I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR (The EU General Data Protection Regulation). In case you haven’t heard of GDPR (maybe you’ve been offline for the last few months?), the GDPR is some rather sweeping security… Read more

1 comments, 221 reads

Posted in SQLStudies on 19 March 2018

DB_NAME() vs ORIGINAL_DB_NAME()

I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular the difference between it and DB_NAME. I use DB_NAME and DB_ID fairly frequently in support queries (for example what database context is a query running from or what database… Read more

1 comments, 2,508 reads

Posted in SQLStudies on 15 March 2018

A look back from the future. – TSQL Tuesday #100

The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact SQL v2026.July.10 has just been released and v2026.July.25 announced.

Many things haven’t changed much in the last 8 years. For example:

  • Profiler is still deprecated.
  • msdb and SQL Agent haven’t…

Read more

3 comments, 186 reads

Posted in SQLStudies on 13 March 2018

Simply Debugging

Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it or not) but the techniques are used all through life.

  • Why won’t my phone charge?
  • Why won’t the living room light turn on?
  • Why hasn’t that water boiled yet?!?

  Read more

3 comments, 1,881 reads

Posted in SQLStudies on 7 March 2018

SQL Homework – March 2018 – Recovery Objectives

My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases (there might be some reporting people who are exceptions) need to know how to take a backup. If nothing else you need to know how to save your work.… Read more

0 comments, 175 reads

Posted in SQLStudies on 5 March 2018

A day in the life of a Sr DBA/Dev

If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points in your career (if not quite daily).

There’s a bug in my code,
Dear Liza, dear Liza,
There’s a bug in my code,
Dear Liza, a bug.

So fix it, Read more

0 comments, 197 reads

Posted in SQLStudies on 28 February 2018

Double hop error when using SQLCMD

tl;dr; SQLCMD v2014 and up has special requirements for Kerberos.

One of the problems with linked servers (no rude noises please) is that frequently you will see a double hop error.

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’

Let’s start with a brief explanation of a double hop. If… Read more

2 comments, 707 reads

Posted in SQLStudies on 26 February 2018

Windowing without a partition by or an order by

If you’ve never worked with windowing functions they look something like this:

SELECT name, max(create_date) OVER 
		-- No this isn't meant to make sense
		(PARTITION BY lower(left(name,1)) ORDER BY owner_sid)
FROM sys.databases;

The other day someone mentioned that you could use ROW_NUMBER which requires the OVER clause without either the… Read more

2 comments, 1,290 reads

Posted in SQLStudies on 21 February 2018

The default filegroup, and why you should care.

You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index & heaps) and another for the indexes (non-clustered indexes). Or maybe you want to separate your data tables from the system tables. There are any number of reasons why you… Read more

2 comments, 196 reads

Posted in SQLStudies on 19 February 2018

Synonyms, how and why.

Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even though it’s been around for >10 years (SQL 2005). In fact, I’d be willing to bet that a good chunk of the people reading this have never (or just… Read more

6 comments, 3,106 reads

Posted in SQLStudies on 15 February 2018

Hobbies, stress relief, and meeting management: T-SQL Tuesday #99


It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that means that Adam Machanic’s (b/t) brainchild has been running for over 8 years! This month is hosted by none other than Aaron Bertrand (b/ Read more

2 comments, 1,863 reads

Posted in SQLStudies on 13 February 2018

Backups of backups or How long is my backup really available?

I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important, and one of the most complicated. Take a full backup, restore it. Pretty simple right? And yet it’s vital when accident or corruption require recovering data. And as simple as… Read more

1 comments, 1,682 reads

Posted in SQLStudies on 7 February 2018

Newer posts

Older posts