Viewing 15 posts - 6,436 through 6,450 (of 9,715 total)
Sjeef (2/16/2011)
Won't my sql datapages get really fragmented as a result of this "file" defrag action.?
Logical defragmentation is not the same thing as physical defragmentation. SQL Server doesn't have a...
February 17, 2011 at 4:51 am
Grant Fritchey (2/16/2011)
Brandie Tarvin (2/16/2011)
February 16, 2011 at 12:36 pm
SQL is assuming the _1 is forcing a trace number. Remove it.
exec @rc = sp_trace_create @TraceID output, 0, N'\\servername\D$\Folder\Trace_1', @maxfilesize, NULL, @filecount
Should be
exec @rc = sp_trace_create @TraceID output, 0, N'\\servername\D$\Folder\Trace',...
February 16, 2011 at 12:15 pm
The best way to deal with this issue is to work with the people who own the automated files.
Here's what I would ask for:
1) Keep the # of...
February 16, 2011 at 12:13 pm
GAH. Got the name of the antho wrong. A Career Guide to Your Job in Hell, not "from Hell."
Sorry, folks.
February 16, 2011 at 12:06 pm
Not to take away from Grant's book, but if you need information fast, Google "SQL Server Performance Tuning." There are literally hundreds of articles out there. Or search this site,...
February 16, 2011 at 12:03 pm
What response are you getting that is telling you you can't create RollOver files? Post the exact error message (type or cut-n-paste) please.
February 16, 2011 at 11:59 am
So you have a file with multiple, repeatable column headers. How is this file generated? Is it automated or does a person fill in the sheet?
EDIT: If automated, what sort...
February 16, 2011 at 10:46 am
Jack Corbett (2/16/2011)
GSquared (2/16/2011)
GilaMonster (2/16/2011)
GSquared (2/16/2011)
I blame Wayne. Execution at noon.Who's noon?
No, Who's on first.
I don't know!
Third base!
February 16, 2011 at 8:50 am
You need to check out Gail's blog. She has a very interesting discussion on this one:
http://www.sqlservercentral.com/Forums/Topic415829-338-1.aspx
EDIT: Whoops. The first link was wrong.
http://sqlinthewild.co.za/index.php/2007/12/19/temp-tables-and-table-variables/%5B/url%5D
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/%5B/url%5D
February 16, 2011 at 8:22 am
Fal (2/16/2011)
D'OH!I knew I should've lurked longer. But no, I had to help someone! 😛
Steve.
Aw. It's okay. We won't tar and feather you for being helpful and posting...
February 16, 2011 at 6:50 am
GilaMonster (2/16/2011)
Brandie Tarvin (2/16/2011)
In fact, if the database is online and suspect, a restart might make the db completely unrecoverable.
Not quite.
Restarting SQL when there's a corrupt database could take...
February 16, 2011 at 6:10 am
Sorry. The spelling in your post confused me. All I could understand was "after you answer the question, try restarting."
February 16, 2011 at 5:39 am
Well, since someone broke the "no technical talk in The Thread" rule...
Guess what I discovered this morning? Severity 21 errors can be caused by full disk drives. Nothing's actually...
February 16, 2011 at 5:31 am
Viewing 15 posts - 6,436 through 6,450 (of 9,715 total)