Viewing 15 posts - 10,561 through 10,575 (of 11,676 total)
If your table is partitioned (only in Enterprise Edition if I'm not mistaken), you can easily swich out an older partition. This goes really fast.
Otherwise, you can use the DELETE...
January 7, 2011 at 6:05 am
Do you really need two topics for the same question?
Orginal topic can be found here:
http://www.sqlservercentral.com/Forums/Topic1044315-146-1.aspx
January 7, 2011 at 6:00 am
Sheila.Roscoe (1/7/2011)
I don't think you read my post completely before you answered.
I've read it more times then you think.
But I'm still wondering why you are using mdf files and backup.
If...
January 7, 2011 at 5:55 am
veerendramsbi (1/7/2011)
i want to real time scenarios
Don't we all?
January 7, 2011 at 5:50 am
Brandie Tarvin (1/7/2011)
January 7, 2011 at 5:14 am
raj.lath-932078 (1/7/2011)
I am perfectly at ease with sqlstudiomanagementexpress or sqlserver.What i meant was my clients are not too familiar with these and i need a solution for them.
Ah allright, that...
January 7, 2011 at 5:10 am
Dave Ballantyne (1/7/2011)
Maybe my cynicism level is set to 11 , but are the school's back in 🙂
How far does your cynicism scale go?
January 7, 2011 at 5:05 am
lijnenjoost (1/7/2011)
Here are some more alternatives to improve the performance of a Slowly Changing Dimension:http://microsoft-ssis.blogspot.com/2011/01/slowly-changing-dimension-alternatives.html
You forget to mention the TSQL Merge statement (if SQL Server 2008) in your blog post.
p.s....
January 7, 2011 at 5:00 am
In your first post you said you couldn't use management studio or other tools.
Is this still the case?
January 7, 2011 at 3:08 am
raj.lath-932078 (1/7/2011)
January 7, 2011 at 3:02 am
qur7 (1/6/2011)
Yesterday my new boss gave me this assignment on SSIS , I am hoping some one of you might have gone through it or has an idea,...
January 7, 2011 at 2:24 am
When using .mdf files, isn't attach the preferred method instead of backup?
Backup is intended to restore .bkp or .trn files, if I'm not mistaken.
January 7, 2011 at 2:16 am
srik780 (1/6/2011)
what are the jobs created when we configure mirroring?any one plz
What makes you thinks there are jobs created?
Database mirroring uses endpoints to transfer messages with TCP.
See
http://msdn.microsoft.com/en-us/library/ms179511(v=SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms189852(v=SQL.90).aspx
January 7, 2011 at 2:09 am
TST1 (1/7/2011)
I'm trying to drop and create a table but I am getting error:
"INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are...
January 7, 2011 at 2:01 am
deepikamm (1/7/2011)
I hav lot of doubts..so shall i start a new thread for each doubt?
If these doubts are not related to each other. Yes.
If you only have one topic, with...
January 7, 2011 at 12:38 am
Viewing 15 posts - 10,561 through 10,575 (of 11,676 total)