skip to main
|
skip to sidebar
Network technologies by Kaiming Liao
Tuesday, October 16, 2007
Increase the speed of the full database backups
perform the backup to multiple backup devices.
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
