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
Blog Posts
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,458 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,494 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,566 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
695 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
626 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
You Are Responsible for You
Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...
2011-05-12
748 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