2007-12-21 (first published: 2007-10-25)
1,439 reads
Scripts
Update Statistics - All Tables (No System)
This proc executing the update statistics command in all user tables (no system).
2007-12-20 (first published: 2007-10-24)
2,389 reads
2007-12-18 (first published: 2007-10-18)
2,688 reads
usp_IndexCreationStatements
(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.
2007-12-13 (first published: 2007-10-11)
1,021 reads
2007-12-12 (first published: 2007-10-12)
3,566 reads
Max Actual datalength
This script returns the defined rowlength and the actual datalength for the longest row in a table.
2007-12-10 (first published: 2007-10-01)
944 reads
2007-12-05 (first published: 2007-10-17)
692 reads
2005 Database Monitor RDL for Management Studio
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2007-12-04 (first published: 2007-09-25)
2,702 reads
Quick table finder
This little script will search for all matching tables on the SQL Server instance
2007-11-30 (first published: 2007-10-15)
759 reads
Clear all the data from tables
This script will delete all rows from the database, except system tables.
2007-11-26 (first published: 2007-09-30)
1,708 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers