How about stupid date queries like this:

where Convert(varchar, CreationDate, 101) between Convert(datetime,@FromDate, 101) And Convert(datetime, @ToDate, 101)

which can amount to something like this:

where '12/30/2008' between '12/25/2008' And '01/05/2009'

How about having some non-work related books so your new co-workers don’t think you’re a total dork?

Leave out a copy of “The Prince” by Niccolo Machiavelli so they’ll think you’re...

What you describe is completely normal behavior for SQL Server. When SQL Server allocates memory, it does not give it back unless there is pressure from the OS.

Why are...

RBarryYoung (12/30/2008)

---

From the 2008 BOL:

The Scalable Shared Database feature enables you to scale out a read-only database built exclusively for reporting (a reporting database). The reporting database must reside on...

Sounds like marketing BS.

A database has to be "shared", or it wouldn't really be much of a database.

As for "scaleable", is...

I...

Here is one more method to generate a random number in the range of 100000 to 999999.

It uses the right 7 bytes of the newid() to create a bigint value....

That script does not generate a primary key value.

All is does is create a primary key on an existing table.

Someone mentioned that you might gain some performance because the OS is accessing two files in parallel, instead of one. However, there is nothing that prevents you from having...

Only extended stored procedures can be called inside a function.

There are a number of commercial utilities that let you produce compressed SQL Server backups:

SQL LiteSpeed, Redgate Backup, Idera has one, and there are several others.

Another option might be to...

GilaMonster (12/24/2008)

---

Well there was this one guy (who claimed to be a performance tuning guru and...

If there is someone doing a DBA interview that doesn’t have the technical understanding to be able to weed out a bogus DBA, then they probably shouldn’t be in their...

Marker (12/23/2008)

---

Ok, I do want to create a custom script to switch the db to bulk_logged during index rebuilds. I started creating a script and if I should be...

The minimum amount of transaction log space required will be at least as large as the largest table in the database. This is because re-indexing rebuilds each table in...