I have not seen a significant amount of difference on the machine I tested at least for SQL itself.

My suggestion is add a column (tinyint) and default to 1 on insert. Set all existing rows to 0 and then place a trigger to update the rows affected on...

Oops, got egg on my face. Forgot about this part. "If there are 8 or fewer bit columns in a table, the columns are stored as 1 byte. If there...

Or another alternative is

where dateadd(d,datediff(d,0,result_date),0) = dateadd(d,datediff(d,0,getdate()),0)

100 million doesn't actually seem like a lot. Have you verified you have the proper indexes for you needs.

However if the data has nice break points to make smaller tables...

This should not cause an index drop and rebuild need.

ALTER TABLE dbo.tblName

 DROP CONSTRAINT Default_name

GO

ALTER TABLE dbo.tblName ADD CONSTRAINT

 Default_name DEFAULT ('ValueHere') FOR ColumnName

GO

You cannot do it that way at all. However take a look here for a way to accomplish using ActiveScript object.

http://www.perfectxml.com/Articles/XML/ExportSQLXML.asp

There is a Licensing applet in either the Control Panel root or Admin Tools sub of Control Panel where you can perform this.

Using the iso stanbdard format yyyymmdd will always save you headache.

Yea, I don't believe in that school. If you don't know what the data is then don't say you do. However I agree either use NULL or you will have...

Nullable or not nullable will not change the size of the row when the columns are fixed width. There is a bitmask for all columns to say which is null...

Question is an issue because the answer can be any of the three that are not ints for the func marks. It also is considered bad practice to use bit for...

There are a number of ways to do this. My personal choice is using a LEFT JOIN and check for NULL condition.

SELECT

*

FROM

Clients C

LEFT JOIN

Owners O

ON

C.ContactID = O.ContactID

WHERE

O.ContactID IS NULL

Usually the connection object drivers are provided by the vendor. For the most part on the machine they are installed on they will be viisble for use in DTS (make...

What do you mean DTS mappings? DTS is structured data and stored in a binary object in the MSDB database in the DTS related tables. But you cannot get info...