Do you really need to shrink TempDB at all?

It has grown because the SQL Server database engine needs to use, either because of explicit temporary objects or because of implicit...

If the other 3 "indices" are named "_WA_Sys..." then they're auto-generated statistics that SQL Server has created on non-indexed columns.

When the AutoCreateStatistics is turned on for a database the presence...

You have to have done the full restore with NORECOVERY (or STANDBY) before you will be able to append any log or differential backups to the restored database. If...

The first thing I'd do is to rebuild all the indices on all tables, or at a minimum the tables you've deleted data from. You may have many free...

I'm always amazed by how passionate people are about different naming/case standards.

Personally I tend to use "prefixed Camel notation" (eg. tblMyTable or fnMyFunction) for my personal development activities, but I'm...

I'm always amazed by how passionate people are about different naming/case standards.

Personally I tend to use "prefixed Camel notation" (eg. tblMyTable or fnMyFunction) for my personal development activities, but I'm...

When you rebuild an index, SQL Server "populates" a new copy of the index, then deletes the old version once the new one has been created (this way there's no...

G'day Badra.

You should omit the log truncate and log shrink steps.

If the system falls over during your full backup but you've truncated the log you will not be able to...

In itself it won't make any difference to performance. The performance for an nvarchar(1) (not that there should be such a thing) and and nvarchar(1000) will be identical if...

Without an ORDER BY clause there is no guarantee that SQL Server will return the same row every time.

As a very simplistic example, say someone has just done a query...

There appears to be some confusion here around what is stored in the transaction log and the database and what a log backup does.

Writes to the SQL database (inserts, updates...

Have a look in Books Online regarding "String Functions". There's one there that does exactly what you want.

Don't forget that the underscore character is treated as a a single-character wildcard, not an explicit character.

Using AWE will be slower than using "natively-addressed" memory, especially if you are churning those AWE "pages".

Have you included the /3GB switch in your boot.ini? That will give SQL...

There's very few systems that are purely transactional: there's nearly always some sort of reporting being done on them. If you're lucky that's done in an out-of-hours batch window,...