Viewing 15 posts - 30,571 through 30,585 (of 39,754 total)
I got some conflicting ideas from people at MS. Someone was going to try and dig in (and blog) on this, but they've been out of the 2000 code for...
November 29, 2007 at 8:14 am
I'm slightly confused. Do you mean 2 drives as in 2 LUNs? Or 2 physical drives?
If tempdb is used a lot, it could benefit from a separate LUN, but it...
November 29, 2007 at 8:10 am
I agree with Yvan, but the short answer is you can't stop someone with sa or sysadmin permissions from changing the objects or permissions.
November 29, 2007 at 8:06 am
It really doesn't matter how it was installed. This an administrative license only. What matters is that you have the administrative licenses in a file cabinet and you are abiding...
November 29, 2007 at 8:05 am
#2 first: User sp_changeobjectowner to reset the owner of the new table to Lester.
#1: Did the db originally have 2 files for each? Lots of people like this, makes it...
November 29, 2007 at 8:03 am
Do not put your logs on a single disk. Keep it as a hot spare, let performance suffer and someone will eventually spring for disks.
Hardware is cheap. You've probably blown...
November 29, 2007 at 8:00 am
Hard to say on that, but everyone seems to be recommending quad cores where possible.
November 29, 2007 at 7:57 am
Same OS/ SQL versions?
That sounds a little suspicious, but you've got less threads executing simultaneously, so it might make sense.
November 29, 2007 at 7:56 am
Yeah, offline would be better ;), didn't think of that.
I'd do autoclose or offline because that way the db still is on the server, it keeps it in your mind,...
November 29, 2007 at 7:54 am
Profiler will do it. Autoclose is a quick and dirty way to check. Easy to scan logs, don't have to remember to turn it on, etc. If you're not experienced,...
November 28, 2007 at 7:39 pm
Use the Unicode character instead?
Directly pick the character using CHAR(xxx) where xxx is the right code.
November 28, 2007 at 7:32 pm
I've seen in the Scheduled Task items that if you schedule it to run for 2 hours, even though you say every hour, it only runs once or twice.
As for...
November 28, 2007 at 7:31 pm
Are you running them all in the same batch in both situations?
You could try a stored proc instead and use WITH RECOMPILE.
November 28, 2007 at 7:17 pm
Viewing 15 posts - 30,571 through 30,585 (of 39,754 total)