I'm looking at the restore arguments.

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

Using STOPAT you can restore to a date and time.

Using STOPATMARK you can restore to a transaction mark or to a log sequence number.

The difficult...

Thanks, Deepak.

What about restoring master from 32-bit to 64-bit and the opposite?

Has anyone tested this or have you seen in any document that it's not supported?

Ola Hallengren

http://ola.hallengren.com

I'm interested in this. In knowledge base article 264474, Microsoft is talking about builds.

They also suggest SERVERPROPERTY('ProductVersion') as a method to check this.

Have you seen any references about editions (Standard...

I have also found the Maintenance Plans difficult to deploy to multiple servers. I think that here T-SQL stored procedures and jobs are easier to manage than Maintenance Plans. (Just...

For auditing DDL changes I recommend using Event Notifications. I wrote about this in another thread.

http://www.sqlservercentral.com/Forums/Topic517766-146-1.aspx

I have no knowledge about integration with TFS.

Ola Hallengren

http://ola.hallengren.com

Here's some code that I'm using.

DECLARE @NamedInstance bit

IF CAST(SERVERPROPERTY('ServerName') AS varchar) LIKE '%\%' SET @NamedInstance = 1 ELSE SET @NamedInstance = 0

DECLARE @ServiceName varchar(50)

IF @NamedInstance = 0

BEGIN

SET @ServiceName = 'MSSQLSERVER'

END

ELSE

BEGIN

SET...

Microsoft has as whitepaper on this.

"Generally, you should not be concerned with fragmentation levels of indexes with less than 1,000 pages. In the tests, indexes containing more than 10,000 pages...

I would recommend you to use the DMV sys.dm_db_index_physical_stats to check the index fragmentation and then only rebuild or reorganize the indexes that are fragmented. I think that you this...

-- First make sure that service broker is enabled in the current database

SELECT [name], is_broker_enabled FROM sys.databases

GO

-- Create an audit table

CREATE TABLE dbo.Audit ( AuditID int NOT NULL IDENTITY,

PostTime datetime...

I'm using Event Notifications to log DDL changes. In Event Notifications all events and event groups can be defined on the server scope. So with this solution you do not...

Please note that instant file initialization only works for data files.

Log files are always zero initialized.

Ola Hallengren

http://ola.hallengren.com

You could speed up the database creation by using Instant File Initialization.

Read about it in Books Online.

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

Kimberly Tripp has written a blog post about it.

http://www.sqlskills.com/blogs/kimberly/2007/03/04/InstantInitializationWhatWhyAndHow.aspx

Ola Hallengren

http://ola.hallengren.com

I think that small indexes often show a high fragmentation also after you've just rebuilt them. As I understand it fragmentation on small indexes has a very low performance impact....

In my experience it's a very good practice to run a CHECKDB with the DATA_PURITY option. I've had a lot of "value is out of range for data type" errors...

Nick, are you refering to using xp_delete_file?

How many files did you have in a directory and how long time did it take to do the delete?

Ola Hallengren

http://ola.hallengren.com