I'm using the SS debugger and I want to set a watch on the table variable so I can set a breakpoint, inspect and view the values of the table...

I ended up debugging through SSMS directly on the DB server

any idea why this might not be working?

yep that's the right way thanks

A null parameter should essentially not be applied as a filter. A null parameter means the user did not want to filter by that parameter.

Ah ha. Figured it out:

The Microsoft.SqlServer.Management.Common namespace resides in the Microsoft.SqlServer.ConnectionInfo.dll assembly.

The problem is that the dll does not exist on my computer so I need to download it from somewhere or install a program that includes it and copy the...

David Moutray (3/5/2015)

---

sqlguy-736318 (3/5/2015)

Thanks! I seem to remember that there was a heuristic for a long time that queries that join more than 5 tables should generally be avoided....

One benefit of breaking the query into temp tables is that allows the SQL writer to logically group related tables/data.

For example, course-related tables/data could be grouped into 1 temp table...

David Moutray (3/5/2015)

---

My rule of thumb is exactly what you just described: if I have trouble understanding a query, I want to break it into smaller pieces that are...

Because you would be breaking the problem into pieces which inherently simplifies the problem....

that's it thanks!

Thanks Eirikur, that's the basic N:N implementation I had in mind. My question was, is N:N the correct relationship for the scenario I'm describing, and under what scenario would I...

I'd actually like to ensure that all events in the event log are included in the SS DB. Not just errors and not just events related to SS. ...

select userid, incidentid from mytable

no functions or indexes. running query through ssms directly on the db server