Actual Emails: More Grief for GUIDs
Wrote this email exchange with some developer colleagues about to embark on performance tuning.
Subject: bag o' tricks from DMV talk
From: A. Developer
Hey...
2014-02-12 (first published: 2014-02-05)
2,090 reads
Blog Posts
Big Data Success May Rely on Hiring the Right Skill Sets #bigdata #hr
Five Tips to Improve Your Data Analysis
It’s no secret that Big Data’s real challenge may not be the technology, but...
2014-02-12
400 reads
Does Your Company Make You a Better Person?
Successful organizations place personal development front and center.
from HBR.org http://ift.tt/1aq03xy
via IFTTT
2014-02-12
389 reads
Don’t Forget About the Second Shot
Photo credit – Dennis Wong
A couple weeks back, in a post on certifications, I mentioned the Second Shot offer from Microsoft...
2014-02-12
561 reads
If You’re Not Helping People Develop, You’re Not Management Material #management
Facilitating employee learning should be a non-negotiable competency. Employee development is one of the most critically important jobs any manager...
2014-02-12
283 reads
If You’ve Just Taken Over a Team, Quickly Let Underperformers Go
Your job is not to maintain the status quo. When you take over a team, you need to evalute why...
2014-02-12
293 reads
Locks, Blocks, and Deadlocks Oh My!
Abstract Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this...
2014-02-12
13 reads
Locks, Blocks, and Deadlocks Oh My!
Abstract
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out...
2014-02-12
839 reads
MCSA in 90 days… & lot of resources
Another free resource for learning and gaining your knowledge that might be possible to earn MCSA Certifications with few efforts....
2014-02-12
1,475 reads
MDX+SSAS #38–CALL ASSP.DMV() to document cubes in SSAS 2005
While you are writing and testing MDX queries in Microsoft SQL Server management Studio (SSMS), how many times you find...
2014-02-12
1,425 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