Get all user def table info
Get space for all user defined table information like size and row counts.
2013-12-27 (first published: 2007-08-29)
7,690 reads
- Interests: Vedic Maths
Locate primary key - foreign key relations
Recently one of my friend was doing some investigation in a new/unknown database and had really hard time locating the primary key – foreign key relations. Like it’s really tough to locate these relations when not enforced at database level in terms of primary key and foreign key constraints. But generally all database developers keep […]
2011-09-14 (first published: 2007-08-15)
2,760 reads
Table row count using 3 different ways
Three different ways that you can get the count of the rows in a table.
2011-06-16 (first published: 2007-08-16)
6,552 reads
Data extrapolation on the fly
Sometimes we need to generate the data based on a given date, to an end date (data extrapolation).
This is a easy way to do that without any temporary storage.
2008-11-14 (first published: 2008-09-25)
895 reads
Combine multiple rows into single output
We can use this function to combine multiple rows into single one. Generally to create comma separated list for each unique item. So this can create comma separated product list for any given category. The same can be used to make a list of items in a given order.ThanksMohit Nayyarhttp://mohitnayyar.blogspot.com/
2007-09-14
3,810 reads
To Get Latest SQL Job Status
This query will give you the current job status of all scheduled jobs on sql server. Just by using sysJobs, and sysJobHistory table you will get to know the details about the last status of the scheduled jobs, irrespective of their status like failed, successful, or cancelled.Note: You must have admin right on MSDB database […]
2003-09-04
8,553 reads
DB Details - Tables, Rows, Columns, Primary Keys
This procedure will give you the list of tables in the current database along with total columns in the table, no. of rows and the primary key(s) defined for the table.Mohit NayyarMCP, MCAD (.Net), MCSD, MCDBA
2003-04-30
761 reads
Error Handling in SQL Server (like Visual Basic)
Using this technique you can do error handling in SQL Server using the same way you do in Visual Basic (most of it). Just put your SQL Statement in exec('SQL Command') and make use of @@Error to get error information and put your error handling code in If block.Mohit NayyarMCP (.Net), MCSD, MCDBA
2003-04-17
959 reads
To get Table and column name for Primary Keys.
This query will give you the table name and column name on which you have defined the primary key. You can use this to get columns on which the primary key is based. I find it very useful when i need to define the FK relationship for other tables in PowerDesigner. Try to do the […]
2003-04-16
1,670 reads
Get Triggers for the Table
Use this script to get Insert, Update and Delete trigger for all the tables. This script will give you just the first level of triggers. So if you have more than 1 insert trigger, it will give you the first one.Mohit NayyarMCP (.Net), MCSD, MCDBA
2003-04-14
275 reads
Blogs
Back in the EU
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Setting up SQL Server S3 Object Storage Integration using MinIO with Docker Compose (Updated for SQL Server 2025)
Update for SQL Server 2025: This post and the GitHub repo have been updated for...
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers