devLINK Technical Conference to be Held in Chattanooga, TN, August 17-19
This year’s devLINK Technical Conference will be held at the Chattanooga Convention Center, Chattanooga, TN this upcoming August 17-19, 2011....
2011-05-25
642 reads
Blog Posts
Efficiency of Subqueries and OR conditions in SQL
A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
SQL queries...
2011-05-25
963 reads
Looking Back at SQLRally Orlando
It’s been almost two weeks since we wrapped up our first SQLRally, and in some ways it hasn’t quite sunk...
2011-05-25
654 reads
Monitor your SQL Server Agent Proxies Using PowerShell
Over time it's easy to lose track of the things you set up to get work done. As a consultant,...
2011-05-25
1,242 reads
New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO
New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO
A colleague I work with on the PQO* Operations SQL V-Team, Jonathan...
2011-05-25
1,522 reads
Nominations are Open for the Fourth Annual Exceptional DBA Awards
SQLServerCentral.com, along with Red Gate Software, are glad to announce that nominations for the fourth annual Exceptional DBA Awards are...
2011-05-25
1,434 reads
Oh ****!
Did you ever accidentally close SQL Server Management Studio? And, in closing SSMS, did you get the prompt that says...
2011-05-25
921 reads
Recovery Model for Every Database
One thing that is enjoyable about my position is working with people who have no idea what SQL is besides...
2011-05-25
1,175 reads
SQL Server Migration Assistant v5.0
I bloog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA...
2011-05-25
678 reads
SQL Treeo – Create custom folders in SSMS
SQL Treeo is free add-in to SQL Server Management Studio (SSMS) which enables user to create own folder structures within...
2011-05-25
976 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