SQL Server & Access Tips

by Arthur Fuller


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

Do you have an item or correction to contribute?   Back to the home of Get It Done With MySQL 5&6