Hotmail and Yahoo Mail (and gmail, for that matter) are not SMTP servers that you can connect to that way.

You should be able to send mail to them (I have...

Any nullable column does take space, but keep in mind that the disk space used by the database is in multiples of pages, which are 8kb each.

As far as nulls...

Yes, even on such a small table, you should have a primary key.

Even there, it allows the query optimizer to know things about the table that make it run faster....

Try this, see if it does what you need:

ALTER PROCEDURE [dbo].[MatterSearch]

@AccountId varchar(20) = NULL,

@IDNumber varchar(20) = NULL,

@ClientRef1 varchar(255) = NULL,

@ClientRef2 varchar(255) = NULL,

@Surname varchar(100) = NULL,

@TelNumber varchar(20) = NULL

AS

--searches for...

Of course, if you really, really need 2000 "columns", you could probably fake it with XML data types. I can just imagine the grinding noises that will come from...

I don't think the database is going to be the only problem with this. I can't imagine trying to make an application deal with this. Or a report.

I've gone both ways on this one. In one case, the pictures were the central data for the database, and it made more sense to store them in the...

What relationship is there, if any, between placement fees and boardings?

If there isn't one, you're going to end up with, effectively, a cross-join, which will give you row multiplication.

My first question on this is: Are all of the columns being run with "like" string data or numeric? I would normally expect columns like "AccountID" to be an...

Having one file for tempdb per CPU core allows for more efficient use of parallel processing. It allows each core to use a different file, which means it can...

As someone else mentioned, when it comes to cost, I have to add in reliability as a major factor, not just speed.

RAID-0 is cheap and high performance. I'd never...

RyanRandall (10/2/2008)

What if the table...

You can also do chained CTEs:

;WITH

CTE1 as

(select ProductID

from Production.Product),

CTE2 as

(Select AddressID

from Person.Address

where AddressiD in

...

At the beginning of the package, put an Execute SQL step that checks for rows. If it finds rows to export, have it return a 1, if it doesn't,...

If (select isnull(column, '') from table) != ''

print 'Not Null or Empty'

Else

print 'Null or Empty'

I'm using Empty for just a space.