Finding missing rows
One way to find the rows from one table that don't match another table is to use a sub-query. Here is...
2008-01-22
536 reads
Blog Posts
A Holiday Posting
It's Martin Luther King, Jr. day here in the US where we remember the famous civil rights leader. So my...
2008-01-21
676 reads
Free Subscriptions to Visual Studio Magazine
First time I've noticed this being offered, saw it posted on the Orlando .Net Users Group (ONETUG) site. Sign up...
2008-01-21
1,443 reads
We Are Microsoft Charity Challenge Weekend
This weekend, I had the unique opportunity to donate some time to a worthwhile charity organization. Through the efforts of...
2008-01-21
841 reads
Learning to Blog via Books
I was chatting with a friend recently and in the course of 'what are you up to lately' I mentioned...
2008-01-20
488 reads
Connecting to a Reporting Services Model
There's always been some confusion about models in Reporting Services, many people ignore them thinking that they are only for...
2008-01-18
1,559 reads
Free Ebook Chapter(Book) - Introducing SQL Server 2008
Saw it mentioned in the recent MSPress newsletter, Peter DeBetta is writing Introducing SQL Server 2008 and right now Chapter...
2008-01-18
860 reads
MS Making .Net Framework Source Code Available
Scott Guthrie posted the announcement on his blog today. It's a 'read only' license with a few other limitations, but...
2008-01-17
757 reads
MVP Chat
My first MVP chat was today, a monthly hour long session where we have a Microsoft representative and we all...
2008-01-17
725 reads
Partitioning Part 4 Posted on SSC
Partitioning Part 4 concludes the series with a look at 'real' partitioning in SQL 2005 Enterprise Edition. Overall the series...
2008-01-17
559 reads
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
The New OS Wars
Comments posted to this topic are about the item The New OS Wars
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers