Viewing 15 posts - 8,821 through 8,835 (of 22,214 total)
What Gail says.
But, just a little bit of help without the details.
All those != commands are going to prevent good cardinality estimates from the optimizer which is likely to lead...
February 26, 2014 at 4:19 am
That value is for CLR procedures, not T-SQL procedures, per the documentation on sys.parameters. You can only pull out the defaults looking at the actual definitions of the procedures.
February 26, 2014 at 4:14 am
Yep, that one gets us all at one point or another.
February 25, 2014 at 3:23 pm
OldCursor (2/25/2014)
Now . . . if you enjoy it so much perhaps you could pop round and sort out my clients problems - it would save all that...
February 25, 2014 at 3:09 pm
No. That's not right. Any timeout like that would be from a different application or as part of a distributed query. Is this hitting a linked server?
February 25, 2014 at 12:39 pm
Rod at work (2/25/2014)
Grant Fritchey (2/25/2014)
humbleDBA (2/25/2014)
Grant Fritchey (2/25/2014)
Like I said in my first post, it looks OK, but you need to add WITH RECOVERY to the log restore too.
It...
February 25, 2014 at 12:37 pm
humbleDBA (2/25/2014)
Grant Fritchey (2/25/2014)
Like I said in my first post, it looks OK, but you need to add WITH RECOVERY to the log restore too.
It won't work if its being...
February 25, 2014 at 11:18 am
Could be lots of different reasons. It'd be hard to narrow it down without the specifics of the query and an execution plan. But, guessing, it could be that you...
February 25, 2014 at 11:17 am
MyDoggieJessie (2/25/2014)
Grant Fritchey (2/25/2014)
If you can't for some reason, then optimize for ad hoc, absolutely, and, possibly,...
February 25, 2014 at 9:52 am
Rod at work (2/25/2014)
Grant Fritchey (2/25/2014)
February 25, 2014 at 9:50 am
RonKyle (2/25/2014)
February 25, 2014 at 9:48 am
Yep. Those are the kind that I'd replace with some kind of parameterized query.
If you can't for some reason, then optimize for ad hoc, absolutely, and, possibly, forced parameterization. That...
February 25, 2014 at 8:18 am
Or any integrity issues get introduced by the restore process, which can happen. I wouldn't do it that way. Paranoia runs way too deep.
February 25, 2014 at 8:16 am
That's kind of nuts. I wouldn't even bother with log backups there. Just have the daily one since it's extremely likely you'll only ever be able to go to the...
February 25, 2014 at 8:15 am
quackhandle1975 (2/25/2014)
SQL2008R2? Are you in correct forum?Rgds,
qh
+Infinity
You're much more likely to get a lot more help posting in the 2008 forum rather than the 2014 forum.
February 25, 2014 at 8:10 am
Viewing 15 posts - 8,821 through 8,835 (of 22,214 total)