Viewing 15 posts - 8,941 through 8,955 (of 26,490 total)
dwain.c (1/15/2013)
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
Yes indeed.It appears the force is not with me this morning, oh master. 😛
Does this mean you have looked at the thread you...
January 15, 2013 at 10:16 pm
Not knowing the data that is being delete or the system itself, I couldn't tell you. I would recommend rebuilding the the clustered and non-clustered indexes on the tables...
January 15, 2013 at 10:15 pm
Ratheesh.K.Nair (1/15/2013)
Hi Experts,We have deleted 144101324 records from our WH database will it release the space to disk?
Thanks in Advance.
Do you mean to the database or the OS? If...
January 15, 2013 at 9:56 pm
chewychewy (1/15/2013)
What do u think of this article?
http://www.symantec.com/business/support/index?page=content&id=TECH58674
==
This issue occurs because the Log Sequence Number (LSN) for SQL is reset by the other backup application. So subsequent differential or...
January 15, 2013 at 9:54 pm
Note, it the above does not work, you may want to revisit your backup scheme and use either native backups to disk then backup those files to tape, or use...
January 15, 2013 at 9:16 pm
chewychewy (1/15/2013)
Have u used backup exec or arc serve before?
1. Daily full backup via backup exec to tape at 9pm.
This tape will be send offsite for safe keeping.
2. Daily...
January 15, 2013 at 9:14 pm
dwain.c (1/15/2013)
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
Yes indeed.It appears the force is not with me this morning, oh master. 😛
Does this mean you have looked at the thread you and I posted...
January 15, 2013 at 9:08 pm
Jim P. (1/15/2013)
January 15, 2013 at 9:07 pm
chewychewy (1/15/2013)
thanks for ur advise.
When doing the below, i supposed the transaction logs chained are not broken as there's no full backup by arc serve.
1. Daily full db backup to...
January 15, 2013 at 9:04 pm
dwain.c (1/15/2013)
Yes indeed.It appears the force is not with me this morning, oh master. 😛
Does this mean you have looked at the thread you and I posted on?
January 15, 2013 at 9:02 pm
chewychewy (1/15/2013)
Just curious will point in time recovery work in this case?
(1) Monday 2am - Transaction log backup via maintenance plan to disk
(2) Monday 7pm - full backup via...
January 15, 2013 at 9:00 pm
dwain.c (1/15/2013)
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
2. When you check for a date range, BETWEEN is not recommended. You should use >= @StartDate and <= @EndDate.
I'd like to expand on this...
January 15, 2013 at 8:57 pm
dwain.c (1/15/2013)
2. When you check for a date range, BETWEEN is not recommended. You should use >= @StartDate and <= @EndDate.
I'd like to expand on this one a bit....
January 15, 2013 at 8:38 pm
Please compare the following two pieces of code:
WITH SampleData (BipolarNumbers) AS (
SELECT '1'
UNION ALL SELECT '100231-A'
UNION ALL SELECT...
January 15, 2013 at 8:30 pm
10e5x (1/15/2013)
Lynn, i am still trying. Mind explaining the difference between dense_rank() and row_number() if both using partion by?
First thing you need to do is to read about the ROW_NUMBER(),...
January 15, 2013 at 8:15 pm
Viewing 15 posts - 8,941 through 8,955 (of 26,490 total)