You can do a select on sys.indexes to get all the indexes in your DB.

You can do a select on sys.spatial_indexes to get all the spacial indexes (which you'll most...

Without dedicated disk you'll have to send him all the performance problem related to disk IO.

Dedicated disk = predictable stable performance, shared disk = You won't be able to tell...

It took so long because adding a clustered index is like rewriting your whole table into a new table + a sort + rebuilding the other non-clustered indexes.

The clustered index...

Don't use the execute query, create a data flow and use your query as a source and your file as an output (flat file or excel).

The thing is, if they don't even use 50% of the current CPU, something else is the bottleneck and they wont see any increase with more core of faster cpu.

Is it a 32Bits or 64Bits?

I guess 64Bits, but just wanna make sure 🙂

Do you have a lot of connections (thousands)?

Did you check the sql error log?

800-1000 concurent users is kinda a lot, so you'll need a better than average machine to keep up with the load spike (i guess in the morning and after lunch).

You...

You need a bit more info to get an answer:

- How heavily will the DB be used (how many concurent users, heavy queries or small queries, etc)

- The...

When there is something you don't understand in SSMS, fire up a trace and spy on it 🙂

If i recall correctly the queries used by the activity monitor are not...

You can either use table valued parameter in your stored proc (http://msdn.microsoft.com/en-us/library/bb510489.aspx), use global temporary table (##tableName) or use real table.

I guess the quantity are the latest value, so you wouldn't want to sum it.

Try this:Select b.Week, b.year , a.StyleCode, a.WarehouseID, a.Quantity

From #LookupInv a

Join (

Select datepart(WEEK,CONVERT(DATETIME,CONVERT(varchar,DateID),112)) Week, datepart(YEAR,CONVERT(DATETIME,CONVERT(varchar,DateID),112)) year, StyleCode,...

I don't know any books but if you need SQL server to try some stuffs you can download SQL Server Express from Microsoft.com and try a few tutorial queries.

You can...

The EXPIRE is not meant to remove data from your disk, it's meant to keep sql server from overwriting it before a specific date.

You have to clean the drive yourself...

10GB

Try this:

Select c.name, b.name, CASE WHEN COUNT(*) > 1 THEN 'Yes' ELSE 'No' END 'Partitioned'

From sys.partitions a

Join sys.tables b on b.object_id = a.object_id

Join sys.schemas c on c.schema_id = b.schema_id

Where a.index_id...