Viewing 15 posts - 1 through 15 (of 26 total)
Thanks for the reply and add'l detail. Glad to know that I was not missing something on the file size.
January 11, 2010 at 2:43 pm
I was confused by this post...
January 11, 2010 at 2:15 pm
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...
January 11, 2010 at 12:42 pm
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?
January 11, 2010 at 10:00 am
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...
December 3, 2009 at 6:56 am
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...
December 3, 2008 at 12:25 pm
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...
October 14, 2008 at 1:34 pm
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...
September 17, 2008 at 4:57 am
July 14, 2008 at 12:20 pm
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,...
July 14, 2008 at 12:11 pm
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
July 14, 2008 at 12:03 pm
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
July 14, 2008 at 11:12 am
Anirban Paul (7/3/2008)Is these one practically useful? I have a doubt. Any comments on these?
Anirban Paul (7/3/2008)
I actually did use this about a month ago... we had a new policy implemented...
July 3, 2008 at 6:08 am
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...
November 26, 2007 at 11:07 am
Thanks for the detail - that helps considerably.
October 26, 2007 at 11:56 am