Viewing 15 posts - 7,351 through 7,365 (of 9,401 total)
SqlMel (9/22/2014)
Good question.I anticipate many people will go for the NULL answer.
Yes they will. The concept is important, though. The presence of the row makes all the...
September 22, 2014 at 5:47 am
The Thread has a lot of history in it. I PMed Steve about it on Saturday and a few people really narrowed the time of deletion. He said...
September 22, 2014 at 5:41 am
TomThomson (9/22/2014)
wotd: Threadless (see [http://www.sqlservercentral.com/Forums/Topic1618108-61-1.aspx])
Memorial
September 22, 2014 at 5:39 am
sing4you (9/19/2014)
djj (9/19/2014)
TomThomson (9/19/2014)
Ed Wagner (9/19/2014)
djj (9/19/2014)
PirateShip
Trawler
Net
Neutrality
Control
September 19, 2014 at 7:29 pm
Lynn Pettis (9/19/2014)
GilaMonster (9/19/2014)
Database goes into Restoring mode
Performance tuning it so critical can any one plz figure it out...
September 19, 2014 at 9:13 am
Do you know what NOLOCK does? It may be perfectly fine in your situation, but you want to make sure you understand it.
http://www.jasonstrate.com/2012/06/the-side-effect-of-nolock/
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx
http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
September 19, 2014 at 6:09 am
HanShi (9/19/2014)
GilaMonster (9/19/2014)
Database goes into Restoring mode
Performance tuning it so critical can any one plz figure it out urgent...
September 19, 2014 at 4:04 am
This will get you a list of the sessions running, including the one you use to run the query.
select r.session_id,
r.blocking_session_id,
r.total_elapsed_time,
...
September 19, 2014 at 3:59 am
TomThomson (9/18/2014)
Jeff Moden (9/17/2014)
Luis Cazares (9/17/2014)
Do I see some personal/professional growth in these words? I really hope so.This Post is closed. I will research the issue.
Thanks.
Out of context, it looks...
September 19, 2014 at 3:12 am
I wouldn't use a maintenance plan either. Write a procedure to backup your databases instead. The log entries for the plans don't generally tell you what the problem...
September 18, 2014 at 8:31 am
Sean Lange (9/18/2014)
Ed Wagner (9/18/2014)
Sean Lange (9/18/2014)
Ed Wagner (9/18/2014)
Sean Lange (9/17/2014)
WayneS (9/17/2014)
Sean Lange (9/17/2014)
September 18, 2014 at 7:41 am
Sean Lange (9/18/2014)
Ed Wagner (9/18/2014)
Sean Lange (9/17/2014)
WayneS (9/17/2014)
Sean Lange (9/17/2014)
September 18, 2014 at 7:32 am
Roy Ernest (9/18/2014)
Ed Wagner (9/18/2014)
Roy Ernest (9/18/2014)
September 18, 2014 at 6:35 am
Roy Ernest (9/18/2014)
September 18, 2014 at 6:10 am
Viewing 15 posts - 7,351 through 7,365 (of 9,401 total)