Viewing 15 posts - 7,891 through 7,905 (of 49,571 total)
Stefan Krzywicki (9/10/2014)
GilaMonster (9/10/2014)
Stefan Krzywicki (9/10/2014)
Date columns as a varchar(7). What are you even putting in there? Still better than the date columns as Timestamp I guess.
Well, months have no...
September 10, 2014 at 10:03 am
Stefan Krzywicki (9/10/2014)
Date columns as a varchar(7). What are you even putting in there? Still better than the date columns as Timestamp I guess.
Well, months have no more than 31...
September 10, 2014 at 9:06 am
dinsab11 (9/10/2014)
I have rebuild index job setup every week. Questions:1. Do I need to run update statistics?
You don't have to, but it's a damn good idea. Column statistics...
September 10, 2014 at 9:04 am
Statistics would be the next thing to check. After that, the execution plan. After that, whatever the execution plan shows.
September 10, 2014 at 8:40 am
A log shipping secondary is supposed to be in the restoring state.
If it wasn't, then further log backups wouldn't able to be restored and the log shipping would be...
September 10, 2014 at 7:44 am
What error?
September 10, 2014 at 4:34 am
Don't use traceflag 1204 on SQL Server 2005 or above. If you want to use a deadlock traceflag, use 1222. But in SQL 2012 you don't need to use either...
September 10, 2014 at 4:29 am
Kinda hard without more information.
From the looks of that code, it should take single-row locks on the two tables (locking the inserted rows) and hold them until the end of...
September 10, 2014 at 3:49 am
kbhanu15 (9/10/2014)
1. When we will use SET XACT_ABORT ON in my procedures ?
a)if we have transactions in our proc then ...
September 10, 2014 at 3:46 am
In short, if you don't have explicit transactions (BEGIN TRANSACTION ...), there's no reason to have xact abort on. Xact abort defines whether an explicit or implicit transaction rolls back...
September 9, 2014 at 8:01 am
Above the blue bar with the forum name is a series of links. The last one "My Posts" will show you all of your posts.
September 9, 2014 at 7:55 am
Eirikur Eiriksson (9/9/2014)
September 9, 2014 at 7:52 am
pgmoschetti (9/9/2014)
- the four SQLExec are issued on four different threads
Then they will be run in parallel because SQL will just see 4 connections and 4 separate requests
September 9, 2014 at 7:48 am
skavijay (9/8/2014)
But after knowing this disable option just want to know expert opinion whether that might helpful to me or not?
No idea at all, because you haven't given any information...
September 9, 2014 at 4:38 am
Can you try running a checkDB with Tablock (will need exclusive access)?
September 8, 2014 at 9:29 am
Viewing 15 posts - 7,891 through 7,905 (of 49,571 total)