Adding Data Files To A Mirrored Database
This is my first post! I don't really expect anyone to find this blog.
So I have a pretty big...
2011-04-20
3,806 reads
Blog Posts
Building an algorithm
When I was in college, and even high school, all of my computer science classes required me to build algorithms....
2011-04-20
1,544 reads
CodeName for the next generation of SQL Server??
Ever since the first version of SQL Server (1988??), Microsoft has found some interesting codenames for their releases
1993 – SQL Server 4.211995...
2011-04-20
795 reads
Daily Denali Delight – Day 1
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released (is this still unconfirmed?) you...
2011-04-20
919 reads
Evaluating my SQL Connection Scores
This evening I received my SQL Connection scores for the following presentations:
Windows Internals for DB ProsFrom the Ramparts: Knowing What...
2011-04-20
1,490 reads
Fail-Win Balance
It’s a busy week for me, and a slow one technically. But I know that you, Constant Reader, thirst for...
2011-04-20
529 reads
Powershell Day 20
Day 20 Introduction to SMO >>SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server...
2011-04-20
429 reads
SQL Saturday 67 Slides Are Now Available
I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to...
2011-04-20
731 reads
A SQL Server Hardware Nugget A Day – Day 19
For Day 19 of this series, I am going to briefly discuss hardware RAID controllers, also known as disk array...
2011-04-19
549 reads
Cain does LSA Secrets dump on Vista and higher now
Since going back to being a senior DBA, I've not stayed on top of the latest tools like I did...
2011-04-19
2,084 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