15Aug 2008 by Grant Fritchey 1 Comment

SQL Server 2008 Install, cont.

Tools
OK. Hopefully you're all reading this stuff BEFORE trying to do the install and certainly BEFORE uninstalling everything in sight. The latest version of SQL Prompt, version 3.9, is 2008 compatible AND doesn't cause this problem with the install. So, I've got to reinstall the software. Time to track down my license. I hope I kept that email.
Read More
15Aug 2008 by Grant Fritchey No Comments

SQL Server 2008 Install, cont.

Tools
OK. I found some information. The first suggests uninstalling SQL Prompt. I tried it and that did the trick. The second suggest was to do a brute-force removal of the registry key: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90. I didn't get there.  Install is running on the desktop now. That seems a bit mean of Microsoft, requiring me to uninstall Red Gate's SQL Prompt, especially since it's such a great little tool. I wonder if I can install it on top of 2008? Time for some more research.
Read More
15Aug 2008 by Grant Fritchey 2 Comments

SQL Server 2008 Install

Uncategorized
I just finished the install of SQL Server 2008 RTM on my laptop. No real issues except that it wanted SP1 of Visual Studio installed before it would complete. Once I had that done, everything was up and running. The new install routines are nicer than the old ones if a bit more detailed. My desktop is another matter. SQL Server 2008 objected to a SQL Server 2005 Express install. I removed that. It still thinks Express is installed. I'm removing all of SQL Server 2005 to see what happens.  The error reported was pretty non-helpful. This is a bit odd since the laptop also has a copy of Express installed. Well, uninstalling all things SQL Server didn't work. Sql2005SsmsExpressFacet is failing. It simply states: "The SQL Server 2005 Express…
Read More
15Aug 2008 by Grant Fritchey No Comments

More on Table Valued Functions

T-SQL
From the hits in the search results, this is a popular topic. That being so, I'd like to redirect you to another blog that has some more detailed tests available. These tests show more of the shortcomings of multi-statement table valued functions. Gail Shaw is an MVP and a regular at SQL Server Central. She's worth tracking and this post shows why. I want to be clear. I'm not suggesting that you never, ever, use multi-statement table valued functions. There may be places where their use is helpful. I'm saying that using them comes with a very heavy cost, so you better be sure that they are in fact needed in the situation, whatever it is. There was a long discussion and debate over at SQL Server Central recently on…
Read More