hbpank (5/6/2011)

---

Hello All ,

Thanks for your input.

Actions i have taken.

1. Re-installed complete sql server 2008. -- Issue didn't resolved.

...

SELECT * FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY logid ORDER BY date DESC) AS TieBreaker FROM dbo.table2) dt WHERE dt.TieBreaker = 1

That works, but even on a fast san that'll take you 60 minutes... when apparently you have 0 tolerance.

You need to dig much deeper into your dr plans.

Fire at will. Maybe if you have a datetime stamp you could reinsert those as 2nd batch after the move is done and save them. But that's all...

I don't mess around with system tables.

I don't have problems calling procs tho (but I preffer to see EM do it first just to make sure I understand what's going...

I'd do it with the proc. If that fails, hopefully you'll have an error message!

OCTom (5/5/2011)

---

Grant Fritchey (4/29/2011)

---

I just talk about the information on a form, like a drivers license. It all gets stored somewhere and I'm the guy that manages the stuff that...

No but you could create 1 job per db, then use sp_start_job. Which will then make it parrallel.

This might very well explain your particular case

http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

What????????

My goal wasn't only the daily average, but more backup drive capacity planning.

Also it shows you the peak utilisations on the db so you can know when something's going /...

It's the...

Not that I know of.

Here's how you can do it manually :

http://www.sqlservercentral.com/articles/T-SQL/68467/

Check the section about "Populate the Test Table with Randomized Data"

That's why I check the avg / max for each log backup during the day.

It's easy to plan hd space and growth with that.

http://www.red-gate.com/products/sql-development/sql-data-generator/