-- Will SQL 4 Food - FTW!

declare @t table (name varchar(50), original_content_count int)

insert into @t (name, original_content_count)

values ('Kamil Moscicki', 0), ('Itzik Ben-Gan', 107), ('Kalen Delaney', 98), ('Steve Jones', 587)

selectname, original_content_count,...

Anyone?

Seriously - this is a hard one to answer, isn't it? And it's hard to research, too!

To spur your thinking, here's more detail:

My database is a high transaction environment,...

We recently changed the machine names on three of our development servers. We only run one instance of SQL Server on each and the only issues I had were:

-...

I run Vista on a laptop with 2GB memory and dual hard drives. I installed SQL Server Express 2005 and the available management tools with no problems. You'll...

Hear! Hear!

Even worse is working for a big corporation that has an entire department dedicated to this sort of thing, and remotely forces reboots. I frequently got a...

I voted for choice A because B doesn't account for leap years, and C is wrong.

There are two problems in the case statement. It requires both the day and...

SQL Server is a machine of...

I started down the path toward a Computer Engineering degree but eventually switched and earned a BS in mathematics. I taught high school for two years, then cut my...

Great article!

As for the DMV, I concur with LP. The sys.dm_os_performance_counters view is constantly incrementing various counters of performance that SQL Server reports to the O/S. As written,...

I know this is solved, but for future reference and for other readers, if you have an MDF you're largely okay.  Any pending transactions would be gone and you'd lose...

I have two possible solutions for you:

You can backup the database and restore it using the WITH MOVE <logical log name> TO <os file name>.  This will allow you to specify...

My previous employer is a large package delivery company, where my worth was measured very much by time in the building rather than quality of performance.  A minimum of 45...

Arrrgghhh!  Answered it right but got it wrong!

Ditto Rhonda...

I've run into similar situations.  Mine are usually some variant of an obscenely high percentage growth number.  I generally set databases to automatic growth, but with a max size.  I usually...

I've had occasional problems with the UI, but a script will get the job done for you.  Something like this:

USE

[master]

GO

ALTER

DATABASE