SQL Server Tips

by Arthur Fuller

Installation and maintenance	Insert specific values in an identity column	Many uses of CASE
Minimize tempdb size	Override default values in INSERTs	Modeling columns as rows
What can go wrong, will	Retrofitting date values in SQL Server 2005	Nested subqueries
Connect	Storing URLs	Reporting Services in SQL Server 2005
Connect to server databases with SQL-DMO	Update and insert in one query	Running totals
Database design	XML and SQL Server	Select random rows
Add columns to all tables in a database	Maintenance	Simple histograms in SQL Server
Build a data values dictionary with SQL Server	Change authentication mode	Statistical functions
Fix what Access export wizards miss	Recover from hardware upgrade problems	Unusual ordering
Improve performance with horizontal table partitions	Optimization	Security
MSDE or SQL Server?	Optimize queries with temporary tables	Block unauthorized access into an encrypted database
OLAP dimensions	Set file locations to optimize performance	Checklist for hardening your database server
Partition tables with hardware	Use hash keys instead of string indexes	Prevent SQL injection attacks
Point-in-time architecture	Queries	Using logins, users and roles more efficiently
Speed up development by re-using databases	Comma-delimited lists	Stored routines
Ten questions to ask before optimizing a database	Common table expressions (CTEs)	Build stored procedures with templates
The sysobjects table	Compound JOINs	Debugging stored procedures in Query Analyzer
Data	Creativity with COALESCE()	Recursion
A hold-release window for online customers	Crosstab queries for SQL Server 2000 with Access	Scope @@identity in stored procedures
Benchmarking tables with millions of rows	Displaying currency	User-defined functions
Comma-delimited lists	Improve query performance with multi-column indexes	WITH RECOMPILE
FIFO and LIFO stacks	Loose associations

Do you have an item or correction to contribute?

Back to the home of Get It Done With MySQL 5