Viewing 15 posts - 6,436 through 6,450 (of 9,715 total)
Jeff Moden (2/16/2011)
CirquedeSQLeil (2/16/2011)
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne definitely requested code on the thread'
--yup that's the...
February 17, 2011 at 5:02 am
Tom.Thomson (2/16/2011)
CirquedeSQLeil (2/16/2011)
Peter Trast (2/16/2011)
CirquedeSQLeil (2/16/2011)
Peter Trast (2/16/2011)
Never been in this thread before but here it is:Antidisestablishmentarianism
Yes, it is a real word 🙂
Pseudoantidisestablishmentarianism
quasi-pseudo-antidisestablishmentarianism
semi-quasi-pseudo-antidisestablishmentarianism
hemi-demi-semi-quasi-pseudo-antidisestablishmentarianism
genuine simulated hemi-demi-semi-quasi-pseudo-antidisestablishmentarianism
@=)
February 17, 2011 at 5:00 am
GilaMonster (2/16/2011)
2) Error logging table. Purely because table variables ignore explicit transaction rollbacks
That is probably the best reason for using table variables that I've ever seen. I'll have to let...
February 17, 2011 at 4:53 am
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
Viewing 15 posts - 6,436 through 6,450 (of 9,715 total)