In the bit that reads the 10 records try using the READPAST query hint.

This should skip passed the rows being locked by the other thread.

My boss showed me some questions that they used when they were recruiting for my position.

Aparently they had a lot of candidates that didn't know the difference between a unique...

Lee, if you are going to go into Greek Mythology then we could bring in the Harpies.

Just as you are about to go home for you meal some shrieking bird...

Nope, it doesn't inherit its size from MODEL.

Its default initial size is 8MB where as MODEL is 2MB.

If I do the following

1. Restart SQL Server

2. ALTER DATABASE TempdB MODIFY FILE...

SELECT name,number,detail from mytable for XML AUTO

This will produce an XML fragment for the data but not the root node.

Sad though it may be I wanted SSC e-mails to go to my home e-mail address as well as my work address, hence two registrations.

We are one and the same, I've just changed my job.

Really old time member!!!!!!!! OK I have colleagues who are younger than my album collection but I'm not THAT...

SELECT DT.* FROM

(

Your union query

) AS DT

Giving an alias to the union query will work

If you query on a foreign key and there is no index then you will probably get a Clustered Index Scan.

The question I have is, let us suppose that you...

The big benefit of UniqueIdentifiers is that they ARE unique, which is why they are used in Merge Replication.

I have used them where I have an upside down data structure,...

ALTER TABLE dbo.xTable ADD CONSTRAINT

DF_name DEFAULT 'Yourvalue' FOR YourTable

GO

Yes, it would affect writes as data in clustered indices is is order.

Does your TEMPDB or your database grow when you Insert into your archive table?

I have had problems where a database decided to increase the size of my MDF file in...

UniqueIdentifiers are not sequential therefore you may run into some performance issues if your primary key is clustered.

I agree with your using something other than UserName as the primary key,...

I'm not sure what you mean.

If you mean that you have to check the input against a string containing characters that only a person who can enter Chinese/Korean could set...