Share via


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

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