Tag: sql server

Community

SQL Server 2005: Late but Loaded

(Brian Moran) Two weeks ago, I wrote about the delay of SQL Server 2005, formerly code-named Yukon. Microsoft has pushed back commercial availability of SQL Server 2005 to the first half of 2005, presumably closer to June than January. In my earlier article, I asked you to share what effect SQL Serv

Community

FIX: You may receive an Internal SQL Server error error message when you run a Transact-SQL SELECT statement on a view that has many subqueries in SQL Server 2000

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this

Community

What You Don’t Know

(Andy Warren) Sometimes it’s what you don’t know that hurts. Sometimes it hurts a lot! Recently one of our developers was just about to pound his head on the desk in frustration, trying to figure out why some TSQL was not working correctly. It looked something like this: set @SomeVariable = @Some