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,282 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
442 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,134 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
802 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
566 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,351 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
580 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
438 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
429 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,217 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers