Viewing 15 posts - 1,831 through 1,845 (of 18,926 total)
Since I assume this is a test server, what happened when you rebooted?
What's in the log for that DB?
October 20, 2011 at 7:22 am
adlakha.22 (10/20/2011)
what should i do? 🙁
Keep working with Chris... as I said I'm not doing 8+ hours of free tuning work here for a single issue. Apparently...
October 20, 2011 at 7:15 am
I assume you hit refesh on the list of dbs?
That's the only thing I can think that would cause this.
October 20, 2011 at 7:12 am
Grant Fritchey (10/19/2011)
Sorry, I was slow getting back here. Gail's answering everything. Just out of curiosity, what is the cost threshold for parallelism on your server?
This is what he meant...
October 20, 2011 at 6:31 am
Phone compagnies get Millions of new records daily. So do banks.
It's all about architecture and really knowing your stuff. Nothing to do with sql server limits.
October 20, 2011 at 6:29 am
Brandie Tarvin (10/20/2011)
And on a more serious note, I need help badly, please. This one has me totally confused and I...
October 20, 2011 at 6:26 am
ChrisM@Work (10/20/2011)
Quite possibly Remi, hence the test - but it could be worth it. I'd expect some improvement.
It can't.
It's either 99% faster or it's still a clustered index scan. ...
October 20, 2011 at 6:25 am
Plz explain to me what FTS does!
I know, Potato, Pôtato :hehe:
October 20, 2011 at 6:20 am
derek.colley (10/20/2011)
You're nicer than me. The tinyurl in my post above is a lmgtfy to the BOL.
Nice to see you are learning :-D.
October 20, 2011 at 6:16 am
Try running it once with valid parameters and then hit refresh for the fields list.
If that doesn't work it may be a bug I've once hit but the circumstances seem...
October 20, 2011 at 6:15 am
0.02$ that the filter returns too much data to consider a bookmark lookup ;-).
I'll say it again... all or nothing.
I applaud the effort tho 🙂
October 20, 2011 at 6:11 am
The dynamic sql is a whole new batch. Excluding temp tables, nothing else will be visible down there. That's why it doesn't see the variable.
You can concatenate it...
October 20, 2011 at 6:08 am
Greg Edwards-268690 (10/20/2011)
Ninja's_RGR'us (10/19/2011)
Fal (10/19/2011)
Steve Jones - SSC Editor (10/19/2011)
Nooooooooooooooooooooooooooooooooooo more pantsOkay people, you heard the guy. No more mentioning the word "pants". Got it?
Steve.
As if that ever...
October 20, 2011 at 6:04 am
The first wait is not an issue as by this (unless edge case I don't know about) : => http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
Put it in the exclusion list and run again plz.
October 20, 2011 at 6:03 am
Viewing 15 posts - 1,831 through 1,845 (of 18,926 total)