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,047 reads
Scripts
2010-12-08 (first published: 2010-12-03)
1,993 reads
2010-12-07 (first published: 2010-11-30)
2,202 reads
2010-12-06 (first published: 2010-11-22)
2,622 reads
2010-12-03 (first published: 2010-11-22)
1,715 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,705 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,230 reads
2010-11-26 (first published: 2010-11-04)
589 reads
2010-11-24 (first published: 2010-11-02)
3,535 reads
2010-11-18 (first published: 2009-07-20)
2,969 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I