Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Truncate or switch range of a partitioned table Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 3:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 9:14 AM
Points: 33, Visits: 289
Comments posted to this topic are about the item Truncate or switch range of a partitioned table
Post #1398701
Posted Wednesday, January 9, 2013 11:46 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 28, 2013 12:31 AM
Points: 867, Visits: 333
Hi Friend,

I need to know about the below table,

view_all_partitions_trg_prod
.

Can u Pls explain.

Thanks

Arul R
Post #1405207
Posted Thursday, January 10, 2013 1:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 9:14 AM
Points: 33, Visits: 289
Arul R (1/9/2013)
Hi Friend,

I need to know about the below table,

view_all_partitions_trg_prod
.

Can u Pls explain.

Thanks

Arul R


In the article is written :
This script requires the creation of the big view in
http://www.sqlservercentral.com/scripts/Partitioning/73324/
The view is view_all_partitions_trg_prod , please read it
Post #1405264
Posted Thursday, January 10, 2013 2:39 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 28, 2013 12:31 AM
Points: 867, Visits: 333
The View is for which table, where is the query for that view

in the stored procedure.
Post #1405287
Posted Thursday, January 10, 2013 2:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 9:14 AM
Points: 33, Visits: 289
Arul R (1/10/2013)
The View is for which table, where is the query for that view
in the stored procedure.


The DDL for the view is at : http://www.sqlservercentral.com/scripts/Partitioning/73324/
The view display information for all tables in the current database
Post #1405296
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse