Viewing 15 posts - 40,786 through 40,800 (of 49,571 total)
steve smith (2/25/2009)
Snapshot processes will not pick up new views.
Depends what you mean by snapshot.
Full database backups, at least for SS 2005, will backup the full...
February 25, 2009 at 8:53 am
I'd go for job or service broker.
February 25, 2009 at 8:51 am
srisagar_p (2/24/2009)
so deadlock occurrence is also high for me. Every time time i need to kill if a deadlock occurs through Kill command
Are you talking about blocking or deadlocks?...
February 25, 2009 at 12:30 am
What's the blocking resource?
Can you show some of the code?
February 25, 2009 at 12:30 am
senyorita (2/24/2009)
you mean to say that its impossible.
Yup.
February 25, 2009 at 12:25 am
chrisau168 (2/24/2009)
February 25, 2009 at 12:22 am
No way to tell from that, as the results have been cut off. Please run the following and post the results
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
February 25, 2009 at 12:21 am
aravind (2/24/2009)
Normally any company will have production server highly configured than the development server. So in that case how this could happen?"Production server slower than development server".
More users and hence...
February 25, 2009 at 12:19 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspx
February 25, 2009 at 12:17 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspx
February 25, 2009 at 12:17 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspx
February 25, 2009 at 12:17 am
developer6 (2/24/2009)
A co-worker of mine is adamant that the order of columns based on nullability is a total non-issue. Which one of us is correct?
Your colleague...
February 24, 2009 at 10:08 am
Bob Hovious (2/24/2009)
February 24, 2009 at 9:43 am
Mindy Hreczuck (2/24/2009)
I have a table in which the first two entries must always be particular parameters and then after that order doesn't matter.
Rows in a table have no defined...
February 24, 2009 at 9:42 am
Mindy Hreczuck (2/24/2009)
We ended up not being able to resolve this one, and got the developer to add an index hint if it determines the requisite index exists.
Post the exec...
February 24, 2009 at 9:40 am
Viewing 15 posts - 40,786 through 40,800 (of 49,571 total)