Find Largest size Tables in a Database
To find a list of Tables (User or System tables)according to their size.
2013-01-02 (first published: 2008-07-10)
4,300 reads
Hari Sharma
- Interests: Solving Analytical Puzzles, Making Friends, Movies
Function to Split Multivalued Parameter
This Function is written to split Multivalued Parameter passed by Reporting Services 2005.
2012-07-16 (first published: 2007-08-01)
2,798 reads
2009-10-05
4,052 reads
2008-08-15
6,047 reads
Find Nth Maximum from a Table...
This is very simple query to find Nth Maximum number from a Table. For example, using this query, we can identify the 5th, 8th or Nth highest paid employee of an organization.
2007-09-06 (first published: 2007-04-29)
970 reads
Get Record Count for each table in a database.
I wrote this script to compare record counts between a live database and a restored copy to test backups, I thought people might find it useful. What You need is to just copy the script and run it against your database.
2007-08-21
1,420 reads
Function returns String in Proper Case [CamelCase]
This is a generalised Function that will return a String in Proper Case [Camel Case]. Means Afetr every space, first later will be in UPPER Case.Example:Input String: 'microSoft sql server'Output String: 'Microsoft Sql Server'
2007-05-09 (first published: 2007-04-19)
22,075 reads
Function to calculate Month End Date
This function will return you the month-end date. Input parameter may be any date of that month for which you want to calculate month-end.Example:Input: '2-20-2004' Output: '2-29-2004'Input: '2-15-2004' Output: '2-29-2004'Input: '3-20-2004' Output: '3-31-2004'Input: '3-30-2004' Output: '3-31-2004'
2007-05-08 (first published: 2007-04-19)
1,329 reads
Blogs
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Forums
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Foreign Keys - Foes or Friend?
Comments posted to this topic are about the item Foreign Keys - Foes or...
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers