Running Totals for Each Group
A while ago, I posted a blog on how one could perform running totals using Reporting Services and a user...
2010-10-11
4,401 reads
BrianKMcDonald
Time Saver – Presentation Preparation
Presenting is a huge fear for many and it is no different for me. I have been presenting at SQL...
2010-10-10
591 reads
Determine if Directory Exists using xp_cmdshell
Recently, I came across a forum post from a user trying to determine if a directory existed in the file...
2010-10-06
14,395 reads
SQL Saturday 49 Orlando - Delivery Mechanisms using SQL Server Reporting Services (mini)
It's official! I am presenting a mini session for SQL Saturday in Orlando. My topic and some details are below:
Delivery...
2010-10-05
464 reads
MSDB Job History Duration Conversion
Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do this...
2010-10-05
2,783 reads
Converting Dates to Integers
While working on a project recently, I came across a conversion that was trying to convert a date to an...
2010-10-05
820 reads
Strange but True - Report Parameter Label Blank
Here is another one of those strange but true things that I come across every so often which I thought...
2010-10-01
1,519 reads
Retrieving Report Names for SSRS Subscription Jobs
The way Reporting Services creates subscriptions is through generating a SQL Server Agent job. This is apparent when you look...
2010-09-01
800 reads
Using WITH NOLOCK
A colleague of mine and I were recently talking about some scripts that they had seen containing the WITH NOLOCK...
2010-09-01
548 reads
Dynamic SQL and Cached Query Plans
Over the many years that I’ve been dealing with SQL Server, I’ve always been told and read about how using...
2010-08-29
615 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