You've tested something different than the question.

Hung up at work, so no live draft for me. I ended up with a B grade and apparently I need to somewhat root for the Steelers this year.

Indeed they are. Corrected and thanks.

I saw something interesting like this with one of Brent's demos.

Parameter from app is nvarchar()

Table is

create table Sometable (
somepk int
, someval varchar

If you don't need them, purge them. If they're queried rarely, partitioning might help with management and remove some blocking/locking.

No entry fees. SSC puts up prizes though

Not sure. I think the intention is if you have lots of sparse columns, rather than having long queries for each, you get a single column with the values that...

I'd think those are 3-4 articles at least. Assume SSIS is installed on the server side, but for the client side, show the install and an import, like a CSV....

Check with your mail administrators. They might have restrictions on STMP relays.

Thanks

bump

bump if anyone wants to take this

bump