Indexes and their Effect on Query Performance
Indexes play a huge role in the performance of a query. Without indexes, you very simple query to get the...
2010-07-29
1,005 reads
BrianKMcDonald
Checking Users AD Groups Using Windows CMD
Blog Title: Checking Users AD Groups Using Windows CMD
Depending on your role in the organization, there may be a time...
2010-07-29
4,040 reads
Limiting Table Access for Reporting Part 2
Blog Title: Limiting Table Access for Reporting Part 2
In the first blog post of this series, I showed you how...
2010-07-29
585 reads
Limiting Table Access for Reporting Part 1
End users may have a need to do some form of reporting of data from source systems. Opening up the...
2010-07-29
465 reads
Jacksonville Code Camp – Introduction to Reporting Services 8.28.2010
The 6th Annual Jacksonville Code Camp is coming up fast. There are tons of great presenters slated to be here...
2010-07-26
384 reads
JULY 31: SQL Saturday 40
SQL Saturday #40 is quickly approaching and many are gearing up for the trip down there to hear some awesome...
2010-07-20
483 reads
Increasing or Decreasing Sampling Size in SSAS Data Source View Data Explorer
Recently, I have begun my quest of mastering SSAS. I realize that it may take time and I am more...
2010-07-19
516 reads
Updating Email Addresses in SSRS Subscriptions
Creating subscriptions in SQL Server Reporting Services is a great way to distribute files to end users. If it has...
2010-07-19
16,503 reads
Strange But True: Report Builder 2.0 Crashing
Recently, I have been given the opportunity to work with a company who wanted to explore the capabilities of Report...
2010-07-18
370 reads
Report Builder Stand Alone Installation
If you’re planning on rolling out Report Builder to end users, you may want to download the stand alone installation...
2010-07-18
585 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