You have this:

CREATE PROCEDURE procTestCounter
@CTR INT= 0
AS
DECLARE...

Random numbers

DECLARE @myString varchar(100)
SET @myString =' ONLYTWELVE ' +space(2)+Replicate(10,' ')
SELECT...

What does the following produce?

DECLARE @val CHAR(20)
SET @val...

List of Indexes and indexed columns in a Database

This scripts creates a view which will returns all the indexes and columns covered in the index for all the tables in a database.It returns only the user created indexes. Removes the statistics created on table (where indid > 0).

What does the following produce?

DECLARE @val CHAR(20)
SET @val...

Another data dictionary

Pulls relevant information including col. names, keys, and the description (if the description field is filled out).This makes a good source for a data dictionary report.

Script to Generate DataDictionary for Database

This Procedure is used to generate the datadistionary for a database.It gives following columns : table_id, table_name,column_order,column_name, column_description Usage: Create the Procedure in the database where the datadisctionary need to be generated.Call : Execute Generate_getDataDictionary Return the result in Tabular format.

What's wrong with this query?

select
category_nm
, q.category_id
, count(*)
...

Cross-Tab reports in SQL Server 2005

Microsoft introduces new operators PIVOT and UNPIVOT in SQL Server 2005. Traditionally we create queries using the CASE statement and aggregate function in order to produce cross-tab reports. This article illustrates the usage of the new operators, PIVOT and UNPIVOT.