Viewing 15 posts - 41,401 through 41,415 (of 49,571 total)
FNS (1/27/2009)
:ermm: Any suggestions how long this might take (in hours) so I can prepare for the phonecall of doom (at 3am when the server throws in the towel)
Unless your...
January 27, 2009 at 9:40 am
I believe it will take a shared table lock.
A noncluster on 50 million shouldn't take too long. It's creating clusters on big tables that slows things down a lot. Do...
January 27, 2009 at 9:28 am
srihari nandamuri (1/27/2009)
This will generate the Create Index script based on the queries that are executed on the server by checking the columnsused in equal/inequal /where clause.
Not a very...
January 27, 2009 at 9:27 am
srihari nandamuri (1/27/2009)
Comments please....
If you want to submit articles or scripts, please see the "Write for us" link in the menu on the left. That way anything you submit goes...
January 27, 2009 at 9:10 am
It's not the notruncate that will do it. I just put that in place so that the file size won't reduce and force grows. It's the shrink itself. Shrink works...
January 27, 2009 at 9:06 am
Christopher Stobbs (1/27/2009)
Would there be a big difference between using the num_ordem in the Key as to having it in an Includes?
In this case, yes. With it in the...
January 27, 2009 at 8:48 am
Christopher Stobbs (1/27/2009)
How about an Index on Cod_Batch and IND_ACTIVO with an includes for NUM_ORDEM?
If it's possible to change the group by and order by to be just the num_ordem,...
January 27, 2009 at 8:08 am
Just one question first. Why do you need to order by the varchar conversion of the NUM_ORDEM? Is there any reason why ordering by the NUM_ORDEM alone wouldn't work?
January 27, 2009 at 8:02 am
Oh, one other thing.
This script is only going to find indexes that are never used at all (no seeks, no scans, no lookups, no updates), because it's doing a not...
January 27, 2009 at 7:51 am
Jorge Mendes (1/27/2009)
Can you tell me how can i get the actual execution plan?
Run the query with the execution plan option on (button's a little further along the toolbar from...
January 27, 2009 at 7:22 am
Jorge Mendes (1/27/2009)
There's only one PK Cluster Index.
So no nonclustered indexes?
January 27, 2009 at 7:20 am
Does it give a syntax error? Does it give a runtime error? Does it give incorrect results? If an error, what error?
January 27, 2009 at 7:20 am
GSquared (1/27/2009)
I don't think the data he needs exists in that case, but I could be wrong.
I don't think so either. If it was run through SQL agent, in...
January 27, 2009 at 7:15 am
How often are you doing log backups and are they succeeding?
How big's the log file?
January 27, 2009 at 5:17 am
Rajesh kasturi (1/27/2009)
How do I update the logical fragmentation level of the index.
You can't. The logical fragmentation is calculated from the way the pages are arranged on disk. It's...
January 27, 2009 at 5:16 am
Viewing 15 posts - 41,401 through 41,415 (of 49,571 total)