-->
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: October 2018

Zombie SQL

It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but still a bad practice. It’s Zombie code so it seemed like something fun to talk about on Halloween. But what is it?

 
Zombie Code

Code that is left in…

Read more

2 comments, 2,660 reads

Posted in SQLStudies on 31 October 2018

Blogger Questions: What if I get a mean/rude comment?

There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time I hit schedule on a post.

What if my post sucks? What if someone tells me it sucks?

After 6 years of blogging, I finally got one! (Yes, I was… Read more

10 comments, 228 reads

Posted in SQLStudies on 29 October 2018

I’m in a book! Data Professionals at Work

A while back a friend of mine, Malathi Mahadevan (b/t), asked me if I’d like to do an interview for a book she was working on. I’ve been interviewed before but never quite like this. She called me up (on skype if I remember correctly) and… Read more

2 comments, 168 reads

Posted in SQLStudies on 24 October 2018

How do I look at my error log if SQL won’t open?

Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you don’t have the log viewer in SSMS? In fact, the instance won’t come up at all so you really need to see what went wrong.

Fortunately, the error logs… Read more

1 comments, 2,484 reads

Posted in SQLStudies on 22 October 2018

What is the Object Explorer Details tab good for?

For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL Server Management Studio) and I would immediately close it. I couldn’t think of a single use for this view that seemed to be just another way to see the list… Read more

0 comments, 201 reads

Posted in SQLStudies on 17 October 2018

Highlighting sp_spaceused

I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick way to bring up the size of things. Specifically:

  • Tables
  • Indexed views
  • Service Broker queues
  • Databases

 
It’s the first and last that I use the most often. It’s… Read more

0 comments, 172 reads

Posted in SQLStudies on 15 October 2018

Which is faster? IN (list) or IN (SELECT FROM Temp)

If you’ve done much with IN (list) then you’ve realized that it basically translates out to

col=val1 OR col=val2 OR ....

You’ve probably also realized that you can throw all the values into a temp table and do this

SELECT *
FROM tablename
WHERE col IN (SELECT col FROM #temp

Read more

8 comments, 2,317 reads

Posted in SQLStudies on 11 October 2018

Letting the business bully you: T-SQL Tuesday #107

Before I start anything I want go give a disclaimer. I absolutely believe that the business should be involved in every stage of a project. When it comes down to it they are who we do the work for. That said, Introduction!

This is T-SQL Tuesday, the long-running blog… Read more

1 comments, 186 reads

Posted in SQLStudies on 9 October 2018

Generate a random number of children for each parent

I was asked an interesting question the other day.

Is it possible to get a different random number of rows back from each application of a cross apply?

The purpose is to create some random demo/testing information. This is one of those cases where an example may be needed for… Read more

4 comments, 1,891 reads

Posted in SQLStudies on 3 October 2018

SQL Homework – October 2018 – Time for an upgrade

When you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was released almost immediately afterward and so has been out a year now. Not to mention that SQL 2019 has been announced. Don’t you think it’s time to do an… Read more

0 comments, 237 reads

Posted in SQLStudies on 1 October 2018