Viewing 15 posts - 46,756 through 46,770 (of 49,571 total)
Not sure, but maybe put the SET ROWCOUNT inside the dynamic SQL.
May 2, 2008 at 9:59 am
Or on SQL 2005, SELECT min(login_time) FROM sys.dm_exec_sessions
May 2, 2008 at 9:56 am
Unless he knows enough about SQL to start it in single user mode.
May 2, 2008 at 9:42 am
schep021 (4/25/2008)
The plan is to set the max server memory to 6.5GB and min server memory to 1GB. I think all we need for switches is /3GB since the...
May 2, 2008 at 9:40 am
gcmcmahon (4/29/2008)
Is this even if they do not know the sa pwd?
Yes, and it works even if the server's in windows authentication only mode.
It's so that an admin cannot accidentally...
May 2, 2008 at 9:27 am
If we give you the answer, do we get the job?
I'll give you a hint, but that's all. The database in question still thinks it's replicated.
May 2, 2008 at 9:23 am
No.
A snapshot is just the old version of pages from the source DB that have changed since the snapshot was created. Removed from the source DB, it's meaningless as it...
May 2, 2008 at 9:06 am
Can you post the schema of the table please?
May 2, 2008 at 9:04 am
Irfan (4/29/2008)
April 29, 2008 at 3:29 pm
No. You should have either /3GB or /PAE enabled. Having them both on on a server with 16+GB memory is asking for problems.
April 29, 2008 at 2:55 pm
The database master key is used to encrypt other keys in the DB. It's not there to stop the DB being attached/restored onto another server.
Currently, the way to ensure that...
April 29, 2008 at 2:41 pm
That just means that the SPID that reported the condition is sleeping (waiting) until the mini-dump that's created has been written to the drive. You'll see that every time SQL...
April 29, 2008 at 2:20 pm
A index is either unique or it's not unique. To do what you want, you'll probably need a trigger, and it will hurt your insert/update performance.
April 29, 2008 at 2:15 pm
Hans Lindgren (4/29/2008)
toniupstny (4/29/2008)
The estimated cost is NEVER is a good estimate of the run duration of a query
No, it's not. The cost is based on the CPU usage, the...
April 29, 2008 at 2:12 pm
Jim Russell (4/29/2008)
April 29, 2008 at 2:10 pm
Viewing 15 posts - 46,756 through 46,770 (of 49,571 total)