I don't use a lot of custom settings but one thing I do is to set my default isolation level to read uncommitted

Have a look at this post:-

http://www.sqlservercentral.com/Forums/Topic883566-357-1.aspx

The first reply by GilaMonster should explain

Here's a survey performed by SQL SKills on Tempdb configuration.

http://www.sqlskills.com/blogs/paul/tempdb-configuration-survey-results-and-advice/

It's also got some good advice on what configuration you should use

Your diff backup will contain all the changes made since the last full backup. So it's recording all the maintenance changes that have been made whilst performing your index rebuilds.

The...

Have a look at this script:-

CREATE TABLE #TableSize

([Name]VARCHAR(255),

[rows]INT,

[Reserved]VARCHAR(255),

[Data]VARCHAR(255),

[Index Size]VARCHAR(255),

[Unused]VARCHAR(255));

CREATE TABLE #ConvertedSizes

([Name]VARCHAR(255),

[Rows]INT,

[Reserved (KB)]INT,

[Data (KB)]INT,

[Index Size (KB)]INT,

[Unused (KB)]INT);

EXEC sp_MSforeachtable @Command1="insert...

Hmm, I'm wondering if the free space is actually free space within existing objects. Does the database have data bulk inserted and then removed often?

Is there only the one filegroup (PRIMARY) in the database?

Hi,

I would have thought that if you are using tempdb heavily, placing it on a faster IO subsystem would improve performance. But how much? I can't really say, do...

http://msftdbprodsamples.codeplex.com/releases/view/93587

D'oh :pinch:

BWFC (11/27/2014)

left join dbo.runningtime t2 on t2.id = t1.id+1

Here's another attempt.

@dba-2 From The Cold, I don't mean...

Here's a bit of code to get you started:-

SELECT

ID,

TimeStamp,

LAG(TimeStamp,1) OVER (ORDER BY ID DESC),

...

How about polling the sys.databases table (via a SQL Server Agent job) and checking the create_date column based on a specified time frame.

You could then backup any databases that are...

An in-place upgrade is where you upgrade the existing SQL Server instance running on your server. A side-by-side upgrade is where you build a new server, install a later version...

Awesome, thank you very much!