PASS Update #20
On the Friday at the end of the Summit we had a 4 hour Board meeting, welcoming new board members...
2009-12-03
1,286 reads
On the Friday at the end of the Summit we had a 4 hour Board meeting, welcoming new board members...
2009-12-03
1,286 reads
I’m flying out Sunday via Alaska Air, taking the direct flight from Orlando to Seattle, arriving at 11:40 am. If...
2009-10-30
1,200 reads
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
2009-10-27
1,051 reads
Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.
2009-10-15
1,219 reads
I ran across this article about networking sins a while back and have had it on my list to share....
2009-09-25
2,229 reads
In the next week or so I’ll be upgrading the SQL 2005 server that has the SQLSaturday database and I’m...
2009-09-24
1,829 reads
I’ve been on the board just about 8-1/2 months, so I’m not doing too bad on updates, but think I’ll...
2009-09-18
1,080 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-10
845 reads
I enjoy woodworking as a hobby and as I try new things I find that my work habits during the...
2009-08-31
2,092 reads
I’ve touched on it some in the past, but it’s a question that comes up a lot when we discuss...
2009-08-21
2,360 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you’ve been here before, you know this blog is usually about SQL Server,...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers