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