digdave7 (6/3/2011)

---

No to sound rude, but are you kidding me by saying Nolock is a bad idea 99% of the time....? Everyone I know has clearly shown it has huge...

mister.magoo (6/3/2011)

---

This is definitely going to be my last post on this thread because I am getting an ache from having my tongue in my cheek for so long 😛

...are...

sqlnaive (6/2/2011)

---

Ninja, Updating the stats with 20% may faten the process. However In our scenario, it may not resolve the issue entirely. There are two points:

1. The entire dataset on...

mister.magoo (6/2/2011)

---

Michael Valentine Jones (6/2/2011)

---

mister.magoo (6/2/2011)

---

0.999.... = 1 ? No. There I said it.

One is a series of 9s preceeded by a ".", the other is a 1.

You can decide...

mister.magoo (6/2/2011)

---

0.999.... = 1 ? No. There I said it.

One is a series of 9s preceeded by a ".", the other is a 1.

You can decide to treat them as...

1/9 = .111...

9*(1/9) = .999...

9*(1/9) = 1, therefore 1 = .999...

Other proofs here:

http://en.wikipedia.org/wiki/0.999...

I'm waiting for Jeff Moden to supply a proof using a tally table. 😎

You have bad results but you didn't explain why they were bad or show an example of the bad results, didn't show the data that the bad results are based...

I come down on the side of the surrogate key for a simple reason:

I have had many occasions to regret when I or (usually) someone else used a natural key,...

The whole "Greed is Good" thing sounds very similar to Adam Smith in "The Wealth of Nations":

"As every individual, therefore, endeavours as much as he can both to employ his...

Paul Randal address the whole tempdb data file per processor core story here:

A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core...

"...Last week LInkedIn had an initial public offering (IPO), which was very successful..."

The last word has not been written on this yet. The typical result of an IPO is...

The one really good use I have heard was a company that needed to collect responses to their Super Bowl advertising.

It let them put up a high volume server quickly,...

I don't feel up to looking into what is going on with your query, but if you just want a random series, this is probably simpler and closer to what...

Another workaround is to create the same login with the same SID and password in each domain, and use that to connect from the web server to the SQL server.

If you are getting "SSPI handshake failed" errors, have you created SPNs for the database server?

http://www.sqlservercentral.com/articles/Security/65169/