Viewing 15 posts - 41,386 through 41,400 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 7:22 am
Jorge Mendes (1/27/2009)
There's only one PK Cluster Index.
So no nonclustered indexes?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 7:15 am
How often are you doing log backups and are they succeeding?
How big's the log file?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 5:16 am
How often? Is it succeeding?
It's possible that the error came about when the log had to grow and the grow took too long. What's the auto-grow settings on the log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 4:09 am
And even with a 3rd party tool, there's no way to edit a tran log backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 4:03 am
gilk (1/6/2009)
BACKUP LOG @vdatabase WITH TRUNCATE_ONLYDBCC SHRINKFILE(@vdatafile,10)
Anyone who decides to use this should note two things.
1) The backup log with truncate will break the log chain. Hence an immediate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 4:01 am
I'll take a look when I get a few min.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 3:57 am
Viewing 15 posts - 41,386 through 41,400 (of 49,552 total)