Viewing 15 posts - 6,106 through 6,120 (of 18,926 total)
#1 culprit is reindex job
#2 is big dataloads
So which one is it?
Keep in mind that you can have something like backupexec or any 3rd party app connect to the server...
May 16, 2011 at 5:27 am
You can guess all you want with the names which will give you false positive and incomplete data.
Plan B is to read all the queries and figure them out from...
May 16, 2011 at 5:26 am
I'd never setup QA with less data than prod... for that exact reason.
Also I'd ALWAYS use the actual execution plan especially at that stage where this is the final check.
As...
May 16, 2011 at 5:24 am
Timestamp is a row version. It is all maintained automatically by the server.
If for some reason you need to keep an exact copy of the value in an audit...
May 16, 2011 at 5:22 am
Welsh Corgi (5/15/2011)
I'm sorry. I will not post again to this forum. Best regards to everyone.
Why are you sorry???
May 16, 2011 at 5:14 am
Welsh Corgi (5/15/2011)
I'm wondering about misuse of the forum.
What misuse??
May 15, 2011 at 6:54 pm
Welsh Corgi (5/15/2011)
I never saw that clsifucation before...
That's why it's being given to you now... enjoy.
May 15, 2011 at 5:45 pm
GilaMonster (5/15/2011)
Ninja's_RGR'us (5/15/2011)
In general, it's better to return the correct data.*snigger*
Well it always depends!
I've never had a client who didn't care about 100% accuracy but I know it can happen.
I...
May 15, 2011 at 5:43 pm
Yes it's fully R2 (system table wise). IIRC, the db will still be in 90 mode. You need to manually change it to 100.
May 15, 2011 at 5:41 pm
Jeff Moden (5/15/2011)
Ah... I finally get the irony of your post, Remi. 🙂
Actually it was like 4 threads... all cases of RTFM. and listen to us when you ask for...
May 15, 2011 at 5:40 pm
:w00t:
What link is that Jeff?
Looks like you're catching up the backlog of e-mails or something... thread ended over 10 days ago!
May 15, 2011 at 3:44 pm
Syed Jahanzaib Bin hassan (5/15/2011)
Database does not have any edition,Database have compatibility option in the advanced option of databaselike 80 for 2000 , 90 for 2005 ,10 for 2008
Not completely...
May 15, 2011 at 3:40 pm
sqldba_icon (5/15/2011)
i was looking more in general. Thanks
In general, it's better to return the correct data.
Now once you read Gail's post you'll realize that the optimizer's pretty smart and will...
May 15, 2011 at 3:36 pm
copy / paste, setup daily runs and you're done.
May 15, 2011 at 3:34 pm
ya but they contract, so the net result is 0 change. And most likely by the time you get the alert there's nothing left to do.
May 13, 2011 at 6:06 pm
Viewing 15 posts - 6,106 through 6,120 (of 18,926 total)