Steve Jones - SSC Editor (12/7/2010)

---

Brandie Tarvin (12/7/2010)

---

I have to wonder if this thread is encouraging people to respond more harshly to articles, posts, etc. Certain we've seen an uptick...

Ann Cao (12/6/2010)

---

Thank you, for my case it turns out it's UCL is enabled on the windows 2008 server, default.

It will work if I right click managment studio and choose...

I prefer a bigger job with some custom logging over splitting it up. It makes it more obvious that it's all part of the same sequence. More "ACID".

The queries aren't nested in the order you would expect.

SELECT DISTINCT pilot_name

FROM PilotSkills AS PS1

WHERE NOT EXISTS

(SELECT *

...

CirquedeSQLeil (12/6/2010)

---

Alvin Ramard (12/6/2010)

---

I won't forget the day a Linksys CS rep hung up on me after I told him he didn't have a clue about what he was doing...

Given the limited physical power on the server, and the sheer size of the table, I'd be kind of surprised if it were significantly fast.

SQL table sizes are limited by...

It depends on how you intend to encrypt sensitive data that you keep, if you intend to keep any at all.

If, for example, you will never store credit card numbers,...

Connection pooling isn't handled by the database engine, it's handled by a higher level of code.

The upper limit on connections, if you set it to 0, is 32,767, per http://msdn.microsoft.com/en-us/library/ms143432.aspx.

Are the columns varchar or char data types?

When you install SQL Server, there's an option for adding the current login (the one you're using to install it) as an admin. If you don't select that, sa...

Real people are overrated. I've had plenty of tech support people fail the Turing...

That's generally just a matter of having Excel pick the right symbol-set, by selecting a font that supports the characters you want.

There's a whole article on it here:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

I think the articles are awesome. But I wrote them, so I may not be completely objective about that. 🙂

If you read the...

Bing or Google the name of it. You'll find data that way.

select OrderNumber

from @test

where PartNumber = 'GGT-122'

intersect

select OrderNumber

from @test

where PartNumber = 'GGT-123';

That will give you the ones where they've ordered both.

It easily expands to include a variety of complex combinations, using...