Viewing 15 posts - 31 through 45 (of 49 total)
thanks noeld. appreciated.
http://www.sql-server-performance.com/sql_server_performance_audit8.asp
had some good words as well.
April 12, 2005 at 2:06 pm
by that rationale, if I switched to 'like' and '=' instead of 'not like' and '', I should see the performance difference fade, right? I'm not seeing that in...
April 12, 2005 at 1:45 pm
rockin suggestion john. Here's my uber-quality @message now...
SevernTicker: cyCAD -- country updated to 'QQ'
NTLOGIN: greg johnson
MACHINE: CT-DEV-05 ...
April 6, 2005 at 12:51 pm
nice. thanks for the suggestions gang.
April 5, 2005 at 6:41 am
you're right on testing @@error. I should be testing @localerr. point taken.
The issue however, is the fact that NO CODE after the failing statement in spfoo gets executed,...
March 15, 2005 at 1:11 pm
I just ran the BOL example, and it worked like expected (rows 1 and 3 added). I made it a point to run it in our production database. ...
March 15, 2005 at 12:45 pm
Happily Wayne. Thanks for the response. Some of the spfoo code may have changed as I've been working on it, but the error will still be apparent. ...
March 15, 2005 at 12:26 pm
thanks gang. you've confirmed my suspicions about RESTORE DATABASE capabilities:
(schleep: "... what I have not tried is consolidating files, which is what I gather you're trying to do.")
I didn't...
February 3, 2005 at 1:48 pm
Thanks Old Hand, but...
I was hoping for some command that would cause the restore command to recognize that there's a database of the same name on the new computer already...
February 3, 2005 at 1:10 pm
Danke Zehn PW. That helps a lot. Looking forward to Yukon even more now.
January 26, 2005 at 10:57 am
Thanks mom, but actually, I found this sweet link that seems to be working:
http://support.microsoft.com/?id=290991#4
dig it!
January 19, 2005 at 9:05 am
I'm having a brain drizzle:
Servers:
How many CPU's?
How many different physical drives?
What's the RAID setup?
How much space on the hard drives?
How much RAM?
Set up a perfmon with a good...
January 10, 2005 at 6:36 am
Highest cardinality first. I'm going to make it so. Thanks.
I'm a grasshopper!
December 31, 2004 at 11:37 am
Yes, it is a datetime field.
Are you saying SQL will ignore indexes with a datetime field as the first column in the index? I have evidence otherwise in...
December 31, 2004 at 11:32 am
I've used 'set rowcount 10000' on more than one occasion. It doesn't do much for speeding things up, but it at least lets the process come up for a...
December 30, 2004 at 7:16 am
Viewing 15 posts - 31 through 45 (of 49 total)