Parsing INTERNAL REPRESENTATION OF OVERPUNCH SIGNS
Some times you need to parse over punch values at the while running a query.
Here is an utility function to help with that task.
2018-11-07 (first published: 2018-10-31)
912 reads
Scripts
The Pesky Windows Power Plan Oh My
The below script will build a csv file for import of the servers Power Plan Setting.
2018-11-06 (first published: 2018-10-19)
594 reads
2018-11-05 (first published: 2018-10-22)
899 reads
sp_what
Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.
*Dont you just love totally non subjective assessments like this?
2018-11-01 (first published: 2018-10-22)
3,047 reads
2018-10-29 (first published: 2018-10-19)
1,477 reads
Mechanism To Dynamically Build Pivot Table
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
1,018 reads
2018-10-24 (first published: 2018-10-15)
945 reads
Detect and Repair Non Trusted Foreign Keys
Create the code to detect and repair non trusted foreign keys
2018-10-23 (first published: 2018-09-27)
735 reads
2018-10-12 (first published: 2018-10-04)
1,185 reads
How to Identify backup tables within production databases
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
596 reads
Blogs
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Forums
Adding new column with DEFAULT II
Comments posted to this topic are about the item Adding new column with DEFAULT...
Advanced Deployment Scenarios: Stairway to Reliable Database Deployments Level 7
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
You Need a DBA Pipeline
Comments posted to this topic are about the item You Need a DBA Pipeline
Question of the Day
Adding new column with DEFAULT II
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers