Viewing 15 posts - 11,356 through 11,370 (of 22,214 total)
TIMESTAMP is now a synonym in 2012. Just saw that the other night.
Like Gus says, ROWVERSION is the replacement. It's basically the same thing.
January 20, 2012 at 7:40 am
Ninja's_RGR'us (1/20/2012)
GilaMonster (1/20/2012)
Ninja's_RGR'us (1/20/2012)
I live far enough. Not worth to waste 4 days on this, but you on the other hand live much closer to her ;-).
Much closer? Maybe...
January 20, 2012 at 7:28 am
GilaMonster (1/20/2012)
Grant Fritchey (1/20/2012)
When it finds that, it identifies the least costly query by it's estimated cost and chooses that as the victim and initiates a rollback.
Just one minor...
January 20, 2012 at 7:27 am
Simha24 (1/20/2012)
So that we are planing to run every 6 hours.
When i issue DBCC Opentran() --...
January 20, 2012 at 7:22 am
Ninja's_RGR'us (1/20/2012)
Grant Fritchey (1/20/2012)
Ninja's_RGR'us (1/20/2012)
Isn't it better to use 1222 rather than 1204??Oh god. I can't believe I typed that. Yes, 1222 is better. I edited the post. Yikes.
I was...
January 20, 2012 at 6:12 am
ChiragNS (1/20/2012)
Grant Fritchey (1/20/2012)
Also you could be looking at a long compile time if the proc aged out of cache over night.
Will this result in such a huge performance degrade....
January 20, 2012 at 6:09 am
Ninja's_RGR'us (1/20/2012)
Isn't it better to use 1222 rather than 1204??
Oh god. I can't believe I typed that. Yes, 1222 is better. I edited the post. Yikes.
January 20, 2012 at 6:04 am
SQL Server doesn't have an in-memory setting. It works as it works and the disk is heavily involved. But if you're not seeing disk queuing, why would having everything in...
January 20, 2012 at 6:01 am
What is your physical usage of those 8 processors now? Are they maxed? Sustained greater than 50%? Or, are they like most systems, sitting around at about 10% with only...
January 20, 2012 at 5:56 am
Sounds like you need to run your log backups much, much more frequently. None of the mid-sized to large systems I've run would have worked well with a 6 hour...
January 20, 2012 at 5:55 am
There's an internal blocking monitor that observes all blocks and looks for places where that cross-referenced lock exists. When it finds that, it identifies the least costly query by it's...
January 20, 2012 at 5:52 am
Frequently with a linked server what happens is that ALL the data in referenced tables is brought across the wire and then filtered on the local server. If you use...
January 20, 2012 at 5:49 am
curly brackets like that are for ODBC escape sequencing. It'll work... most of the time, but you might get really strange results some of the time. I wouldn't do it....
January 20, 2012 at 5:09 am
Also you could be looking at a long compile time if the proc aged out of cache over night.
January 20, 2012 at 5:02 am
Good luck. The current version of the book doesn't emphasize wait stats nearly enough, so keep an eye on those. I hope the book proves helpful.
January 19, 2012 at 6:39 pm
Viewing 15 posts - 11,356 through 11,370 (of 22,214 total)