Viewing 15 posts - 39,766 through 39,780 (of 49,571 total)
Musène Jonas (4/14/2009)
I am so clear, but these check have to be made every week if i do not want to loss many data
Sorry, I don't understand.
Index maintenance has nothing...
April 14, 2009 at 1:53 pm
Job? Windows Service? You're typing the password wrong? Registered servers with wrong credentials?
April 14, 2009 at 1:27 pm
If you can post the full error, with the error number, severity, line and state, we can tell you why the login failed. From what you've posted, the only thing...
April 14, 2009 at 1:25 pm
Bob Hovious (4/14/2009)
That's cruel.
What is? Lynn's reply?
April 14, 2009 at 1:23 pm
Pieter (4/14/2009)
Msg 15274, Level 16, State 1, Line 1Access to the remote server is denied because the current security context is not trusted.
Gut feel is that's due to the linked...
April 14, 2009 at 1:21 pm
Lynn Pettis (4/14/2009)
Gail, see the latest on this one you were just on?
I saw it. I had a half-written, very snarky reply that I deided was better not posted. Besides,...
April 14, 2009 at 1:17 pm
Does it throw an error, or just not do something that it's supposed to?
April 14, 2009 at 1:02 pm
April 14, 2009 at 12:57 pm
It's very hard to say what causes a dip in cache hit ratio. In fact it's difficult to work out when sitting in front of the server with full access...
April 14, 2009 at 12:54 pm
That doesn't tell us anything.
In fact, I can't give you a hard and fast number for how often anything should be done.
Backup frequency: depends on your SLAs and your acceptable...
April 14, 2009 at 12:52 pm
What you're seeing there is the code that Management studio is running to get the results displayed by Activity Monitor. That's what management studio runs when you look at a...
April 14, 2009 at 12:39 pm
ReadUncommitted and NOLOCK have the same effect. Only difference is that specifying SET TRANSACTION ISOLATION LEVEL READUNCOMMITTED affects every single table within a select statement until the connection closes or...
April 14, 2009 at 11:48 am
The answer to all three is whatever you specify, nonclustered by default.
ALTER TABLE ... ADD CONSTRAINT ... UNIQUE CLUSTERED -- creates a clustered index to support the unique constraint. Will...
April 14, 2009 at 11:44 am
Jackal (4/14/2009)
However I was just wondering on the exact mechanism that SQL will use to resolve these, will it utilise tempdb for this operation?
No, it's just a table...
April 14, 2009 at 9:01 am
ANSI - American National Standards Institute. It's an organisation that sets standards
ACSII - American Standard Code for Information Interchange. It's a standard for encoding of characters in binary.
April 14, 2009 at 4:57 am
Viewing 15 posts - 39,766 through 39,780 (of 49,571 total)