Home
|
Tips & Tricks
|
Add Link
|
FREE MAGAZINES
|
Partners
|
Advertise
|
About Us
|
Privacy
36 Tips in Microsoft SQL Server …
Home
::
Tips & Tricks
:: Microsoft SQL Server
Most of these tips have probably come for the Listserv's at asplists.com. This is where the guru's hang out and a day won't go by that you don't learn something. I've collected tips that I felt I needed but you might find them useful too.
Diagramming your SQL databases
When to Break Up One Table to Multiple Tables
SQL Server Service Packs and Versions
Database Normalization Basics
Database Integrity and Maintenance Checks
∞
Randomize Records Easily
Database Connection Strings
Remove Duplicate Records
SQL Server Best Practices
Conditional WHERE Parameters
SQL Server 2000 Books Online
∞
Build a Search with Ranked Results
SQL Server 2000 System Table Map
∞
SQL Server 2000 Web Services Toolkit
Error Handling in T-SQL: From Casual to Religious
Quickly Duplicate Table Structure
Change display of system tables in SQL Server Enterprise Manager
Copy Databases from one SQL Server to Another
SQL Server Query Analyzer Shortcuts
Correcting problems with DTS in SQL Server 7.0
Configuring a default fill factor for all new indexes in SQL Server
Choosing between clustered and nonclustered indexes in SQL Server
Preventing the row count from displaying in SQL Server
Analyzing page fragmentation in SQL Server
Don't Make Assumptions about Dates in SQL Server
Using Dynamic Queries in Stored Procedures
∞
Using Dynamic SQL Statements in Stored Procedures.
∞
.NET Web Data Administrator
SQL Server Security Links
How to import DTS Package from disk
BuildSQL - ASP SQL Server Query Analyzer
ASP.Net Enterprise Manager
Transact-SQL Reference
∞
Create Crosstab Recordsets in SQL Server
∞
Crosstab Tables in SQL Server
∞
SQL Server Data Dictionary
