Project Management: Dedicated vs. Shared Resources
As an infrastructure type person, I typically represent a "shared" resource. What that means is I'm not dedicated to just...
2011-05-13
18,928 reads
Blog Posts
Re-blog – May 6-12
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-13
545 reads
SQLRally is A Smashing Success!
Yesterday I presented Understanding Storage Systems and SQL Server and had a fantastic time! The crowd was great and was...
2011-05-13
548 reads
SSAS error when processing the cube
Every couple of weeks I see this SSAS error when processing one of my cubes:
Internal error: Invalid enumeration value. Please call...
2011-05-13
1,461 reads
A curious case of a missing configuration group.
G’day,
I recently received a brand new windows 7 virtual machine for my every day work use and one of the first things...
2011-05-12
1,496 reads
Clean Code is Easier to Read – SQL Prompt
I saw a post recently that had query that looked like this:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b
where permission_name...
2011-05-12
1,838 reads
Locking While Dropping or Altering an Index
Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...
2011-05-12
7,571 reads
Notes from SQLRally Orlando
Tuesday afternoon started with me being an unexpected behind schedule, and then another interruption or two, but by 4:30 pm...
2011-05-12
697 reads
Please vote for my SQLPASS precon and sessions
A few days ago, SQLPASS opened the voting for the precon’s and sessions for the annual
SQLPASS community summit. I’ve also...
2011-05-12
629 reads
SQL Rally Day 1 PreCon
Yesterday was the first day of the SQL Rally conference in Orlando, FL.It was a great first day because I...
2011-05-12
821 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