Viewing 15 posts - 41,386 through 41,400 (of 49,560 total)
John Reid (1/27/2009)
January 27, 2009 at 9:59 am
Bob Hovious (1/27/2009)
January 27, 2009 at 9:50 am
Lee Hart (1/27/2009)
The way things are generally done here at my work, is the backup file is just manually deleted and a backup is re-run. No biggy...I guess.
No biggie?
By...
January 27, 2009 at 9:48 am
Steve Jones - Editor (1/27/2009)
I thought you could configure flat file logs, but I'm not sure how "queryable" they would be with OPENQUERY.
I'm pretty sure that logs can be configured,...
January 27, 2009 at 9:47 am
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
Viewing 15 posts - 41,386 through 41,400 (of 49,560 total)