Viewing 15 posts - 39,526 through 39,540 (of 49,571 total)
usman.tanveer (4/24/2009)
April 24, 2009 at 1:02 pm
No odd characters, I checked, deleted and retyped pieces by hand. There's just a new line between the two (CR LF). I was wondering if I was missing a batch...
April 24, 2009 at 11:44 am
Integrity checks of the system databases (master, model, msdb) are highly recommended. Corruption in those can be very hard to fix if you don't have a clean backup, and without...
April 24, 2009 at 11:30 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic704057-359-1.aspx
April 24, 2009 at 11:28 am
If all queries were coming from the same connection, there would be no blocking in the first place.
I don't understand your concern with snapshot. It's an optimistic concurrently level that...
April 24, 2009 at 11:06 am
Please post some existing sample data from the table. The very first link that I gave you shows how to do that easily.
Why can't you change the table structure?
April 24, 2009 at 10:37 am
Check the SQL error log. Any errors or prints from a logon trigger go in there.
I would suggest wrapping the code in a TRY.. CATCH block and have the catch...
April 24, 2009 at 10:29 am
If your indexes are all optimal you should be getting row-level locking anyway.
Have you considered snapshot isolation? It'll hit TempDB hard if you have that much activity, but you'll have...
April 24, 2009 at 10:24 am
Jeffrey Williams (4/24/2009)
What Gail was trying to get at is that overwriting an existing file destroys any maintenance plan you setup.
Note to self. Get to the point..., 😉
...
April 24, 2009 at 10:07 am
usman.tanveer (4/24/2009)
April 24, 2009 at 9:48 am
Jeffrey Williams (4/24/2009)
sharanurampur (4/24/2009)
I too don't know the exact problem, what I am predicting is we are having 2...
April 24, 2009 at 9:46 am
Grant Fritchey (4/24/2009)
April 24, 2009 at 9:41 am
One thing I would like to get clear.
Are you backing up the transaction log to the same file every time?
Do you have the overwrite option specified?
April 24, 2009 at 9:40 am
Steve Jones - Editor (4/24/2009)
The functionality is there for design and DBAs, not normal use, and not daily use.
And auditing. In fact, I'd almost go as far as saying...
April 24, 2009 at 9:39 am
Viewing 15 posts - 39,526 through 39,540 (of 49,571 total)