SQL Tips
151
Identify Stored Procedures With Syscomments
152
Update large tables in small increments to save resources
153
Create local and global temporary tables
154
Prove that a job is executing on schedule
155
Master the control-of-flow t-sql keywords
156
Assign sql operators to e-mail notifications for job failures
157
Learn the best options for efficient deletion
158
Generate file names with tokens
159
View database metadata with system views
160
Merge tables with inner joins
161
Optimize queries with search arguments
162
Understand the global variable @@ identity
163
Items to consider in improving bulk insert loading performance
164
Know the limitations of the go statement
165
Maintain a table on all database objects
166
Get detailed table information with sp_columns_rowset
167
Maintain schema change table on databases
168
Use object search in query analyzer
169
Log user access to sensitive information with xp_logevent
170
Start a sql agent job using t-sql
171
Determine if a table has a primary key with sp_keys
172
Ensure modification by a specific application
173
Remove logged-in, orphaned windows users
174
Identify permissions within a database with sp_helprotect
175
Change collation of columns and databases
176
Use the table data type instead of temporary tables
177
Validate data with dbcc checkconstraints
178
Use columnproperty to determine column characteristics
179
Get index information fast with sp_helpindex
180
Use sp_helptrigger to learn more about triggers on your tables
181
Use fetch relative to fine-tune your scroll cursors
182
Use create schema to create mutually dependent foreign key constraints
183
Manage client connections with the client network utility
184
Understand statement permissions
185
Examine the power of fixed server roles for database administration
186
Create a differential backup
187
Restore from a differential backup
188
Discover other uses for the asterisk
189
Tips for keeping the count function accurate
190
Use sqlmaint.exe for routine maintenance
191
Using computed values in the select list
192
Explore uses for the char string function
193
What's in a name? Identifiers
194
Win9x's capabilities and limitations with sql server 2000
195
Beware of potential password hazards during backups
196
Use rowversion instead of timestamp in ddl statements
197
Execute dts packages with dtsrun for more control
198
Use sp_settriggerorder to set after triggers
199
Use kill to terminate problem connections
200
Use cast rather than convert to convert data types
201
Get information about a specific transaction or process using sp_who
202
Use sp_detach_db/sp_attach_db before moving database files
203
Speed up performance by using an indexed view
204
Restore a database with a new name
205
Follow these tips for implementing views
206
Pointers on using recursive triggers
207
Check database integrity with dbcc checkdb
208
Use bigint when integers exceed the range int supports
209
Use grant for streamlining user permissions
210
Resurrect forgotten stored procedures with sp_stored_procedures and Sp_helptext
211
See why blobs can be difficult to manage
212
Collect information from sqldiag before calling product support
213
Use alter view to make view changes
214
Selecting random rows from a table
215
Building temporary tables to optimize queries
216
Deliver text from sql by using select values
217
Restricting dba access to specific databases
218
Showing all dates in a report ordered by date
219
Finding all occurrences of an object name
220
Display the structure of a table
221
Declaring a computed column with a create table statement
222
Use fn_justdate() to fix between date1 and date2 problems
223
Utilize sql's built-in system stored procedures
224
Inserting specific values into an identity column
225
A case for taking your database design to 4nf
226
Determine whether a user belongs to a role
227
Insert default columns into your tables
228
Use an outer join to identify poor selling products
229
Shrink your database and increase performance
230
Increase performance with horizontal partitions
231
Protect databases from sql injection
232
Obtain your database's location
233
Naming complex SQL objects
234
Launch of SQL Server 2000 Reporting Services
235
How Yukon T-SQL enhancements boost productivity
236
Applying relational multiplication to hands-on problems
237
Creating joins across multiple databases
238
Give your budget a reprieve with these free tools
239
Working with relational division