SQL Tips
1
Retrieving data from two separate databases
2
Truncate table vs. delete v7.0
3
System stored procedures
4
Using SET ROWCOUNT, TOP, and PERCENT to limit a result set
5
Variable declaration
6
Auditing transactions
7
Using the model database
8
Protect your sensitive information
9
Inserted and deleted virtual tables
10
Database files v7.0
11
Truncate table vs. delete v7.0
12
Autostartup procedure(s) v7.0
13
BULK INSERT batches vs. BCP batches v7.0
14
Bypassing a backup device v7.0 & v6.5
15
Empty table structure v7.0
16
Detecting a transaction v7.0
17
Qualify your scripts when using and INSERT SELECT v7.0
18
Pausing and continuing SQL Server v7.0
19
Using FILLFACTOR v7.0
20
CHECKING YOUR CONSTRAINTS BEFORE OR AFTER BCP IMPORT v7.0
21
Stored procedures vs. embedded queries
22
SEARCH ARGUMENTS v7.0
23
OSQL.EXE VS. ISQL.EXE v7.0
24
MONITOR DISK USAGE v7.0
25
Detaching/attaching a database v7.0
26
UPDATE STATISTICS v7.0
27
VERSION INFO v7.0
28
INSERTING YOUR OWN IDENTITIES v7.0
29
NULL COMPARISONS V6.5 VS. 7.0
30
USING VIEWS FOR SECURITY V7.0
31
USING ALTER TO PRESERVE OBJECT DEPENDENCIES V7.0
32
THE ACID TEST v7.0
33
STRINGS, NULLS, AND CONCATENATION IN V6.5 AND v7.0
34
WRITING SQL ERRORS TO THE EVENT LOG v7.0
35
ADDING A USER-DEFINED MESSAGE V7.0
36
WHAT IS A BATCH
37
ANOTHER METHOD TO COUNT(*) v7.0
38
DIFFERING DATABASE MODELS
39
DOS AND DON'TS WITH SQL SERVER v7.0
40
NILADIC FUNCTIONS v7.0
41
SP_TABLEOPTION AND DBCC PINTABLE v7.0
42
SET STATISTICS TIME ON|OFF v7.0
43
SP_WHO OR SP_WHO2 v7.0
44
INNER JOINS: OLD, NEW, AND ALIASING v7.0
45
CASCADE OPTIONS v2k
46
DATA CHECKS V7.0
47
USING DBCC DBREINDEX v7.0
48
IDENTIFIERS v7.0
49
Nested Loops Joins v7.0
50
New Data Type V2K
51
Merge Join Stratagies
52
Hash Join Stratagies
53
SET STATISTICS IO v7.0
54
ANSI 92 COMPLIANCY CHECKLIST v7.0
55
USER-DEFINED COUNTERS V2K
56
Transact SQL Debugger V2K
57
Recovery Models V2K
58
Three Common Locking Modes V2K
59
ISQLW.EXE Command Line Options V2K
60
Consistent Performance Statistics V2K
61
SP_MSFOREACHTABLE Sytem Stred Procedure V2K
62
Cursors not always best choice for data acess V2K
63
DDL AND DML Terminology
64
Security And SQL Server
65
Deadlock Volunteer
66
Java For SQL server - Overdue Or a waste of time?
67
DEFAULT KEYWORD AND NULL V2K
68
The advanced TAB in Query Analyser2K
69
INFORMATION_SCHEMA views V2K
70
Determinsm in SQL Server 2000
71
OR or IN v2K
72
Replication v7.0
73
USING XP_FILEEXIST TO IDENTIFY WHETHER A FILE EXISTS V2K
74
ALIASING REMOTE SERVERS
75
CREATE TEMPORARY STORED PROCEDURES, V2K
76
SQL QUERY ANALYZER TOOLS V2K
77
KEEP ADMINS OUT OF THE SERVER
78
Who adds your SQL Agent Jobs?
79
Create an ordered column list for a qualified insert statement
80
Use the EXISTS clause with SELECT *
81
Determine available Drive Space
82
INSERT Statement syntax tightened
83
Can't connect to SQL enterprise manager?
84
Exploring Decimal & numeric Data types.
85
Are your Sql servers secure?
86
Increase the No. of Error Logs that SQL Serevr Maintains
87
Increase productivity using SQL Templates
88
Identify disabled triggers within a Database
89
Display datetim without Hour, minutes and seconds
90
Importance of FK Constraint columns order
91
Mitigate XP_SENDMAIL Security breaches
92
Test for check constraint ANOMALY
93
ANSI settings & indexed views go hand in hand
94
Naming constraints Vs System-generated constraints
95
Create Daily report using SQL Mail
96
Analyze database dependencies
97
Vary behaviors by setting user options
98
Drop "X_TMP" prefaced Database objects.
99
Replicate strings in T-SQL
100
Impersonate Database users
101
Dump Devices Offer Visibility To Database Backups
102
When can be run restore LABELONLY?
103
Capture important database information
104
Obtain Information from backup files
105
Use SP_CHANGE_USERS_LOGIN When Restoring Databases
106
DROP Non-dbo tables with ease
107
Always Check String Length Differences
108
Reference Unique Indexes Of Parent Tables With A Foreign Key
109
Detect The Presence Of Multiple Procedure Plans
110
Locate the XACT_ABORT Setting
111
Issue A DBCC CHECKIDENT Command
112
Reevaluate the Primary Key
113
Query The SYSFILES Table In The Master Database
114
Identify user session connections
115
Identify Foreign Keys that allow NULL values
116
Check For Valid Data In Nullable Foreign Keys
117
How can you move tempdb?
118
Reading Job History Values
119
Follow these rules when using partitioned views
120
Send messages to a list of E-mail recipients
121
Learn how to use PERMISSIONS()
122
Sync sysdepends for data integrity
123
Link SQL Servers in the same SESSION
124
Issue a net send via XP_CMDSHELL for user notification
125
Determine the proper tool for Import/Export
126
Use the extended procedure XP_MSVER
127
Find similar strings using the SOUNDEX and DIFFERENCE functions
128
Identify base data type with SQL_VARIANT_PROPERTY
129
Optimize queries by indexing Foreign keys
130
Handle NULL values with COUNT(*)
131
Learn an appropriate use of NULL table values
132
Automatically DELETE child rows when a parent is deleted
133
Avoid IDENTITY Primary keys as clustered Indexes
134
Designate the DB_OWNER
135
Verify the date for a specific day of a particular week
136
Achieve better performance in LOOKUP tables
137
Report what database properties have been set
138
Perform maintenance with DBCC indexdefrag
139
Circumvent backup size bug in sem
140
Optimize with system-generated statistics
141
Determine what edition is running
142
Specify locking with sp_indexoption
143
Develop database creation scripts with these tips
144
Round numbers using the CEILING or FLOOR function
145
Retrieve information regarding linked servers
146
Decipher T-Sql syntax with the help of shortcut keys
147
Examine the pitfalls of a NONREPEATABLE read
148
Know the difference between DELETE and TRUNCATE
149
Return the value of nested trigger levels
150
Prefix stored procedures with SP_
Find dump device and backup information in the MSDB database
List available SQL servers using OSQL utility
Page 2