Viewing 15 posts - 17,506 through 17,520 (of 22,214 total)
How long since the last execution did you query the dmv's? If it's hours or minutes, you may have a serious memory issue. If it's days or weeks... not at...
May 8, 2009 at 8:40 am
Just hit the microsoft documentation. There's tons of information available there.
May 8, 2009 at 8:37 am
The error is very straight forward. You've got duplicate data. The key is to identify what constraints you have and then break down the procedure and capture the data output...
May 8, 2009 at 8:36 am
To eliminate the key lookups you need to make the non-clustered indexes into covering indexes by either adding columns needed to the key or as included columns. But you need...
May 8, 2009 at 8:33 am
Only use nvarchar if you are absolutely going to be using the extended character sets. If you're just using some of the ascii characters with umlauts or whatever, you just...
May 8, 2009 at 8:01 am
I'm 46 and I think I'm going to try being a geek forever. I'm just not the management type and I really like playing with toys. I know an MS...
May 8, 2009 at 6:15 am
Whoa! I didn't notice that guy had 1200 posts. What the heck is up with that? You take that much time and you still don't get silly fundamentals? And I'm...
May 7, 2009 at 6:24 am
What about good?
What about evil?
What about right?
What about wrong?
Is there a Vorlon in the building?
May 7, 2009 at 6:13 am
Profiler would be my first choice.
Second wouldn't be sp_who2. It'd be sys.dm_exec_requests. With that you can link to other dmv's to get query text, execution plans... whatever you need. But,...
May 7, 2009 at 6:08 am
To heck with google. Open up Books Online. A lot of, most, of the information you need is in there. You don't need to go googling until or unless you...
May 7, 2009 at 6:05 am
Nice job Sylvia,
When you kick up this much mud, you did well.
I do need to disagree with you though. Picking and choosing when to alias or when not to leads...
May 7, 2009 at 5:50 am
RBarryYoung (5/6/2009)
Grant Fritchey (5/6/2009)
Lynn Pettis (5/6/2009)
sorry, crushed you will be.
I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly...
May 6, 2009 at 2:59 pm
Lynn Pettis (5/6/2009)
sorry, crushed you will be.
I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly Darth, but Darth...
May 6, 2009 at 12:53 pm
Can you run a query against sys.dm_tran_locks? That will give better information. Specifically we need to see the entity_id, the object getting locked.
May 6, 2009 at 12:50 pm
Viewing 15 posts - 17,506 through 17,520 (of 22,214 total)