Browse by Tags
All Tags »
SQL Server 2005 (
RSS)
A short time ago I was working on a project using SQL Server Full Text Search. This was my first real deep exposure to the engine and it worked pretty well. However, for the project I was working on there were some very serious problems that I was never...
Sometimes those transaction logs get a little large and unwieldy! For dev machines I almost never want the transaction log to ever be larger than 1GB. I often find some transaction logs of 10GB and larger and there is little in the way of GUI tools to...
I know the title of this post is a little bit of a misnomer, business objects will never map 1 to 1 with relational database objects. However, when just starting out and when you get to control the schema of the database, it sure makes a good starting...
Naming conventions are like arm pits. Everyone has them and they all stink! Well, at least that's the perspective of pretty much every developer an DBA alike. I will present my own personal philosophy for naming conventions on databases and hopefully...
These past two weeks have been very exciting for me. I have gotten to be involved in some R&D for one of the companies that I consult for. I LOVE R&D! There is always a better way to do things and poking your head out from the sand every once...
You know you've done something wrong when it takes 30+ seconds to run a full-text query. The most annoying part of this bug is the fact that it is something very small and inconsequential that "triggers" the bug. It's a lot like an murder...
I posted a blog entry a while back about how to change the owner of a database. What that still does not solve is the problem you have when there is a database user in the database you restored and there is a database user already in your system, each...
If you do a lot of programming on a SQL 2005 database, chances are this has happened to you! You restore a database and try to diagram it (or make some other change) and get this error: TITLE: Microsoft SQL Server Management Studio Express ----------...