Archive for category: SQL Server
7 July, 2007 (07:22) | SQL Server | By: Thomas
Linchi Shea reports that running stored procedures on SQL server without the Owner qualifier – as in dbo.xxx for example – can impact the performance of that server and database in drastic ways. Depending on which version of SQL Server you are running just adding an owner qualifier can get you anywhere from 5% to [...]
No comments
13 June, 2007 (05:34) | .NET, .NET Tools, SQL Server | By: Thomas
Roger Jennings has a nice summary and various links to a great article by Ian Cooper that looks at LINQ from the point of view of DDD, TDD and PI.
Roger notes another voice in the chorus that reiterates we need support for more db’s than simply the ones by MS. He says “….He then goes [...]
No comments
22 May, 2007 (19:01) | SQL Server, Software Architecture, Software Quality | By: Thomas
Who can blame the guy. He has a product that supports a bunch of different database servers. So consequently he is very familiar with his subject matter.
He says: “…Scientists should stick with science. What they invent and discover should be moved to the real world by engineers, not by scientists as well. Because, if you [...]
No comments
16 May, 2007 (20:14) | SQL Server | By: Thomas
Here is an odd situation I came across today. This probably wont happen to many other people because it is so specific to certain network settings. But if it happens to you, maybe I can save you the 4 hours I spent on hold today with MS SQL Server PSS… whilst paying $250 for the [...]
No comments
28 March, 2007 (05:32) | .NET, .NET Tools, SQL Server | By: Thomas
SD Times reports : “…Evans Data today released statistics that showed MySQL usage growing among developers over the past two years. The results of this two-year survey showed that 40 percent of American developers are using databases in their work, and among those, 25 percent more are using MySQL than were two years ago. A [...]
No comments
22 March, 2007 (05:02) | .NET Tools, SQL Server | By: Thomas
Speaking of LINQ, Caber Computing offers a beta for a product called SqlTac which hopes to do several interesting things. First it attempts to provide a graphical representation of the “soundness” or efficiency of your db. Secondly it allows you to cretae versioned set of scripts plus a test database containing – you guessed it [...]
1 comment
8 March, 2007 (05:31) | .NET, SQL Server | By: Thomas
Louis Davidson at simple-talk has an article by the same name. I’ve pulled the following section from it, because I am currently faced with EXACTLY this problem. One of our Architecture Astronauts thought it would be good to store differing types of data in one table.
One of the hardest things in our industry is [...]
No comments
15 February, 2007 (06:08) | SQL Server | By: Thomas
In the years since the storage engine was re-architected (SQL Server 7.0+) there’s been constant debate on how to appropriately choose the clustered index for your tables. I’ve generally recommended an ever-increasing key to use as a clustered index and many find that counterintuitive. The primary reason people feel it’s counterintuitive is that it creates [...]
No comments
3 February, 2007 (21:11) | Asp.Net 2.o, SQL Server | By: Thomas
This is really very useful in larger sites. Now I only wonder if having a SiteMap provider can increase SEO. It even includes a nice little example of SQL 2005 cache dependency
The one drawback to site navigation is that XmlSiteMapProvider is the one and only site map provider included in the box with ASP.NET 2.0, [...]
No comments
21 October, 2006 (19:11) | .NET, .NET Code Related, .NET Tools, Asp.Net 2.o, SQL Server | By: Thomas
My collection of interesting links has been growing for weeks and I haven’t had the time to post them. So here they are in one massive list.
Daniel Zeiss is on rev 9 of his major Ajax framework comparison. Great stuff.
Today I installed ScrewTurn Wiki in 10 minutes (as opposed to an hour for [...]
30 comments