Thank you for your response. It answered my question[:)]
Attempting to BCP a large resultset using a view and the queryout option. I have been playing with both the network packet size and the size of the...
First of all, yes TEMPDB is located on seperate disks. I am not having any issues currently with the process. It has been running for about a year on...
Not a problem. I am no expert here either. That is why I posted the question. Trying to understand the process better.
Yes, I did read that. But also in that same document there is a table that shows for each online rebuild, it has 0 in the sort runs. This is what I...
I am not sure why you would say that the SORT_IN_TEMPDB is meaningless. If you will notice that during the build phase there is a sort/merge step....
I have an automated process that generates and runs the alter index rebuild statements for each index in my database based on fragmentation. It has...
I have seen documentation that suggests the text columns may not be supported in future releases. You are better off switching to varchar(max). Also...
I have already read that paper and we had planned to schedule this during the less traffic hours. But I was more interested in what "Partition an...
I am doing some research on Partitioning and I came across this title during a search. I would like to find out more about how this can be...
try select *
try the following: SELECT PK_SalesId, avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats (DB_ID('DBOneshelp'), OBJECT_ID('tblSearch'),...
Separate names with a comma.
