Not likely.  First, most people won't open a spreadsheet on forums.  Second, the spreadsheet contains no formulas so there's no information in it to...

p.s.  And welcome to SQLServerCentral.com!

You usually don't need the likes of SSIS.  Many will disagree with me on this but I consider SSIS to be an unnecessary added layer (less politically correct: an unnecessary...

To emphasize the lesson that John Mitchell is trying to teach, become independent and don't limit yourself to "just" the answers you might get on a forum.  Try his searches...

BWAAAA-HAAAA-HAAAAA!!!  "Modern"?  It may be more recent but it sure as hell isn't more "Modern".  "Crippled" is a much better word!

Technically, the given answer is incorrect because you can, indeed,...

Hi Jeff,

Below is the index that key lookup is using. Can you please let me know how I can use COUNT with a GROUP BY that matches the keys...

Thank you for the feedback, folks.  It'll be interesting to find out if anyone uses it for the things that I've started to use it for or maybe even a...

Just remember, what you want to run are trace events. The Profiler tool is just for consuming the data generated.

However, I'd be remiss if I didn't point out that...

The code I showed was missing and "end" and a ")".

But was suggested to me that I would use this instead, and it works great!

Link

In case someone else...

I am using Visual studio to design databases for applications / data warehousing rather than just using the SSMS designer like I did in the past, but now I...

Hi,

I'm seeing key lookup which is taking 95% of time for a query. I have verified and made sure that there is no index fragmentation and stats are up...

There's actually a very easy, almost trivial method to solve this problem.  Here's the article on how you could pull this off.  And, please, tell us why they want to...

Sounds more like a bug than a feature. Is this actually useful for anything beyond bar bets? Why would a single insert that breaks the rules be advantageous? Especially...

Totally agreed on that, Jason!  It'll be interesting to see if anyone posts theirs.  And, thank you for posting yours!

Thanks for the very kind feedback, Jason.

Interesting code, Jason.  While I've seen such a thing before, I've not seen many folks that provide a starting value and number of rows...