Viewing 15 posts - 6,421 through 6,435 (of 9,707 total)
Grant Fritchey (2/17/2011)
jcrawf02 (2/17/2011)
Brandie Tarvin (2/17/2011)
Koen Verbeeck (2/17/2011)
Gianluca Sartori (2/17/2011)
Code brings more (pseudo)code, it seems...Definitely kill the one who started this on THE THREAD!
:-D:-D
I'll go fetch the angry mob! 🙂
I'll...
February 17, 2011 at 7:20 am
I rarely blog about technical stuff, mostly about writing. Today, I blogged about SQL Server and fragmentation. (It's a rephrase of something I just posted in another thread).
If anyone is...
February 17, 2011 at 6:32 am
I should point out that some people don't recommend defraggin SAN drives (for some very interesting reasons). Check out this link before doing any defragging:
http://www.las-solanas.com/storage_virtualization/san_volume_defragmentation.php
EDIT: Sjeff, I just realized you're...
February 17, 2011 at 5:33 am
Koen Verbeeck (2/17/2011)
Gianluca Sartori (2/17/2011)
Code brings more (pseudo)code, it seems...Definitely kill the one who started this on THE THREAD!
:-D:-D
I'll go fetch the angry mob! 🙂
I'll supply the torches! (Who's responsible...
February 17, 2011 at 5:03 am
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
Viewing 15 posts - 6,421 through 6,435 (of 9,707 total)