Viewing 15 posts - 17,026 through 17,040 (of 22,214 total)
I hate to pop everyone's bubble, but wasn't it established a while back that the 666 number is either a mistranslation or a bad copying job and tha thte actual...
July 14, 2009 at 9:22 am
It really depends on the configuration of your tables & indexes, but if the IN clause is causing poor performance, you could try creating a temp table, load the variables...
July 14, 2009 at 6:42 am
Bruce W Cassidy (7/13/2009)
Grant Fritchey (7/13/2009)
You mean if you change fonts you get better performance? Holy smokes! I've got to get some edits into the chapter on tuning...
[font="Verdana"]I'm also thinking...
July 14, 2009 at 5:34 am
jcrawf02 (7/13/2009)
Paul White (7/13/2009)
GilaMonster (7/13/2009)
Done, apparently, because 'null' is faster than NULLBut only if you use little letters (less aerodynamic drag = faster!)
...then he should use cursive...
You mean if you...
July 13, 2009 at 6:52 pm
Avg. Disk Sec/Read and Avg. Disk Sec/Write are the values you're looking for.
However, to see how your disk is performing, it's usually more useful to look at % Disk Time...
July 13, 2009 at 12:39 pm
Nowadays we use Operations Manager to monitor the servers and it will send out all kinds of email & IM's when a server goes offline. We also have Idera's Diagnostic...
July 13, 2009 at 12:34 pm
Since no one has suggested any books, I'll toss a couple out there. First off, for T-SQL, I'd suggest Itzik Ben-Gan's "SQL Server 2008 T-SQL Fundamentals." Great place to start....
July 13, 2009 at 9:31 am
If the PK consists of two columns, the FK must as well. You couldn't do it exactly as you've defined. You'd also need a ParentArea column.
If the ID column is...
July 13, 2009 at 9:23 am
The Advisor can catch some of the low hanging fruit that might need tuning, but I wouldn't hang my hat on its results, positive or negative. I've seen it suggest...
July 13, 2009 at 8:22 am
I didn't know PKD was buried in Colorado. I figured it was in California. He spent so much of his life there. Now I'm curious...
Found this:
http://www.findagrave.com/cgi-bin/fg.cgi?page=gr&GRid=1490
and this:
July 13, 2009 at 6:49 am
GilaMonster (7/13/2009)
Lynn Pettis (7/10/2009)
On a totally different subject, Anyone hear from Bob lately? Haven't seen him on SSC for a while.
For that matter, anyone heard from Grant? I think...
July 13, 2009 at 6:24 am
Phil,
Sorry I didn't respond to this sooner. I've been away (enjoying SUMMER as opposed to what's going on in New England these days). I always knew you were more than...
July 13, 2009 at 5:21 am
Oh, no. You don't want to capture it to the graph. You need to set up a counter log to capture the data to a file over time. I've got...
July 1, 2009 at 9:23 am
It's not that complicated. Take a moment in time, say now, measure your production system for a period of time, I usually try for 24 hours and do it on...
July 1, 2009 at 8:24 am
John Sansom (7/1/2009)
Grant, an “Annual Power Down” sounds like some sort of...
July 1, 2009 at 7:55 am
Viewing 15 posts - 17,026 through 17,040 (of 22,214 total)