Last Weeks Top 10 “Reading” Links #4
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-29
655 reads
Blog Posts
Microsoft Surface RT Review
Last Friday, pretty much on impulse, I decided to go to the Microsoft Store in the Park Meadows Mall in...
2012-10-29
2,397 reads
Monitor Blocking with Extented Events in SQL 2012
1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO
here we...
2012-10-29
2,641 reads
Virtualizing Your Business Critical SQL Servers Anthology
This week I completed a six-part blog series (more like five plus one) on the path to virtualizing your business-critical...
2012-10-29 (first published: 2012-10-24)
2,365 reads
Advanced TSQL training
Over the past few years, Ive had it on my to do list to write and deliver and full-scale SQLServer...
2012-10-28
1,037 reads
Countdown to PASS Summit 2012 – 9 to Go – My First Summit
We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to...
2012-10-28
590 reads
[off topic] I crossed a milestone today
Hey everyone,
I have been nearing this goal for some time (a few times coming within fractions) so this is somewhat...
2012-10-26
804 reads
Database Mirroring Error
I have been setting up multi instance database mirroring for the last couple of days along with some other DR...
2012-10-26
652 reads
DBA Question of the Day: Statistic
http://www.flickr.com/photos/_barney/5177975707/Hello Dear Reader, yesterday I posed the question to you what are Statistics? We could get down and dirty of...
2012-10-26
1,070 reads
Decoding first, root, and FirstIAM in Sysindexes
Have you ever looked at the first, root, and FirstIAM columns in sysindexes and wondered…
“What do these values mean?”
Recently, I...
2012-10-26 (first published: 2012-10-23)
1,682 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