Script to grant exec permission to all sps in a db
Script to grant exec permission to all sps in a db
2010-12-13 (first published: 2010-12-09)
1,748 reads
Scripts
How to get all MSSQL database columns names, data types and length
know all database columns names and data types and lenght with the minimum effort
2010-12-09 (first published: 2010-12-06)
3,051 reads
2010-12-08 (first published: 2010-12-03)
2,002 reads
2010-12-07 (first published: 2010-11-30)
2,208 reads
2010-12-06 (first published: 2010-11-22)
2,634 reads
2010-12-03 (first published: 2010-11-22)
1,722 reads
Average Page Life Expectancy
A useful script that I wrote that will sample the DMV sys.dm_os_performance_counters table to provide an average PLE captured in (1) minute intervals.
2010-12-01 (first published: 2010-11-16)
1,713 reads
SQL Function to Split Comma Separated Values and Insert into Table
SQL Function to Split Comma Separated Values and Insert into Table
2010-11-30 (first published: 2010-11-07)
4,233 reads
2010-11-26 (first published: 2010-11-04)
594 reads
2010-11-24 (first published: 2010-11-02)
3,549 reads
Blogs
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers