Miscellaneous

Technical Article

GetPage - paging functionality

  • Script

All what you need to do is to set the values of a couple of variables; NAME OF the TABLE you want to query (or you can write your own select statement here), NAMES OF COLUMNS you want to display, name of COLUMN for SORTING, define NUMBER OF ROWS on one page, NUMBER OF REQUIRED […]

5 (1)

You rated this post out of 5. Change rating

2002-05-01

392 reads

Technical Article

Generate CROSS-TAB Scripts Automaticly !

  • Script

Need to Transform a table with Summaries to be plugged into EXCEL or place a table of info in one row. This is cool and has been a real time saver!!! Simply save as a Template file in your favorite template folder. In Query Analyzer go to Menu Tools... Options... General... Note the path of […]

You rated this post out of 5. Change rating

2002-04-26

1,812 reads

Technical Article

Calculate row length of table(s)

  • Script

This procedure will be useful for developers/ database designers / DBAs to find the rowlength instantly.To find the row length of a user table, just copy this script into Query analyser and pass the table name for which you want to find the rowlength. @TabName is the table name parameter, if we donot provide this […]

4.75 (4)

You rated this post out of 5. Change rating

2002-04-25

2,900 reads

Blogs

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By

 Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

SQL Newbie HELP: The query references an object that is not supported in distr..

By WBenning

Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...

Are topic notifications working?

By Edward Casbon

This is a topic to test whether reply notifications are working or not.

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers