Troy Ketsdever


Technical Article

Find maximum values for all "int" columns

/******************************************************** "CheckAllInts" Find all columns in all user tables in a database defined as "int", and get the maximum value for the column. Uses a cursor and logs the results to a table. (One-time CREATE TABLE statement at top of script). Successive runs over an appropriate period of time would allow one to find how […]

You rated this post out of 5. Change rating

2005-04-11 (first published: )

331 reads

SQLServerCentral Article

An Identity Crisis

SQL Server includes autonumber of identity columns despite the fact that they are not SQL-92 compliant. There is quite a bit of debate over the use of them in your database, but if you do decide to use them, you should be aware of potential problems. New author Troy Ketsdever brings us a story about his identity crisis and how it was solved.

5 (4)

You rated this post out of 5. Change rating

2005-03-23

10,239 reads

Blogs

A New Word: Foilsick

By

foilsick – adj. feeling ashamed after revealing a little too much of yourself to...

Accelerated Database Recovery for tempdb in SQL Server 2025

By

Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...

Measuring What Matters: Operationalizing Data Trust for CDOs

By

Trust is the currency of the data economy. Without it, even the most advanced...

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...

ETL Framework In Production

By Rahulmsb5

Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...

SQL Server Ghosts

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Ghosts

Visit the forum

Question of the Day

SQL Server Ghosts

For Halloween, what are ghost records?

See possible answers