Viewing 15 posts - 39,436 through 39,450 (of 49,571 total)
Lynn Pettis (4/28/2009)
The desert is looking good again...
I might join you this time. For some reason some of the posts over the last few days have been getting to me,...
April 28, 2009 at 12:11 pm
MSDE (Desktop engine) is a free restricted version of SQL 2000. It has a number of limitations built into it, one of which is a 5 connection limit. As soon...
April 28, 2009 at 12:09 pm
Grant Fritchey (4/28/2009)
You can get two plans into the cache through parallelism. I've done it and seen it.
Mind sharing the secret? Nothing I've tried gets me both a serial and...
April 28, 2009 at 12:00 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic705985-357-1.aspx
April 28, 2009 at 10:22 am
riga1966 (4/28/2009)
I did.I started two traces yesterday.
But apparently one of them caused disk space issues on C: drive on production server. (Oops!)
Don't use the profiler GUI, use a server-side trace....
April 28, 2009 at 10:17 am
michael vessey (4/28/2009)
April 28, 2009 at 10:14 am
The error is saying that the log has been truncated sometime since the last full or diff backup. Look for jobs that run BACKUP LOG ... WITH TRUNCATE ONLY or...
April 28, 2009 at 9:21 am
riga1966 (4/28/2009)
Now the problem is to figure out what SQL causes these timeouts.
Try running a trace.
April 28, 2009 at 9:18 am
Paul White (4/28/2009)
GilaMonster (4/28/2009)
Set options and users, yes, different plans, however not reusable without exactly the same userID and/or set options.
I think it is OR there, rather than AND. ...
April 28, 2009 at 8:35 am
Laerte POltronieri Junior (4/28/2009)
April 28, 2009 at 8:22 am
Tao Klerks (4/28/2009)
OK, now I'm more confused than ever.
Sorry, my bad.
parameter sniffing is the ability of the SQL Server optimiser to know the values of parameters passed to a...
April 28, 2009 at 8:07 am
Paul White (4/28/2009)
April 28, 2009 at 8:02 am
Viewing 15 posts - 39,436 through 39,450 (of 49,571 total)