You can check the dmv dm_db_index_physical_stats to find out the avg record size:

Select * From sys.dm_db_index_physical_stats(DB_ID(),Object_id('MyHugeTable'),null,null,'sampled')

This should give you a prety good idea of the size of each rows of...

You'll have to script it and execute it on each instances.

You can use this script to get started:Select '

USE [master]

GO

CREATE LOGIN [SQLMPLowPriv] FROM WINDOWS WITH DEFAULT_DATABASE=[master];

GRANT VIEW ANY DEFINITION TO...

I don't think partitioning the table on the Key column will speed up anything, you'll still end up doing 150+ scans for each query.

You need to find a partition function...

The usual easy way to fix this problem is to upsert your data in small batches so the lock time are tiny and users won't notice anything (if you have...

The SQL Server install GUI will not even start if you are not in the local administrator group.

There are many ways to protect data from local admin, so in the...

Is the load on the DB you are comparing the same?

The increased amount of lazy write could just come from increased load (because the performance gets better, you write quicker,...

If the index you are rebuilding is a partitioned index you could only rebuild the index of a specific partition (See ALTER INDEX in BOL).

If you use 2 tables instead...

You can't switch a partition if the source table is the reference of a Foreign key.

There are tons of restriction to switch a partition, you can see it all here:...

That usualy happen when you use fixed length character columns and the actual data fit tighly in it, ROW compression is adding some overhead that cannot be saved if none...

Fibre chanel will just set a maximum transfer rate, not a minimum.

In this case you just proved that your older MSA with 8 disks is much better at reading than...

Check this: http://www.microsoft.com/sqlserver/2008/en/us/R2-editions.aspx

SQL Server 2008 R2 is a new version of SQL Server 2008, it's somekind of major release including new features (also some features from enterpise edition...

I understand your point of view, i admit my view of what is a "senior" DBA is influenced by my work, where some mistake/inefficiencies are not allowed (something you cannot...

Questions for an interview?

You might as well put it all in one post ...

Do a manual install and cancel before then end once the .ini configuration file has been generated.

You can then use the .ini to do a silent install with /CONFIGURATIONFILE="xxxxx.ini".

Check this...

Of course it does use a ton of space, creating a clustered index is like having a temp copy of your table.

If you have a 300GB table and you need...