Or create an empty database one time, make a snapshot of it, run testing, and then restore from the snapshot before you start your next test.

Kit G (11/3/2010)

---

GSquared (11/3/2010)

---

Now that I think about it, the bigger database could probably be cut back to weekly or even monthly full backups, and nightly diff backups. Or...

select

DT1,

DT2,

MonthDiff =

datediff(mm,dateadd(dd,-14,a.DT1),dateadd(dd,-14,b.DT2))

from

( -- Test Data

select DT1=convert(datetime,'20100214')union all

select DT1=convert(datetime,'20100215')

) a

cross join

( -- Test Data

select DT2=convert(datetime,'20101114')union all

select DT2=convert(datetime,'20101115')

) b

order by

DT1,

DT2

Results:

DT1 ...

That link is about locating database files, not backups, on a share or NAS.

We backup several...

timothy bates (11/2/2010)

---

Accurate question. I think any question that uses a date with obvious notation to remove all ambiguity such as '2010-Jan-01' is fine. We clearly understand which...

For best accuracy, it is usually better to have all multiplication before all division operations in any language.

select

round(

( 100.00 * (CAST(b.MonthPop AS decimal(10, 2))-CAST(a.MonthPop AS decimal(10, 2)) ) )

/

CAST(a.MonthPop...

Why not just set the databases to simple recovery mode, and leave them like that?

You come to work in the morning to find that all the disks in the SAN cabinet were destroyed by a direct lightning hit and none of the databases are...

Events may have more dimension attributes than just time and they might have multiple date ranges involved. For example, a book signing might be in store 1 on Jan...

Did you set the database diagram to preview the page breaks so that you could see if they overlay page breaks? (Right-click on the back ground and click view...

If you are using DATETIME, these are better ways to get today at 00:00:00.000. The nested DATEADD and DATEDIFF are a more efficient way to do this conversion...

John Bates-251278 (10/29/2010)

---

Thanks Gsquared and Gsquared!

This is what I have: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

No SPs out yet for R2 - you...

As I said before:

SQL Server tables do not have reserved space.

If the backup was done to multiple files, you have to restore from all of them together.

If the backup was do to a single file and split into multiple files...

order by left(MyColumn,2)