I guess the next challenge would be to create the sp for users to formatt hard drive or/and re-install Windows and SQLServer. 😀

You have quite demanding users, man!

Joe Celko (6/23/2010)

1.Rows are not records.

2.SQL programmers do not use BIT flags; that was assembly language and punch cards.

3.Being a primary address of a person is a relationship and...

Of cause!

Only very bad SQL...

Users to drop databases? Why only in test environment?

That is the coolest idea I ever heard of!

😀

That query does exactly what you have asked for:

SELECT codes, count(*)

FROM ABC

WHERE codes in ('bc', 'cd',...

First of all you have...

From, what I can see, the query I gave you does not return running totals but retuns the count of loggins for each hour for period of time during the...

Gail,

I've run test more than 5 times (and I did few concurrent queries as well). Please believe me I've tried the best (on my machine and on aour dev server)....

If you don't care about duplicates and not all letters from A to Z to be used, you can use the following:

INSERT INTO tblExample(fname,sname,email,code)

SELECT fname,sname,email,

LEFT(REPLACE(CAST(NEWID() AS VARCHAR(150)), '-',''),8) AS...

A lot of other ways:

1. By phone (some one calls you and dictates...

You could add PrimaryAddressId column into your Person's table, that would ensure the person has only one primary address.

Attmept to set max memory to its minimum value of 16Mb caused SQL to stop executing any query on midium sized tables :w00t:.

Increased the max memory allotment to 32Mb, made...

Dave Ballantyne (6/22/2010)

Why (other than curiosity ) ? It seems a lot simpler to...

Thank You, Gail.

It almost there. The reason of getting data not in order is using TABLOCK hint.

But now I have another question, when would SQL Server place a TABLOCK on...

Dave and Gail,

I do totally agree with you on use of "ORDER BY" to ensure the order. Sorry, of cause data is stored logicaly and retrieved in the logical order.

However,

I...