This does exactly what you requested. Just test on a test db and see for yourself.

logicinside22 (12/8/2011)

---

thanks for reply ,Yes we have reporting enviornment and lots of reports runnning all the time .

so how we can chane that report to run only 1-2...

Get less users working on that system.

Nothing you can do about that.

1 exception is if you have a massive report running 1000s of queries. Then you can change that...

Hugo Kornelis (12/8/2011)

---

That's because GO is not a T-SQL keyword, but a batch seperator,...

dale.schwabjr (12/8/2011)

---

I agree. I am poking around. If I was to try to find performance bottlenecks, where would I start?

The main performance issue I can see is when running...

In general you should. As long as the backups are...

That may help. But that's rather far down the list.

Counters are counters. They are only useful when compared to themselves when the system was running well.

Many (most) metric...

You shouldn't guess at this.

Where is your bottleneck? Fix that.

Where's your new bottleneck.

Fix that, rinse repeat.

How did you come up with the answer "my biggest problem is disks for...

Check out the QOTD section. You can filter on categories. You also have access to a summary of your strengths & also how you compare against the rest...

Daniel Bowlin (12/8/2011)

---

Cadavre (12/8/2011)

---

Just to over-complicate matters . . . 😀

SELECT CASE WHEN GETDATE() > DATEADD(d, 24, DATEADD(m, 11, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0)))

...

I get very similar results... almost exactly the same figures!

Dev (12/8/2011)

---

Ninja's_RGR'us (12/8/2011)

---

No point in begging, they just don't care about us, only themselves. Just report to Steve and mark...

No point in begging, they just don't care about us, only themselves. Just report to Steve and mark it as reported and...

Cadavre (12/8/2011)

---

Here's a FOR XML PATH version.

SELECT STUFF((SELECT ',' + newRow

FROM (SELECT CONVERT(VARCHAR(4),newRow) AS newRow

...

Looks like someone played with the system tables to delete Fks or something evil like that.

If it's the case your backups will most likely be useless since the corruption will...