Now I am wondering how to optimize personal edition for atleast 300 concurrent queries

You can't. The 'optimization' for 8 concurrent queries is not some specific confugration that you can change,...

By "the next day, I truncated the data and ran it again", do you actually mean you ran TRUNCATE? If you have foreign keys on the table you cannot run...

Oh yes, you are absolutely correct in that. Whenever I just need to get a feel for the number of rows in a table that is the wuery to run....

An "anyone-of-a-lot-of-possible-persons" question.

Both primary keys and unique constraints are enforced by SQL Server with a unique index, so there is no need to create it yourself.

Oh, and also, rowqcnt is no different from rows. The latter column is only there for backwards compatibility, but both of them have the same problem with not always being...

A table that does not have a clustered index is called a heap, and it will show up in sysindexes with indid = 0. If a table does have a...

Not exactly, it means that you should not rely on that value being correct. In fact, the general advice regarding anything with system tables is that you should not depend...

Even though the SQL Server engine might use parallellism to execute a query quicker (though highly unlikely with these queries), it does not mean that the clients suddenly become asynchronous....

This should work I think:

DECLARE @year INT, @isoweek INT

SET @year = 2005

SET @isoweek = 31

SELECT

DATEADD(d, (@isoweek - 1) * 7,

CASE (DATEPART(dw, CAST(@year...

I would probably do something like this:

1. Create a new set of files in a new filegroup. I would not create 2x250GB files, since that is just asking for the...

Raj, I just reread the entire thread and see now that I misunderstood you a little. If I understand you correctly, you will always drop the (target) table and recreate...

Unfortunately there doesn't seem to be any info on it available. At least I couldn't find any. Post a link here if you do. I heard her talking about it...

Yep, what you want to do instead is look for autocreated stats and probably create an index for those columns, since SQL Server is basically saying to you that it...

I do not know what there is out already in the DBA space, but Beachemin et. al.'s "A first look at SQL Server 2005 for developers" is very good at...