The Trouble with Rules
I love running. I wake up at 5am three times a week, run for an hour, and by 6:30am I’m...
2015-09-16
594 reads
Columnstore Indexes – part 66 (“More Clustered Columnstore Improvements in SQL Server 2016”)
Continuation from the previous 65 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing writing about the improvements added to...
2015-09-15
541 reads
Free SQL Training in Seattle
Free Training in Seattle!
Related Posts:
Seattle SQL Pro Workshop 2017 October 19, 2017
Seattle SQL Pro Workshop 2017 Schedule October 26, 2017
T-SQL Tuesday 109: Influence Somebody Invite December 4,...
2015-09-15
7 reads
Free SQL Training in Seattle
The annual SQL Server Professional migration is about to begin. Many of us will be descending upon the city of...
2015-09-15
674 reads
Custom Placeholders in SQL Prompt 7
I love my snippets in SQL Prompt. Adding some snippets can make work go so much quicker. I add new...
2015-09-15
1,163 reads
Powering Up HDInsight with Power BI–
On Tuesday, September 15, I presented on this topic for Pragmatic Works. You can find that session here. This session...
2015-09-15
605 reads
Ryan Adams for SQL PASS Board
It’s election season! No, I’m not talking about The Donald, The Clinton, The Neurosurgeon, The Veep, or any of those...
2015-09-15
568 reads
Actions In Extended Events
an action invokes memories of verbs and "to do" something. If you recall from the quick definition in the article on Extended Events Objects, an action is "a means...
2015-09-15
8 reads
Actions In Extended Events
The next component to discuss is Actions. I have discussed various aspects of events, schemas, categories and packages as some...
2015-09-15
1,460 reads
PASS Election Changes
The 2014 NomCom made some changes to how the election process works and it’s something you need to pay attention...
2015-09-15
518 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