Execute All .SQL Script easily
If you have a requirement to create Proc/Tables, etc to a SQL Server taking .SQL scripts from a central location (UNC), then you can use my script.
2016-05-24 (first published: 2015-05-18)
2,533 reads
Scripts
Generate script to rebuild indexes in a database
Generate script for reconstgruir ena database indexes
2016-05-23 (first published: 2014-03-20)
2,641 reads
Split string using multiple delimiters
This script is used to split the string using multiple delimiters
2016-05-18 (first published: 2014-10-09)
6,072 reads
2016-05-17 (first published: 2014-08-25)
2,570 reads
2016-05-16 (first published: 2012-10-17)
5,577 reads
Compare two tables for structure and layout
Compare the structure/layout of two tables within an instance of SQL Server (version 2012) and return non-matches.
2016-05-13 (first published: 2014-04-23)
2,948 reads
Aggregrating varchar columns
Concatenate columns grouping on Index column (approach for summing varchar columns by grouping on index)
2016-05-12 (first published: 2009-09-13)
1,578 reads
sp_spaceused rewritten as one query (no cursors)
Query that simulates running sp_spaceused on every applicable object in a database and gathering it all into a single result set.
2016-05-10 (first published: 2013-06-03)
2,291 reads
Agent Job Schedule Description
Yet another schedule description query with added grammatical improvements.
2016-05-06 (first published: 2016-04-20)
869 reads
Get Space on SQL hardrive
I was recently asked to monitor the Database size on the SQL server, and display the results in a report.
2016-05-05 (first published: 2016-04-16)
816 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers