| Licensing and Installation |
|
|
| |
| Operations and Maintenance |
| A SQL
Server 2000 Backup Plan |
| Step-by-step instructions for setting up a SQL Server backup maintenance plan. |
| SQL Server 2000 Operations Guide |
| Managing SQL Server within the structure of the Microsoft Operations Framework (MOF)
methodology. |
| Create a SQL Server Maintenance Plan, Josef Finsel |
| SQL Server's Database Maintenance Plan won't let you install a database. Create your
own plan that does. |
| Examining SQL Server's I/O Statistics, Andrew Novick |
| The diagnostic tools that can be used to examine SQL Server's I/O statistics so that
you can make fact-based judgments about disk configurations. |
| An
Introduction to SQL Server Profiler, Susan Sales Harkins |
| SQL Profiler is a tool that captures SQL Server events from the server and saves those
events in what's known as a trace file. You can then analyze or use the trace file to troubleshoot logic or
performance problems. |
| Scripting Traces for Performance Monitoring on SQL Server, Andrew Novick |
| The SQL Profiler is a great tool for monitoring and analyzing SQL Server performance,
watching the detailed actions of a stored procedures, triggers or user-defined functions (UDF). It can also
be used to monitor aggregate performance of an entire SQL Server instance, a single database, or to isolate
performance problems. When you are interested in overall performance, using SQL Profiler over time improves
your knowledge of your system and its performance characteristics and provides the information you need to
spot trends and changes of behavior. |
|
| |
| Stored Procedures and UDF's |
| Using Inline UDFs for Precise Paging, Andrew Novick |
| Using Inline User-Defined Functions (UDFs) as an alternate to SQL Views for managing
paging. |
| SQL Server Stored Procedures Optimization Tips, Alexander Chigrik |
| Twelve helpful tips for ensuring that you've constructed your SQL Server stored
procedures to perform in the most efficient manner possible. |
| The Curse
and Blessings of Dynamic SQL, Erland Sommarskog |
| Discusses the of use dynamic SQL in stored procedures in MS SQL Server, showing that
this is a powerful feature that you should use with care. Looks at the conflicts between the virtues of
stored procedures and the effects of dynamic SQL. Points out the common security issue known as SQL
injection. Reviews a number of cases where dynamic SQL often is suggested as a solution, both where dynamic
SQL is the way to go, and where it is a poor choice. |
| Dynamic
Search Conditions in T-SQL, Erland Sommarskog |
| A very common requirement in an information system is to have a function (or several
functions) where the users may search the data by selecting freely among many possible search criterias. This
is a tough challenge, because not only must you produce the desired output, but you must also keep the
response times with in acceptable limits, at least for common searches. And on top of all, the code must be
maintainable, so it can meet new needs and requirements. |
| Error
Handling in SQL Server, Erland Sommarskog |
| Focuses on how SQL Server – and to some extent ADO – behave when an error
occurs. Gives advice for how you should check for errors when you write stored procedures. |
|
| |
| Tutorials and Resources |
|
|
| |
|
|
|
