Additional Articles

Add Wildcards to Advanced Search Stored Procedure

by Additional Articles

SQLServerCentral

I have found that I can add wildcard support to the Advanced Search Stored Procedure submitted by jgroseth (Posted: 07/02/2004) here:http://www.sqlservercentral.com/scripts/contributions/1201.aspby simply modifying "charindex( c.string," to "patindex('%' + c.string + '%'"I did this to take varying whitespace into account since SQL server does not care about whitespace, for example "INSERT INTO DATABASE_MYTABLE" could have any […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-01-25 (first published: 2005-01-10)

512 reads

Discuss

Detecting and Reporting Errors in Stored Procedures - Part 1

by Additional Articles

sqljunkies.com

Miscellaneous

Detailed error reporting from stored procedures can be extremely valuable when debugging problems in your application. I will share different levels of detail that you can build into your stored procedures. You can choose the level of detail appropriate for your situation.

2005-01-25

2,903 reads

Discuss

Generate Random Alphanumeric String

by Additional Articles

SQLServerCentral

Here's a short script to generate a random alphanumeric string based on newid(). The procedure takes in length (@len) which determines the key length. Length must be between 8 and 32. Result is returned in an output parameter. A test script is supplied.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2005-01-24 (first published: 2005-01-10)

1,279 reads

Discuss

Exploring Table and Index Partitioning in SQL Server 2005

by Additional Articles

sqljunkies.com

Administration

Table partitioning is a powerful new feature in SQL Server 2005. It is primarily a manageability feature, but my interest here is in the performance and scalability of table and index partitioning for use with very large tables.

2005-01-24

1,462 reads

Discuss

create t-sql scripts for every jobs in Instance.

by Additional Articles

SQLServerCentral

Desc : This SQL statement will provide script for backup all your jobs.Remark : Grow-up 'maximum characters per column' (for 8192) and disable 'print column headers' in 'tools' / 'options'

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-01-21 (first published: 2005-01-11)

1,056 reads

Discuss

DATA PIRACY: THE THREAT FROM WITHIN

by Additional Articles

TDAN

Security

Databases are being stolen. Customer data, credit card data, taxpayer data - they're all vulnerable. Scary? Yes - but wait, there's more. It's not just "their" data that's vulnerable - it's ours too!

2005-01-21

2,107 reads

Discuss

Setting Matters Straight

by Additional Articles

Other

Basics

Fabian Pascal, famed database author and writer takes his shots at a recent thread on another SQL site. He makes some good points about normalization.

2005-01-20

3,074 reads

Discuss

SQL Server 2005 Recursive Functions

by Additional Articles

Other

Development

SQL Server 2005 has added a new format for queries called a Common Table Expression or CTE. CTE’s are part of the SQL:1999 Specification and represent further compliance with this specification by SQL Server. This article will cover using one of the many capabilities of CTE’s, implementing recursive functions. A recursive function is a one that iteratively executes itself. Understanding how CTE’s implement recursive functions is the first step to understanding the full capabilities of CTE’s.

2005-01-19

1,858 reads

Discuss

SQL Server Database Index Performance

by Additional Articles

Other

Indexing

When it comes to auditing index use in SQL Server databases, I sometimes get overwhelmed. For example, how to do you go about auditing indexes in a database with over 1,500 tables? While auditing a single index is relatively straight-forward, auditing thousands of them in multiple databases is not an easy task. Whether the task is easy or not, it is an important task if you want to optimize the performance of your SQL Server databases.

2005-01-18

3,860 reads