Viewing 15 posts - 10,726 through 10,740 (of 22,213 total)
Ah, you know, I'm not sure. It might.
You're using traceflag 1222 to capture this?
June 19, 2012 at 8:17 am
Try using the OBJECT_ID function with the database and object ID that are part of the input buffer. That should narrow it down.
June 19, 2012 at 5:38 am
GilaMonster (6/19/2012)
Brandie Tarvin (6/19/2012)
"Surface"? Really?What kind of marketing department names a tablet with such a mundane moniker?
Surface was previously the name of their table computer (touch screen, about the size...
June 19, 2012 at 5:35 am
george sibbald (6/19/2012)
based on all the tables being about that size, I agree with you, you'll be glad to hear.not my post btw 🙂
Ooops. Just saw the question. Didn't look...
June 19, 2012 at 5:28 am
NO! Don't use readuncommitted or nolock. Those lead to differences in the data returned by the query[/url] and are generally not a good solution.
Instead, first, tune the query. All those...
June 19, 2012 at 5:24 am
george sibbald (6/19/2012)
Grant Fritchey (6/18/2012)
I doubt you're seeing major performance hits from the fragmentation, .why do you say that grant?
Just because, at least from what you've posted, the tables are...
June 19, 2012 at 5:03 am
Suresh B. (6/19/2012)
how to ensure that correct execution plan is created and used every time it executes ?
Add OPTION (HASH JOIN) at the end of the query.
how to check the...
June 19, 2012 at 4:51 am
WayneS (6/18/2012)
Me, your humble dba, from out of the blue, happened...
June 19, 2012 at 3:56 am
I doubt you're seeing major performance hits from the fragmentation, but I'd go ahead and defragment anyway. You're only storing, on average, 1.6 pages per extent, so you'll get some...
June 18, 2012 at 4:05 pm
Sapen (6/18/2012)
Just tried it and it worked. Assuming you're using the gui, delete the log file that it automatically tries to create. Remove that, then attach just the .MDF and...
June 18, 2012 at 12:33 pm
Lynn Pettis (6/18/2012)
Grant Fritchey (6/18/2012)
Lynn Pettis (6/18/2012)
Grant Fritchey (6/18/2012)
Lynn Pettis (6/18/2012)
Have to ask first, why are you trying to attach the mdf file without its associated ldf file?
That's how you...
June 18, 2012 at 11:58 am
Lynn Pettis (6/18/2012)
Grant Fritchey (6/18/2012)
Lynn Pettis (6/18/2012)
Have to ask first, why are you trying to attach the mdf file without its associated ldf file?
That's how you get the 2012 OLTP...
June 18, 2012 at 11:41 am
Stueyd (6/18/2012)
June 18, 2012 at 11:39 am
Just tried it and it worked. Assuming you're using the gui, delete the log file that it automatically tries to create. Remove that, then attach just the .MDF and it...
June 18, 2012 at 11:00 am
Lynn Pettis (6/18/2012)
Have to ask first, why are you trying to attach the mdf file without its associated ldf file?
That's how you get the 2012 OLTP AdventureWorks2012 sample database. It's...
June 18, 2012 at 10:57 am
Viewing 15 posts - 10,726 through 10,740 (of 22,213 total)