Viewing 15 posts - 5,461 through 5,475 (of 18,926 total)
My understanding is that the stats are updated only for the index that you rebuilt, not the columns "beside" the index.
Can anyone confirm this?
June 13, 2011 at 9:45 am
GilaMonster (6/13/2011)
Ninja's_RGR'us (6/13/2011)
GilaMonster (6/13/2011)
Another tidbit. Naming of transactions is purely for documentation (with one rare exception). It doesn't affect what and how things are committed or rolled back.
Ok I gotta...
June 13, 2011 at 9:23 am
GilaMonster (6/13/2011)
Another tidbit. Naming of transactions is purely for documentation (with one rare exception). It doesn't affect what and how things are committed or rolled back.
Ok I gotta know, what's...
June 13, 2011 at 8:51 am
Why would it not work fine? That would only depend on the requirements.
Another tidbit of information. You can use a table variable to log this info. It...
June 13, 2011 at 8:45 am
the if resets the @@rowcount to 0.
You need to save it to local variable like Lowell showed you and it'll work 100% of the time.
June 13, 2011 at 8:28 am
The logging must be the very next statement... (no print, if, NOTHING).
Can you post the code?
June 13, 2011 at 8:18 am
Congrats on the longest and thoroughest Sparkle ever! :w00t:
June 13, 2011 at 7:00 am
I've had to do a similar-ish task lately. We needed to find which rows in all tables had been modified between 2 backups .
Needless to say that figuring that...
June 13, 2011 at 6:57 am
Obfuscate the table name and column names if you have to. Jeff needs to see the structure more than anything else.
June 13, 2011 at 6:45 am
Please post the actual execution plan (not estimated).
June 13, 2011 at 6:41 am
what's unclear?
There's free space on the drive.
You create a db and it creates a 100 mb file.
There's NO DATA in that file because you haven't done any inserts in the...
June 10, 2011 at 10:23 am
Yes it is based on the "empty" space in the data and log files. It has nothing to do with the size of the drive.
When doing 1 mb it...
June 10, 2011 at 10:05 am
asm1212 (6/10/2011)
June 10, 2011 at 9:56 am
Please post the actual execution plan. Maybe we can spot something obvious.
I routinely run reports like this with 10 - 20 months of data straight from prod oltp db...
June 10, 2011 at 9:52 am
Viewing 15 posts - 5,461 through 5,475 (of 18,926 total)