Viewing 15 posts - 46 through 60 (of 66 total)
forsqlserver (6/8/2011)
But u can use the secondary database as reporting database.
The db would be in restore mode in this case, so not able to be accessed the same way. You'd...
June 8, 2011 at 12:24 pm
excellent, glad I could help
June 1, 2011 at 7:51 am
not a problem, we were all in your shoes once.
May 31, 2011 at 1:17 pm
start with something like this (might not work exactly as written)
create proc [dbo].[SP_employee](@daily as varchar(10) = '',
@type VARCHAR(10) = 'Daily'
) as
declare @em datetime
select @em =...
May 31, 2011 at 12:47 pm
add an input parameter to denote daily versus monthly and only call certain sections when needed
May 31, 2011 at 10:34 am
homebrew01 (4/28/2011)
Steve Jones - SSC Editor (4/28/2011)
April 28, 2011 at 12:14 pm
Currently we have 3 luns set up for this instance (all dedicated Raid 10) ... one for mdf, one for ldf and one for temp db. We have created a...
April 28, 2011 at 9:57 am
excellent recommendation. Thanks Jim!
April 28, 2011 at 8:39 am
Thanks John, that is where I was going with it as well. The goal is to improve performance of a heavily used application. I appreciate the quick response.
April 28, 2011 at 7:31 am
Replicated databases may be something better for you
April 12, 2011 at 9:01 am
you can add me to the list
December 23, 2010 at 7:11 am
please also consider 0E0 and numbers like them.
December 1, 2010 at 5:53 am
Fal (2/22/2010)
SET @PrincipalAmount = '100e2'
It will convert to float, but not money. With the QotD I...
February 22, 2010 at 7:04 am
i believe it has been corrected to include 1,1 as a correct answer
January 29, 2010 at 8:51 am
Viewing 15 posts - 46 through 60 (of 66 total)