Sql Stuff
Ramblings of all kinds of Sql related tasks - usually related to customer questions, problems, etc. (that's what I do and all)
Due to a few different reasons, I'll be moving my blog from here at MSDN to the following location....
Date: 10/17/2007
So, I think most of my close friends have heard by now, but if you are a friend, and you haven't...
Date: 08/21/2007
I get many requests from customers for something like sp_who/sp_who2 for Sql 2005 with new...
Date: 08/15/2007
With Sql 2008 (in the current CTP you have in your hand), thanks to a new extension to the group by...
Date: 07/29/2007
This post will cover an initial overview of the data compression feature that will be included in...
Date: 07/27/2007
So, I've been getting quite a few pings about providing a list of new features to look for in Katmai...
Date: 07/26/2007
In Sql 2008 (Katmai), a couple of the 'smaller' features that are currently in the latest CTP...
Date: 07/25/2007
In August, September, and October I'll be presenting on Sql Server 2008 (Katmai) at a variety of...
Date: 07/18/2007
So you think you know SQL...Administration Part I The 2nd in the series...this one revolves around...
Date: 07/17/2007
The first in hopefully a fairly long series of posts on interview type questions/scenarios/etc.,...
Date: 05/29/2007
I'm frequently asked about questions that are asked when interviewing candidates for Sql Server...
Date: 05/29/2007
So, here's an interesting scenario I ran into a few weeks back. A customer had a situation in which...
Date: 05/14/2007
I ran into an interesting scenario with a customer this past week that behaved a bit differently...
Date: 04/18/2007
I spent this past week with a customer giving a workshop covering Sql 2000 architecture and...
Date: 04/08/2007
Well, I'm now also presenting at the CMAP Code Camp the week following the NOVA CodeCamp, so, if...
Date: 04/06/2007
If you're in the DC/NOVA area (or even some parts of Maryland for that matter), I'll be presenting 2...
Date: 03/30/2007
Many customers (and non-customers) are often confused about all the different memory configurations...
Date: 03/24/2007
A customer this past week was curious how to determine which indexes on their server were being used...
Date: 03/11/2007
Earlier this week I had a customer send me the following question: I have a server running the...
Date: 03/08/2007
A customer recently questioned me regarding a sorting issue they were having in the following...
Date: 03/08/2007
A customer this week inquired about auto updating of statistics in Sql 2005, particularly with...
Date: 03/03/2007
The same customer that promted the post of mine titled "How can I get sysindexes information in Sql...
Date: 02/24/2007
A customer asked me today how they could retrieve information similar to that available in the...
Date: 02/24/2007
A customer I work with questioned me today in regards to hearing that in Sql 2005 you can now have...
Date: 02/24/2007
With the releast of SP2 for Sql 2005, a customer asked me today what they need to consider as a...
Date: 02/21/2007
I had a customer inquire as to why they would see results from queries like the following where the...
Date: 02/02/2007
Lots of customers I visit are frequently interested in determining what...
Date: 02/02/2007
I had a customer inquire as to how to verify service-related permissions for the Sql Server service...
Date: 02/02/2007
Finding (all the) gaps in an identity column (or any integer based column for that matter) using Sql 2005
We're often asked how to determine gaps in an identity column. For Sql 2000, there are quite a few...
Date: 01/07/2007
Q: In addition to hyper-threading and dual-core technology, chip vendors are beginning to release...
Date: 01/05/2007
Q: I have configured Database Mirroring successfully between 2 Sql Server 2005 instances. My...
Date: 01/05/2007
Q: Given the forthcoming updates to Daylight Savings Time to comply with the Energy Policy Act of...
Date: 01/05/2007