Viewing 15 posts - 5,146 through 5,160 (of 18,926 total)
#1 make sure you take an extra backup before doing anything.
#2 rebuild ONLY that 1 index.
Since the problem is in a nonclustered index you should be able to drop it...
July 4, 2011 at 5:02 am
Why do you want to change job?
Maybe we'll find a good way to tell it to the interviewer.
July 4, 2011 at 4:55 am
The usual suspect is that you have used this type of syntaxe which works in the ssrs query generator, but then fails in the sp.
where something IN (@MultiSelectParam).
If you converted...
July 4, 2011 at 4:50 am
Lynn Pettis (7/2/2011)
Ninja's_RGR'us (7/2/2011)
Let's make it 6 out of 8.Censored.
Could be me, but I think this was a bit too much. We really should not attach the messenger but...
July 2, 2011 at 9:23 am
Since no other suggestions are comming through and you seem to have covered all the basics, I'd go through this.
When filtering the results go by CPU and you should find...
July 2, 2011 at 6:57 am
sqlnaive (6/30/2011)
How come Grant ? I saved it from the Execution plan tab once the query ran successfully.
Plz try again.
June 30, 2011 at 8:55 am
No I mean did you take daily full backups of the dbs using either sql agent or backup exec or anything else similar?
There are applications that can take full server...
June 29, 2011 at 3:47 pm
Where are your backups of those dbs? That would be by far the easiest route to take.
June 29, 2011 at 3:33 pm
Michael Valentine Jones (6/29/2011)
June 29, 2011 at 3:28 pm
Steve Jones - SSC Editor (6/29/2011)
Ninja's_RGR'us (6/29/2011)
June 29, 2011 at 2:23 pm
@steve-2, read the original question again. He is using the server to hold ±2 years of data in the main app for reporting reasons.
He's about to blow over the...
June 29, 2011 at 1:43 pm
Shot in the dark... could it be auto_close on?
June 29, 2011 at 1:09 pm
Grinja (6/29/2011)
Thanks for taking a look.
That is essentially the formula I have in place. However in my matrix totals I'm getting 1.35 for total price where I would like to...
June 29, 2011 at 1:04 pm
Viewing 15 posts - 5,146 through 5,160 (of 18,926 total)