Bug? Can’t Pass TVP to SQL Function Twice
I run into a bug recently with SQL Server 2012. I believe this exists in SQL Server 2008 as well....
2012-06-20
1,103 reads
Blog Posts
Contracting – Your best clients are your current clients…
and your old clients too.
Before I started my contracting business five years ago I realised the importance of selling and...
2012-06-20
840 reads
Corrupt Model database
An interesting case arose at work the other day. SAN issues had caused SQL Server to shutdown and it was...
2012-06-20
762 reads
Get Your Ass to PASS!
This year there are to be no excuses, and I mean it.
You know what I’m talking about. There’s always some...
2012-06-20
826 reads
My journey finally ends at the SQLPASS 2012 Summit
Yesterday SQLPASS revealed the sessions that were selected for the upcoming SQLPASS
summit in Seattle from November 6 – 9. I'm very...
2012-06-20
797 reads
SQL Server 2008 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-20 (first published: 2012-06-11)
3,071 reads
SQL Server 2012 CU2 – Have a little fun (#AppliedSQL)
SQL Server 2012 Cumulative Update (CU) 2 is out! If you’re like Me-from-10-years-ago, you couldn’t care less!
But there are actually...
2012-06-20
1,293 reads
SQLBits X videos online
All the videos for this popular conference are online or will be soon (69 of them). Take a look at the...
2012-06-20
1,132 reads
Vacation Notes
I wrote this over the course of 10 days, so it’s a bit rambling, but maybe you’ll find a good...
2012-06-20
801 reads
Enumerating Index Fragmentation with Powershell and SMO
I wish I could say that this was a simple task, but as I dove into SMO and some of...
2012-06-19
2,747 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries
The Service Name
Comments posted to this topic are about the item The Service Name