They may produce the same results, but they are different. The first query is checking the variable values for an explicit value while the second query is looking at...

Yes, you can. The keyword here is 'you' because you'll have to do it manually in SQL Server 2000. SQL Server 2005 does it all for you. ...

You cannot tell SQL Server how to store the data within the data file itself. You can, however, use SQL Server 2005's table partitioning to store each table partition...

I think you're going to get a wide variety of answers to a question like this, but...

Well then. I guess the whole point of my post was to let the world know that I have 5 kids and my younger brother has none 😀 .

Let's get back on track here. I think the question at hand is, 'Does moving the filtering columns from the JOIN to the WHERE clause have an impact on...

Well, your virtual memory represents your page file. There are a couple of things you need to know here. First off, most systems use the page file to...

Here is a link to an article that was created to help new folks formulate posts that will get them the help they want. The information you've given so...

Well, your right, it is an art and a science. First off, yes, disable the auto shrink. Secondly, as far as the fill factor goes, it all depends....

-- Get Logical file names from backup header

RESTORE FILELISTONLY

FROM DISK = 'your backup file/path here'

-- use logical file info from above in restore statement

RESTORE DATABASE YourDBName

FROM DISK = 'your...

No. Once you've normalized your tables, you won't need to worry...

And that is what you want right?

This sounds like a disk bottleneck to me. You've got your OS, paging file, and DB files all on one physical disk. Regarless of how you logically partition...

OK, so based off of what you've just posted, can you tell my what is wrong with this:

DECLARE @TableA TABLE (KeyID varchar(20))

DECLARE @TableB TABLE (KeyID varchar(20))

INSERT INTO @TableA

SELECT '11111.001' UNION...

So did you already create a database by that name on your destination server? If so, you'll need to do as Peter suggests and use WITH REPLACE. You...