One of my favorite jokes:

A chicken and an egg are lying in bed together. The chicken rolls over, sits up and lights a cigarette, then says, "Well, I guess that...

Here's the tail of the DBCC CHECKALLOC results.

(number of mixed extents = 102, mixed pages = 777) in this database.

CHECKALLOC found 0 allocation errors and 0 consistency errors in database...

I'm having similar issues with my system. After first noticing high levels of index fragmentation, I decided to run a job over the weekend and specifically rebuild a number of...

Thanks, Charles, I will give it a whirl.

And just to pre-empt any complaints that I was off-topic here (a frequent habit of mine, but I digress:), I actually was...

In a previous century, on a far-off planet, there was a utility called Jet, which came with a memory card from Promise Technologies. It is no longer available, and anyway...

You're right. I drifted into naming conventions and I think led a few others down my garden path. Sorry. Regarding layout, I most definitely agree with your "KEYWORD on a...

First off, this is a good discussion to raise, Tony.

Second, within any organization a standard practice is or should be mandatory. In practice, that means Select Max(Power) From Employees Where...

I had no trouble getting the scripts themselves to work. To do so, I opened Management Studio, then opened the scripts (DDL and Populate) in turn, then executed them. Then...

Hi Vincent,

I liked reading through your article, and then decided to follow you step by step. I was able to grab and restore the backup file, etc., and to run...

Hi Andy,

I appreciate your quick responses. Perhaps I misread the following sentence, but I don't think so:

"Your source may be a table or view, it may be a query. For...

Apparently there is an important difference between Canadian and American systems law. Up here, we are not permitted to use Social Insurance Numbers for anything except reporting to Revenue Canada....

Good introduction to SSIS! One thing you wrote surprised me: that using a select statement would be faster than using a view. I don't understand why this is the case.

Since...

I'm one who began using Identity keys everywhere and only discovered their down side when I got to a database (modeled by those who came before me) with over 500...

On my own, I have come up with most of the conventions that you recommend. In particular, I am a big fan of what I call Hungarian postfix notation, which...

Steve,

Although it's been quite a while since the last time I smoked a joint or a pipeful of hashish, I do know something about the testing involved. There is an...