Caching and paging a SQL Result Set
This is an example of how to Cache Query results on the Server side
then page though the results
2014-06-06 (first published: 2014-05-05)
2,268 reads
Scripts
Start a job at a defined step on another sql instance
this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.
2014-06-04 (first published: 2014-05-05)
780 reads
2014-05-30 (first published: 2014-05-05)
1,500 reads
2014-05-28 (first published: 2014-05-02)
2,127 reads
List all the fields of a table with its properties + PK
This script returns a list of all the fields of a table with it properties, primary keys and user defined types.
2014-05-23 (first published: 2014-04-30)
1,749 reads
Size of database files for an instance of SQL Server
Size of database files for an instance of SQL Server
2014-05-07 (first published: 2014-04-10)
1,325 reads
Find database where table is located
Return a list of databases which contain a table from wildcard table name.
2014-05-05 (first published: 2014-04-14)
1,202 reads
2014-05-02 (first published: 2014-04-09)
1,791 reads
2014-05-01 (first published: 2014-04-09)
1,520 reads
Format decimal value to fraction using a tally table.
We use a tally table to find the appropriate denominator for a given decimal part of a number.
2014-04-29 (first published: 2014-04-07)
1,208 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