he's really quite smart. unfortunately, plebes get access to his stuff and just eff it all up. for instance, we now have a CTE and a UDF for creating a dummy 0 result set "in order to force parallelism"
have a star. i'm delirious. i feel like a third wheel who keeps interrupting the moments that BErik and Jobbish are having. that's what happens when i have to install 2008 r2 patches
"cant use a clustered columnstore with RCSI/on a readable secondary" ... "multi-column statistics can't really be used by that newfangled cardinality estimator"
@PaulWhite my faaaaavorite is when you read through sp/cu release notes, and something doesn't have a title or description, it only has a link to another kb
and it's always something like "parallel queries may cause scheduler deadlocks when run from an account with db_reader permissions"
Uh, what? Doesn't sound like Paul at all. We'll be partying tomorrow night. Tonight I went to Disney Springs to get shirts made for the kids (they're coming Thursday for the weekend).
I have an AUTO INCREMENT field in my table (userid, name). I want to do a SELECT query immediately after an INSERT query. Currently, I do INSERT first and then do a separate SELECT query to get userid from name. Is there any way I can combine the two into one query?
The userid would have been calculated while the INSERT was being done. So I consider doing another SELECT query as a waste.