That may well be true, but I've read "somewhere" (might've even be a SQL server book) that you could make something like 10million GUIDs a second before they would repeat...

Whilst it may not be totally relevant, you should always (according to several articles & threads on this site) have a clustered index on your table - then the data...

I just replied to the message prior to this one in the forum http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=49&messageid=107197

The solution I gave there should help you with this - set based, no cursors or...

I had a similar situation with allowing users to create their own columns in a Doc Management System. 

Something along the lines of

select ProductID,

          (select Value from tblProductAttribute...

Why not do something like a

select distinct *     --often nicer to specify col names

from MyTable

into #MyTempTable

then truncate/delete all data from your original table and insert the now distinct data back...

I generally use the rule that if you are performing any maths on the number, or if it represents a quantity, etc, then store it as int (or numeric, etc)......

I have the same problem as described by Phillip Kelly.

I chose (for the clustering question) the correct answer in MS Outlook which took me to a webpage saying that it...

Also another reason for nesting stored procs is to avoid potential recompilation.

Eg, you might have a stored proc with 5 lines of code that can often cause recompilation...

It is better...

Up until about two months ago, I thought it was totally silly and had very little use... But, one, I hope "clever" <g>, of them did spring to mind.

I've been...

I thought that timestamp values were only guaranteed to be unique within a single table, not an entire database. In either case, you still shouldn't have that problem. ...

I've got my application making views of the data called (for example)

fred.dataView

joe.dataView

Thus when the user is logged in running ad-hoc queries (mainly for reporting purposes with Crystal) Fred sees only...

Instead of writing looping scripts for fixing logins, why not just use the auto_fix parameter? (See BOL)

Ian

I think I've noticed a bit of confusion regarding x-log backups and differential backups. For a differential backup strategy, you can do a full backup weekly, then a differential...

How exactly are you checking for "new records"? Some sort of date field? If so, have you ensured that field is not being updated by some other means?

Also,...

Been getting really frustrated to have this run in under several minutes to return the rows between 20 & 40 in the database. In the end I have resorted...