If the plan is good, then might be due to the volume of data pass through the network..
Thanks Franks. Let me have try..
Understood. The table is quite huge, almost 5 Billion records, and the index created unusual empty space, it grabbed almost 600 gb extra space from...
Can someone suggest how to reduce the data file unused space which was increased after the reindex processes. Do not want to shrink the file since it...
Hello, I would like to know how the TFS database backups are scheduled by default? When i checked in SQL server agent job, there is no job scheduled...
I don't think i can get like "IF EXISTS (...." it gives IF NOT EXISTS (
Guys, How do I script out all the database objects with IF EXISTS clause. I need the script like below IF EXISTS (SELECT * FROM sys.objects WHERE...
Yes, the table is already partioned!!
I tried to reorganise the index initially, but it took long time (around 40 Hours), so i drop that method. Now i am tring to do the reindex offline...
Not much, since the issue is "taking time". I need to go for some technique to reduce the indexing time. I have procedure to find out the fragmented...
No, I donot want all, however those have frag > 10% I should do. As mentioned the big tables needs to do the reindexing periodically (i mean atleast...
Hi Guys, I have a table with more than3 Billion records nad tried to rebuild the indexes. the rebuild has ran around 16 hours but still not finished...
Seems you need to hold the function result and the successfull execution of sproc you need to execute the function right..if this is the scnario you...
Satya, The table have only one index, however some of the tables in the database is huge..The database is more than 2TB. so now other than the below...
Hi Guys I have an issue with dm_db_index_physical_stats, it is taking long time (around 30 Min) to retrive the result against a table having 50...
I need the result in separate column, i am expecting the below result as per the query ID ACTIVE DATE INACTIVE DATE ----...
Hi Guys, I have a table, below is the sample script, i tried to pivot the table based on the status (below mentioned query) i am getting 1 record...
Hello all, I have a migration project, some time I need to compare the databases (both source and target db are sql server 2008), since the data may...
[:$] It is in SQL server 2008, SQL server management studio (ssms) ..not enterprise manager [:(]
Soory for the confusion! See the below example, I have created the below table type, now I got the below script from the enterprice manager [generate...
Separate names with a comma.
