Tips
Tips
-
Using AWE to increase performance
Using "Address Windowing Extensions" to increase memory usage will increase the performance of SQL Server. Continue Reading
-
SQL Server injection: When firewalls offer no protection
This chapter will detail the basics of SQL injection and best practices for defending SQL Server against such attacks. Continue Reading
-
Using split delimiter-separated lists in SQL Server
This SQL Server function is useful to split a string of values delimited by a special character. Continue Reading
-
Reseeding identities in SQL Server
Here are some tips to use and pitfalls to avoid when using IDENTITY columns as primary keys in SQL Server tables. Continue Reading
-
Split delimiter-separated lists with a T-SQL UDF
Creating and parsing lists of items in a string is a frequent request. Here's a SQL Server UDF that does it. Continue Reading
-
SQL Server script grants permissions to users
Here's a simple SQL Server script that can be customized to quickly grant permissions to various users on all tables or stored procedures. Continue Reading
-
ZIP files with a stored procedure
A SQL Server stored procedure that zips files from a source and destination directory that you pass when calling the procedure. Continue Reading
-
Upgrading SQL Server, part I: Overview and project planning
First of a series detailing the SQL Server upgrade process from the technical, logistical and business perspective. Continue Reading
-
SQL Server administration dos and don'ts
Ignore these SQL Server admin tips at your peril! Continue Reading
-
SQL Server string parser stored procedure
This stored procedure takes a delimited string, parses it and puts it into a table. Continue Reading
-
Decrypt encrypted stored procedures
Here is a stored procedure used to decrypt compiled T-SQL stored procedures. Continue Reading
-
Replacing non-alphanumeric characters in strings using T-SQL
Learn two important methods for replacing non-alphanumeric characters in strings using T-SQL with Microsoft SQL Server. Continue Reading
-
Quick way to find space used by each table in a database
Use this stored procedure to find the disk space used by each table in a SQL Server database. Continue Reading
-
ODBC IP connection troubleshooting
A tip on how to resolve MDAC and connection issues in SQL Server 7 & 2000. Continue Reading
-
Troubleshooting locking conflicts in SQL Server
Overview of potential locking problems, including what causes them, how DBAs can detect and resolve them. Continue Reading
-
Procedure to drop all user-created indexes of given table
A simple stored procedure that allows you to drop all user created index of a given table. Continue Reading
-
Calculating data warehousing ROI
While Return on Investment is a simple phrase, the implementation of ROI is complex. Continue Reading
-
The IDC data warehousing ROI study: An analysis
Guru Chuck Kelley takes a look at IDC's data warehousing ROI study a few years back and offers his opinions. Continue Reading
-
Information engineering techniques: Entity relationship diagrams
Salvaging some information engineering techniques can provide the models and requirements needed to create architected data warehouses in Microsoft SQL Server. Continue Reading