The filegroups matter. If you have other files in the filegroups that contain the full files, then the other files will be receive data. SQL Server sends data to filegroups....

There is a free SQL Search tool from Red Gate that will integrate into SSMS and let you quickly search for objects.

Disclosure: I work for Red Gate

Red Gate has the dependency tool that will allow you to find out what is linked to what.

However if you are expecting to right click on an piece of code...

I don't know a lot of people using Resource Governor, but they have been successful. It is a little more complicated to setup and understand, but it does do a...

Run the query for the top 20 and then loop through it, running additional queries.

In T-SQL, I'm not sure how easy this is. In SSIS, you can create a new...

If you use formal parameters, and you're not concatenating user input with code, then I think you are safe for the most part. I wouldn't say that you're completely safe,...

Is there an error when you put it in? If you've registered with the new email already, or it's in the system, it won't change. The error message sometimes isn't...

I tend to follow Gail's advice. 2 Full backups + all logs.

Going back more than a couple days is almost always impractical for any system. For auditing purposes, I'd rather...

Job is the way to do this. You're scheduling something.

However I'd make it fairly generic. Run it every day, enable/disable people based on a day of the month. Building...

First, please post in the appropriate forum. Moving to Integration Services since you mentioned a package.

Second, please include the error. If you have an error, give the text. If you...

Doh! so close. Burress showing up at all might have helped.

Congrats to my British competitor for the win.

I tend to agree with Gilamonster's advice. The one thing I'd add about appending is that if something happens to the backup file, then you lose not only one, but...

SQL Kiwi (12/10/2011)

Yes, I had an email today saying it would be republished on that date (no doubt you saw my...

Good for Pujols. I heard the Angels owner say they expected him to bring in about half a billion over the next ten years with revenue changes and promotions. Plus,...

Brandie?

http://www.youtube.com/watch?v=CplUqjQqTq0