Viewing 12 posts - 31 through 42 (of 42 total)
Yes,you can turn off if you want to ,but once restore starts successfully ,at that time if one of job tries to run in mid time (i.e. if you don't...
May 28, 2011 at 9:41 pm
Gianluca Sartori (5/26/2011)
Have you tried this:
DECLARE @sql nvarchar(max)
SET @sql = N'
SELECT COUNT(IndustyID)
FROM dbo.Industry
'
IF @criteria1 = 1
SET @sql = @sql + N'
WHERE...
May 26, 2011 at 9:01 am
Gianluca Sartori (5/26/2011)
Looks like a good place for dynamic sql and sp_executesql.Have you tried that?
yes,it takes more time.
May 26, 2011 at 7:20 am
sqlfriends (5/22/2011)
I can move around with them instead of carrying around my heavy...
May 22, 2011 at 11:28 pm
odanwada (5/19/2011)
I think my manager wants the...
May 20, 2011 at 5:06 am
odanwada (5/19/2011)
Information is from different tables....we have 3 tables like Emp, Dept and Projects
can you give us relation between all 3 table?
May 20, 2011 at 4:56 am
HowardW (5/19/2011)
Gaurang-Patel (5/19/2011)
i know that select into is much quicker than insert into.and i had doubt that
it is unlikely that i am going to get all records inserted...
May 19, 2011 at 7:09 am
Ninja's_RGR'us (5/19/2011)
Don't even know if this is possible but...select into + partitioning? Should be under 5 sec.
yes, i will try it after some time, i will like to see...
May 19, 2011 at 7:08 am
colin.Leversuch-Roberts (5/19/2011)
Do I think you can get under 5 secs...
May 19, 2011 at 7:04 am
colin.Leversuch-Roberts,
i know that select into is much quicker than insert into.and i had doubt that
it is unlikely that i am going to get all records inserted in 5...
May 19, 2011 at 6:33 am
Hi HowardW,
there was typo ,actually we have ldf on SAS, we don't have any ndf.i created ndf on SAS
drive and Test i got 11 seconds,that most of time i...
May 19, 2011 at 6:27 am
my database has simple Recovery model.
May 19, 2011 at 5:05 am
Viewing 12 posts - 31 through 42 (of 42 total)