Viewing 15 posts - 41,401 through 41,415 (of 49,562 total)
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
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...
January 27, 2009 at 4:09 am
And even with a 3rd party tool, there's no way to edit a tran log backup.
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...
January 27, 2009 at 4:01 am
Niyala (1/27/2009)
The backup job is running, even after that particular event.The full-backup job is going perfectly well
Do you have transaction log backups?
January 27, 2009 at 3:56 am
There is absolutely no reason to have multiple log files. It gains you nothing. Log files are written in sequence, not in parallel. The only reason to have more than...
January 27, 2009 at 3:55 am
Parthipan (1/27/2009)
Please inform me, how can I take beta exam of 70-432 MCTS SQL 2008.
All of the 2008 exams are out of beta. Hence there's no way for you to...
January 27, 2009 at 3:51 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic643933-338-1.aspx
January 27, 2009 at 12:18 am
Make sure there's no shrink operation running, autoshrink or a scheduled shrink.
January 27, 2009 at 12:09 am
Viewing 15 posts - 41,401 through 41,415 (of 49,562 total)