sql
The DBA’s Rules
I don't know if you're a fan of NCIS, but for those of you who aren't let me give you a little back story. Gibbs is the leader of an investigative team and he
dba
t-sql
Determine the Space Used by Tables
Eventually you'll be faced with running out of space on a SQL server. Usually, before you get more drive space, you're asked to find out if you can get rid of
t-sql
Inter-Database Queries
I've had this question come up a few times now. "How do I copy data from one database to another?" It's after getting a question like that, I explain fully
microsoft sql
Comparing Query Performance
A significant portion of your time as a database programmer or administrator will be to improve the performance of queries. While there are several benchmarks
sql
Duplicates
Duplicates. I honestly can't tell you how many times the root cause of a problem has been records in a table get repeated, where there should never be
sql
A Better sp_who2
If you've ever needed to work with sp_who2 to figure out what's going on, then you know it would be nice to be able to sort the results, right? Well, if you use
dba
Incomplete Tables
One of the things I’ve noticed while performance tuning is many of the tables in my current environment are incomplete. They all have columns defined, and
t-sql
Quickly Disconnect Users From a Database
Disconnect All Users of a Database There comes a time in every DBA's life when he or she has many users connected to a database that needs to be detached, placed in single user mode, or simply refreshed. The problem is they keep reconnecting more quickly than you can KILL them off. This is especiall
t-sql
Sams Teach Yourself SQL in 10 Minutes (3rd Edition)
I picked up this book to try and refine my understanding of SQL as quickly as possible. I was looking to get a quick overview, and a list of topics I could dig