Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

Constraint names, Say NO to the default

Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it makes no difference in terms of how things run but it does make it a bit of a pain when you need to code with it. Say dropping the… Read more

6 comments, 992 reads

Posted in SQLStudies on 21 January 2015

Except and Intersect

EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in any detail or used very often. I’ve been using them myself a bit recently and thought I would explore.

Per BOL:

EXCEPT returns any distinct values from the left query…

Read more

4 comments, 3,786 reads

Posted in SQLStudies on 19 January 2015

Pagination in SQL Server

It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL Skills insiders video on OFFSET and FETCH by Jonathan Kehayias (b/t) and remembered fondly an interview I did many, many years ago. As part of the… Read more

5 comments, 4,546 reads

Posted in SQLStudies on 15 January 2015

TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?

I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this past Saturday that call did have a few things going for it. First of all I was able to spend the first hour or so of it watching the MidnightDBAs… Read more

0 comments, 5,155 reads

Posted in SQLStudies on 13 January 2015

Discussing Security with Boris Hristov on SQLHangout #29

Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I ever wrote was security related. A brief explanation and solution for the Double Hop problem on SQL Server Central. Well continuing that theme I had an all to brief, but… Read more

0 comments, 110 reads

Posted in SQLStudies on 12 January 2015

Finding the reason for the error “Subquery returned more than 1 value”

First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In some cases (setting the result to a variable or doing an equality (=) for example) a subquery can only return one row. Because this is a error that specifically mentions… Read more

1 comments, 364 reads

Posted in SQLStudies on 7 January 2015

SQL Judo’s Monthly Challenge – January 2014 – Restore the Master

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be fun (and good practice) to start doing them and blog about it. Another major benefit is that it will force me to move out of… Read more

4 comments, 5,247 reads

Posted in SQLStudies on 5 January 2015

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 160,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 7 days for…

Read more

0 comments, 118 reads

Posted in SQLStudies on 30 December 2014

Finding a common AD group for a set of users.

I work for a large organization that over the last few years has been doing a LOT of reorgs. And what comes with reorgs? Lots of security requests. I’m always working to find easier ways to deal with them and I’ve gotten pretty good at it over time. One common… Read more

7 comments, 4,452 reads

Posted in SQLStudies on 29 December 2014

Do you want to build an Audit?

So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql server I do a walkthrough of the SQL Server Audits feature. It’s probably one of the easiest systems to implement that SQL Server has but it does have… Read more

0 comments, 179 reads

Posted in SQLStudies on 29 December 2014

Playing with the log – VLF order while growing the log

The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of VLFs (virtual log files). These VLFs are a logical way for SQL to break the physical file down into smaller pieces. These pieces are then marked as “in use” or… Read more

1 comments, 4,926 reads

Posted in SQLStudies on 17 December 2014

‘Twas 4:45 Friday

‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code was checked in, into Tortoise with care,
in hopes a release date – soon would be there.

The devs were all slumped – in front of computers,
while prospects of bonuses… Read more

2 comments, 4,637 reads

Posted in SQLStudies on 16 December 2014

Does a clustered index sort the rows within a page

This is just something I was curious about. I ran my tests and got an answer and now I thought I would share.

Before I start I want to point out a few things about my tests. I’m using code to create/modify a PRIMARY KEY. PRIMARY KEYs are not necessarily… Read more

0 comments, 223 reads

Posted in SQLStudies on 15 December 2014

DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD

I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do an ALTER INDEX REBUILD. I’m not sure, although I suspect they will take about the same amount of time. And what do I do when I’m not sure how… Read more

2 comments, 1,682 reads

Posted in SQLStudies on 11 December 2014

TSQL Tuesday #61: Giving Back, you gain more than you give.

Almost four months ago I posted my goals for the next year in my two year anniversary post. I pretty much decided I was going to continue on the same way I’d been going. Actively posting, writing the odd article, and hopefully catching up with my certifications. Well not only… Read more

0 comments, 135 reads

Posted in SQLStudies on 9 December 2014

INSERT INTO SELECT vs SELECT INTO

INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and again I see people getting confused by the similarities and missing the differences. So here is a quick check list.

Similarities
  • They look similar (I think this one throws people…

Read more

2 comments, 1,060 reads

Posted in SQLStudies on 3 December 2014

Using a date or int column as the clustered index.

The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on whether a date or int column was better as a clustered index. My contention is that a date column (if it is appropriate and will be useful) is a better… Read more

9 comments, 6,002 reads

Posted in SQLStudies on 1 December 2014

Who’s on call

Kenneth Fisher:

I really enjoyed writing this post last year and honestly still enjoy reading it myself. And since tomorrow is a holiday for a lot of people (I’m in America so I get to make that assumption) it seemed like a good time to bring it out again.…

Read more

0 comments, 182 reads

Posted in SQLStudies on 26 November 2014

Putting sp_ at the beginning of your stored procedure.

Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So what does that do and why should we care? The primary effect is that if you put a stored procedure starting with sp_ in master you can call it directly… Read more

1 comments, 286 reads

Posted in SQLStudies on 24 November 2014

You don’t really need ORDER BY do you?

You see dozens of blog posts and articles about how the order of a result set is not guaranteed without an ORDER BY clause and here is my contribution to the subject.

You all know I love examples so without further ado here we go:

Using data from AdventureWorks2014

--…

Read more

6 comments, 8,493 reads

Posted in SQLStudies on 19 November 2014

Older posts