Using MS SQL Server

Best practice on nullability and default value
For a table of about 15 columns, is it all not nullable with default values better performance or some are nullable and some with default values. Requirements: in addtion to data UPDATE (insertion, update and deletion), some columns might need to support search (hence indexed one way or another). In one envir... 15 Jul 2008 05:07

Patch for KB948110 causing random "Could not find database table ID" errors
Larry Leonard (Larry(a)definitivesolutions.com) writes: Googling for "KB948110" has led to a handful of people having various problems with this patch, but not mine. I did notice someone complain that the patch had been applied to SQL Server 2000 SP3 database when it should not have. This made me realize th... 12 Jul 2008 17:39

Patch for KB948110 causing random "Could not find database table ID" errors
Running MSDE 2000 SP2 on Windows XP SP3. I have a T-SQL script that is relatively simple (adding constraints, inserting rows, etc.) and short (maybe 300 lines, heavily commented). It's an upgrade script I wrote weeks ago, and has worked fine everywhere. After the patch from last Wednesday. "Security Update for... 12 Jul 2008 16:38

Help With Full Text Search. Performing AND across columns
On Jul 10, 7:00 am, Sham <shamil.s...(a)gmail.com> wrote: I am trying to perform the following query on a table that has been indexed using Full Text Search. The table contains multiple columns than have been indexed. (Below, all xml columns are indexed). dbo.maintable(ProfileID int pk) dbo.fts_table... 16 Jul 2008 10:55

Database Compare,Data Compare tool,sort sync scipts with database dependencies.
DBC (Database Compare) is a fast, comprehensive database structure and data comparison tool.Sort sync scipts with database dependencies. www.d-softs.com ... 11 Jul 2008 06:51

How to compile TPC-H ver2.7 on Windows XP?
Hi, i want to use the DBGEN and QGEN on Windows XP. Can i do that, or i just can compile the tools on Unix? I am looking forward for your reply. Many thanks! -Nick Cheng ... 11 Jul 2008 01:44

complicated query (where statement inside select statement, don't know how to explain it)
hello, just joined the group, i've run into a wall and am seeking some help. here is my query: SELECT DATEPART(year, TTmain.TTDate) AS 'Year', SUM(TTmain.TTAmt) + SUM(TTmain.TTFee) AS 'Total' FROM TTmain INNER JOIN TTdealers ON TTmain.dealerID = TTdealers.dealerID GROUP BY DATEPART(year, TTmain.... 11 Jul 2008 13:01

Insurance data models...any tips on good starting point?
We have a client that has the typical online quote generator but is looking to revamp that process and tie it in with other services he can sell to other insurance clients. The application is still in its infancy but could have the potential of blowing up in our face if we don't plan accordingly. The old website... 11 Jul 2008 10:57

Are Deadlocks inevitable ?
There are many references to deadlock handlers that retry the transaction automatically. But IMO a deadlock is the result of a design flaw that should be fixed. My applications treat deadlocks like any other runtime error - they are logged and fixed. There seems to be a an opinion that deadlocks are inevita... 10 Jul 2008 18:35

Help With Full Text Search. Performing AND across columns
I am trying to perform the following query on a table that has been indexed using Full Text Search. The table contains multiple columns than have been indexed. (Below, all xml columns are indexed). dbo.maintable(ProfileID int pk) dbo.fts_table(ProfileID int pk fk, col1 xml, col2 xml, col3 xml) I want to perfo... 10 Jul 2008 07:13