Script Table or View structure
This code will let you script a Table or Views structure for source control.
2010-02-02 (first published: 2010-01-12)
2,191 reads
Scripts
Listing Subscribed SSRS Reports including Parameters & their Values
This script will allow user to analysis their Subscribed Reports.
2010-02-01 (first published: 2010-01-11)
2,242 reads
Object Search for Sql Server 2005
This script will search databases, tables, columns, stored procedures for text.
2010-01-28 (first published: 2008-12-21)
1,282 reads
Display Rows Vertically or Alphabetically
Display a row vertically when a table has hundreds of columns to avoid scrolling.
2010-01-21 (first published: 2009-12-30)
3,262 reads
datetime precision
Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.
2010-01-20 (first published: 2009-12-21)
1,484 reads
Implementing Most Recently Used Lookups
This script will adapt ordering of look-up lists by foreign key usage.
2010-01-18 (first published: 2009-12-23)
971 reads
Validate Deployed Databases by Version
Save all object definitions to a single stored procedure for easy validation
2010-01-14 (first published: 2009-12-18)
774 reads
return a file Last Modified Date
This function takes a UNC file as a parameter and return the last modified date
2010-01-13 (first published: 2009-12-17)
2,528 reads
Store Procedure Output in a Table
This script show a demonstration of how to interst tore Procedure Output in a Table.
2010-01-08 (first published: 2009-12-18)
2,484 reads
2010-01-07 (first published: 2009-12-18)
1,718 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers