skip to main
|
skip to sidebar
Network technologies by Kaiming Liao
Saturday, October 6, 2007
ALTER Partition Function pf()
MERGE RANGE
()
Newer Post
Older Post
Home
Blog Archive
►
2010
(1)
►
February
(1)
►
2009
(2)
►
January
(2)
►
2008
(148)
►
December
(2)
►
November
(1)
►
October
(5)
►
September
(4)
►
August
(9)
►
July
(24)
►
June
(16)
►
May
(19)
►
April
(18)
►
March
(13)
►
February
(14)
►
January
(23)
▼
2007
(145)
►
December
(15)
►
November
(32)
▼
October
(36)
SQL:Deadlock Graph
Table Scan, Index Scan, Index Seek
Clustered Index and primary key
SQL--Lock vs. Latch
Addon Management for IE 7--how to find a clsid for...
Smart use of SNAPSOT
Copy a encrypted data from one row to another row
SPN and Kerberos and Linked server
Smart use of schemas
FULL RECOVERY vs. Bulk-logged Recovery
Very large database--use multiple filegroups --why
Restore a damaged page
Increase the speed of the full database backups
HAS_PERMS_BY_NAME
SQL Server Clustering vs. Database Mirroring
Partitioning a large table to improve query perfor...
Application Role:Domain Administrator and Database...
DBCC and RESTORE VERIFYONY WITH CHECKSUMIf you wan...
EXECUTE AS userIf you have a module, e.g. stored p...
Archiving -- Switch operator --sliding windows As ...
When do you use SNAPSHOT?Business requirements:The...
Efficient ways to move a database from ORACLE to S...
Database consolidationYou have three databases: Ac...
Large Value Types out of Row Optionvarchar(max), n...
Data archivingYour Customer table has a field Comp...
CREATE ASSEMBLYPERMISSION_SET: SAFE, External_acce...
Implicit vs. Explicit http namespace reservationIm...
SQL Server 2005 backup planThe business hour is 09...
Convert a nonpartitioned table to a partitioned ta...
Partition to Partition Switching The Partition 2 o...
SWITCH a non-partitioned table to the first empty ...
ALTER Partition Function pf() MERGE RANGE ()
SPLIT RANGEBased on boundary_value, the Microsoft ...
SWITCH operator -- Archiving data1. Create a Datab...
Outlook Web Access (OWA) of Exchange Server 2007SE...
Software Publishing of GPO--user inteventionWe und...
►
September
(7)
►
August
(6)
►
July
(47)
►
June
(2)
Network Instructor/ONA
MyWorks
View my complete profile
