SQL University Troubleshooting Week: Communication
It should come as no surprise that the first topic I am covering this week is communication because the first...
2011-05-24
1,440 reads
Blog Posts
Your DBA Role is Changing. Are you Ready?
Where do you see yourself in the future? Are you working at the same company, are you working in a...
2011-05-24
1,101 reads
Collation Conflicts in a SQL Server Join
I went to run this query recently:
select TOP 10 *
from users a
inner join Banned b
on a.username = b.usernameand...
2011-05-23
4,619 reads
Community Podcast CALL FOR CONTRIBUTIONS
If you’re already a MidnightDBA Groupie, then you’ve probably already heard about my fabulous inspiration: a new SQL community podcast! Now...
2011-05-23
1,633 reads
CTE, Recursion and Math
Earlier this month we had a TSQL Tuesday on the topic of CTEs. I bailed on my submission because I already posted some CTE examples and was bone dry...
2011-05-23
22 reads
CTE, Recursion and Math
Earlier this month we had a TSQL Tuesday on the topic of CTEs. I bailed on my submission because I...
2011-05-23
1,478 reads
Doing Good Isn’t Easy Some Days
A few weeks back I was on a short trip with my family and as some trips go, it had...
2011-05-23
675 reads
Let’s Get Visual – The Art of Report Design
Paul Turley
Mentor, SolidQ
This article is based on my session at TechEd on May 18th, 2011
Report styles vary depending on the...
2011-05-23
3,615 reads
Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 1
Pliant Technology, New Kid On The Block
If you have been reading my storage series, and in particular my section on...
2011-05-23
3,206 reads
Show correct totals when using SSAS role security
When using role security in SSAS, one point of confusion is when a person sees the grand total for a...
2011-05-23
869 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Cilandak KKO I Telp/Wa:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Alamat BCA KCP Arkadia Telp/Wa:0821-8200-203
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
BCA KCU KUNINGAN Telp/Wa:0821-8200-174
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers