GilaMonster (10/22/2011)

p.s. As a consultant, accepting work that you don't know how to do is not a particularly good idea. Mess up and that's a client that won't want your...

thanks for that, so would the following query give me the size of the data cache ( not plans or anything)?

select count(*)*8/1024 AS 'Cached Size (MB)' ...

im on my local machine with my local instance, and i got the error: Cannot connect to Admin:.

I only get it when DAC is disabled. i think i...

Absoluely spot on Elliot, thanks a mil.

Next question. SSIS is a shared component. if i installed a named instance first and then the default, would SSIS be part of the...

This is perfect ( well,...

Jayanth_Kurup (9/16/2011)

---

http://technet.microsoft.com/en-us/library/ms188388.aspx

WITH (<single_partition_rebuild_index_option>)

SORT_IN_TEMPDB, MAXDOP, and DATA_COMPRESSION are the options that can be specified when you rebuild a single partition (PARTITION = n). XML indexes cannot be...

Your still copying data via a new structure. Can you just alter the table ter the table to remove the partition layout?

Cool, thanks for the confirmation. For a moment i wondered how i could be in the industry for a number of years and not know about inserting into indexes!

but does "insert into a clustered index" basically mean "insert into a table with a clustered index"?

I dont know why he would specify to insert into a clustered index.

Connections are expensive to create in sql server and this is why sql server uses Connection Pooling by default.

Connections that are not in use are put into a pool and...

I have found the row count per partition. If i cross apply on the function sys.dm_db_index_physical_stats I can then pull the record_count which is the rows per partition.

I still cannot...

Thanks Gail! Now that my suspicions are confirmed I can expirement further.

super useful! thanks!

Figured it out. you need to use the fully qualified path to the ini file, even if your PWD is the one the ini file is in. strange!

serverside trace thats always running, looking for deadlock events, deadlock chains and lock timeouts.

For extra points describe how the trace files are set to a max size to ensure they...