GilaMonster (2/18/2010)

I got...

No you aren't. I don't have one, just a regular phone.

I have a simple suggestion that would make it easy to exclude the tables for diagramming. Create your own schema instead of using DBO. Then you don't have...

I agree with those who have said that putting the weighting of the different contributions out there would open up the system to being gamed and people who would do...

Seems like a permissions issue on the EncryptByAsymKey but I can't find anywhere where permissions required are mentioned.

Have you run this using the application login?

Alvin Ramard (2/5/2010)

Careful...

We'd know if The Thread was deleted because the SSC servers would be down because the forum database would be locked while the delete took place.

I'll second that. It's a great post and a great story. Stories...

Check out the last 2 articles in my signature. I think they will provide you with the information you need.

This really isn't a SQL problem per se, but more of a .NET/UI issue. You have some options, but they all really involve building your parameter values in the...

What is the format of the text file? I'd look into dumping the contents into a table using bcp/bulk insert and then use a join.

Nope there is not a setting to have SQL Server include white space when doing string comparison. Here's an article[/url] I wrote that sheds some light on it.

Are you calling a stored procedure or doing ad hoc SQL in the report?

Wayne,

I haven't used the Transcender stuff, but I just got the Microsoft book for 70-432, it isn't great, but I bought it instead of Denny Cherry's book because it includes...

Roy, as usual, has hit on the most common culprit, statistics. You could also check the cost threshold for parallelism and max degree of parallelism settings, it may be...