Identity Column Increment Value (EVEN/ODD)
As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...
2015-11-24 (first published: 2015-11-18)
4,879 reads
Chris
- Website: https://www.cjsommer.com/
Identity Column Increment Value (EVEN/ODD)
As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...
2015-11-17
140 reads
Using Extended Events to Detect Connection Pooling
What is connection pooling? Lets start with a definition from MSDN.
Connecting to a data source can be time consuming. To...
2015-10-27 (first published: 2015-10-20)
5,217 reads
Using Extended Events to Detect Connection Pooling
What is connection pooling? Lets start with a definition from MSDN. Connecting to a data source can be time consuming....
2015-10-20
132 reads
Running Parameterized Queries against SQL Server using PowerShell
For many years I didn’t really think about the implications of how I was retrieving data from my SQL Servers...
2015-10-13
16,084 reads
Do you write ugly T-SQL?
Are your scripts littered with commented blocks of T-SQL code?
select fname,lname
from usertable
where id=1
--and lname like 'smith%'
/*
-- Who knows why...
2015-10-07 (first published: 2015-09-29)
6,372 reads
Pratical Use of a SQL Server Database Snapshot
I was doing a database code deployment the other night and the first step in the release plan was “Take...
2015-09-29 (first published: 2015-09-23)
7,277 reads
TSQL2SDAY #70: Strategies for managing an enterprise
Thanks to MidnightDBA (b/t) for hosting this month’s #tsql2sday.
Strategies for managing an enterprise.
What do you think of when you...
2015-09-17 (first published: 2015-09-08)
1,066 reads
How many errors can the PowerShell error buffer hold?
During my presentation at SQL Saturday Albany I was asked a question about the error buffer that I didn’t know...
2015-08-04
1,298 reads
Present at SQL Saturday #386 – Achievement Unlocked!
SQL Saturday #386 (Albany, NY) – My first SQL Saturday Session
So that picture to the right is me out front of...
2015-07-28
713 reads
Blogs
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
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...
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