Just out of curiosity, how long is it taking folks for Exam 70-461?

Since its been two years since this thread was started, I’m curious to see how things went?

We are going through this exact scenario right now and I'm looking...

man i was just going to post this question myself. I'd love to hear how others document out their batch/agent job schedule. Seems easy enough to get the...

I actually ran into this this morning as well. As a work around I was able to grant select on the tables on the linked server, not something I'm...

Nevermind I just re-read the whole documentation. The issue is when you prefix a table alias on a columns alais in an ORDER BY. This is not the...

Sorry to bring this thread up, but I'm still confused. WHat about the case where you have a query that joins two tables that have the same name, different...

Yes Thanks for all the help and responses. I guess my next question would be why did the DTA recommend all of these multi-column stats, and what all implications...

Thanks for the query. Does anyone know where the "Database I/O" graph gets its information? Is its OS Perf counter? or maybe it does a refresh on...

Great start to a topic I've been considering for a few weeks myself. I find it very interesting that the first reply post was to use SSIS and SSRS,...

All in all a great article, one thing I'd like to see expanded is the backout scenero. What would be cool is to have a standard backout script that...

To me the SQLCLR vs. xp_cmdshell seems like the old script vs. small application debate. Seems that SQLCLR is very similar to writing a small application. I mean...

Thanks Yelana for the quick response,

SQL Server service, SQL Server reporting service and sql agent all run under different domain IDs. I don't know if the DC allows for...

ok I found an additional way to do mostly what I want. I use a "lookup" followed by a "Conditional Split" which then I can use an ISNULL...

ahh I thought that was used for errors not the exculsion. let me try that

thankx