Introduction to Common Table Expressions
Learn how to use common table expressions to simplify your code. Replace temp tables and correlated subqueries with this cool T-SQL feature.
2009-12-08
15,232 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Back Home after PASS 2009
I got home Friday evening after spending several days in Seattle at PASS 2009. This was my seventh PASS Summit...
2009-11-08
436 reads
SQL Server 2008 cluster install and slipstreaming!
I was asked to set up a SQL Server 2008 cluster on Windows 2008 R2 this past week. One interesting...
2009-10-31
2,127 reads
Beginning T-SQL 2008
My book "Beginning T-SQL 2008" came out about two weeks ago. http://www.amazon.com/Beginning-T-SQL-2008-Kathi-Kellenberger/dp/1430224614/ref=sr_1_1?ie=UTF8&s=books&qid=1256604424&sr=8-1 It's a beginning book because I assume that the...
2009-10-26
794 reads
Thanks, Brian!
This past Tuesday, Brian Knight visited the St. Louis SQL Server User Group to present on SSIS. The day ended...
2009-06-14
559 reads
Submit your PASS abstracts now!
Hey, there are probably some other blogs here letting you know that the PASS call for speakers is open right...
2009-03-30
1,344 reads
Tagged again
Once again I was tagged to answer a question. This time by Chris Shaw http://chrisshaw.wordpress.com .
Here is the question: Do...
2009-03-05
575 reads
Chain Blog from Tom LaRock
I have been tagged by Tom LaRock to write about “what was your first computer and what were some of...
2009-02-19
430 reads
St. Louis Day of .Net
Yesterday I spoke on 2008 T-SQL and Data Types at the St. Louis Day of .Net event. This was an...
2008-12-14
423 reads
Grouping Sets
I have given a talk about new data types and T-SQL features to three local groups. I am presenting it...
2008-11-28
2,212 reads
Blogs
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Forums
ALAMAT BCA KCP Burangrang Telp:08218154393
WA:08218154393 Jl. Burangrang No.44, Burangrang, Kec. Lengkong, Kota Bandung, Jawa Barat 40262
ALAMAT KONTAK BCA KCP Bantul Telp:08218154393
WA:08218154393 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers