Capacity planning is about knowing the trend in growth over time. You need to monitor how the free space in the data files is changing. I log this...

Don,

Something happened to your report, but all that came through were the select statements. Can you repost the blocked process report?

I agree that SSIS is generally going to be the tool that you would use for doing data transfers in almost all cases. It didn't fit our companies business...

I agree that is a nifty script, and I will have to add that to...

Jean-François Bergeron (12/4/2008)

Does that...

If you can swing this kind of operation, it is generally much...

The difference is that you are issuing thousands of smaller transactions affecting 1000 rows at a time versus issuing a single transaction that is affecting millions of rows. The...

You can delete them in small batches in a loop like the following:

DECLARE @BatchSize INT,

@Criteria DATETIME,

...

You can use SSIS and the Transfer Logins Task to move logins between Servers. You should probably use a Active Directory Group to control grouping of logins.

PASS = Professional Association for SQL Server

http://www.sqlpass.org

It is a organization for SQL Server Professionals that is worldwide and membership is free. They do the PASS Summit every year which...

That is a big question and one open to alot of opinion. I'd recommend that your read the following articles on this site:

http://www.sqlservercentral.com/articles/Administration/61680/

http://www.sqlservercentral.com/articles/Administration/61681/

https://www.sqlservercentral.com/blogs/aloha_dba/archive/2008/10/01/a-focus-on-novice-dbas-my-upcoming-pass-presentations.aspx

http://www.sqlservercentral.com/articles/Career/61535/

https://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/10/29/3075.aspx

http://www.sqlservercentral.com/articles/Editorial/62696/

http://www.sqlservercentral.com/articles/Editorial/62928/

http://www.sqlservercentral.com/articles/Editorial/62865/

Also look at Kimberly Tripps post on...

You can probably find most of the information that you are looking for on Pinal Daves blog. He has 58 posts dedicated to Interview Questions and Answers:

http://blog.sqlauthority.com/category/main/sql-interview-questions-and-answers/

Here is what Microsoft considers to be the top 30:

http://www.microsoft.com/sqlserver/2005/en/us/top-30-features.aspx

If it is a detached copy of the same database, you could attach it with a different name and get a copy of the table and whatever contents existed at...

We do similar things with our DMZ Servers, so the topic is very familiar. I have to setup a PC every month or so for one reason or another.