Are you looking for something like this:

insert into products

select ProductLine, ProductCode, NULL, NULL

from products

where not exists (select 1 from products p2

...

Interesting. What does the ghost cleanup process do then?

As to why something goes through and cleans up the ghost records instead of just allowing the space get reused, that way the data doesn't remain on disk so it...

You can create two different foreign keys but that won't require the two columns are on the same row. You could also create a trigger to enforce it or...

There are a number of different things that trace flags can do. Here's an article with a list:

http://msdn.microsoft.com/en-us/library/ms188396.aspx

We saw this recently when the Windows team was doing some domain controller work. They had to fail the domain controller over to another node so there were some...

This depends on a number of factors. I've seen recommendations to grow the files to fill the disk so autogrowth isn't needed. If possible, that would be preferred...

Another recommendation I would throw in is to have your backups on a different location. I've seen a number of clients run out of disk space and keeping backups...

To my knowledge the SQL engine has always worked like that. I'm not sure if there have been any changes on the SSIS side that could result in a...

Try looking in the logs and see if anything pops up there. You can also look in the default trace if SQL Express has it. You'll be able...

Are you talking about a report in SSRS? I'm trying to reconcile what you're asking with what I know about SQL and that's the only thing that makes sense...

There are select times when adding in more data than is needed and then deleting makes more sense. I had to do that one place because the query that...

It's a big question and if you want a quick answer it's, "It depends."

How often backups, integrity checks, and reindexing needs to be done depends on your environment. If...

Peter Maloof (5/27/2011)

---

FYI, according to Books Online, the PASSWORD option is "intended to prevent an incorrect restore using SQL Server tools by authorized or unauthorized users." and according to Books...

Thanks for the article. It's one I'll have to keep in my bag of tricks because it'll likely come in handy some day.