Thanks for the reply and add'l detail. Glad to know that I was not missing something on the file size.

Jeremy.

I was confused by this post...

SanjayAttray (1/7/2010)

---

For us it actually/nearly crashed a server. Original DB size was 34.45 GB but snapshot grew more than 78 GB where the Disk...

Thanks for the article - I took a look and it still seems odd to me that a snapshot could be 2-3x's the size of the source db. If...

This does not seem intuitive to me (that a snap shot can can actually be bigger than that source db). Am I missing the obvious?

This maybe addressed in the recommended BOL articles, but if you are trying to get the 2 db's synced as closely as possible - I would recommend restoring the full...

here is the explaination I got after answering the quesiton incorrectly...

'SQL Server 2005 does not enforce the .mdf, .ndf, and .ldf file name extensions, but these extensions help you identify...

That does help. Now that I see I can essentially rename the nodes that appear - that will make it clear for the developers. I knew that I...

I have to say as a novice in the DBA continuum... I really appreciate the detailed comments surrounding the code snippets explaining why each piece was done this way (specifically...

egunther (7/14/2008)

---

thanks so much for your quick responses. cjeremy, i think your solution is very close. the only problem is i get an error message that says "The multi-part identifier...

Is there data that violates the money datatype? You could always play the shell-game... create a new column of type money update the new column, drop the old column,...

Alright... 1 more swing at this.

SELECT S.SchoolID, SUM(M.Usage) AS Usage, MAX(M.StartDate) AS EndDate

FROM dbo.BuildingChars AS BC

INNER JOIN dbo.Schools AS S

ON BC.SchoolID = S.SchoolID

INNER...

If I read this correctly what you want to do is this?

SELECT S.SchoolID, YEAR(M.StartDate) AS calendarYear, SUM(M.Usage) AS Usage, MAX(M.StartDate) AS EndDate

FROM ...

I actually did use this about a month ago... we had a new policy implemented...

I am actually interested in hearing if there are some systematic approaches to this as well. I am on the Jr. end of the spectrum and just tried my...

Thanks for the detail - that helps considerably.