Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
select dateadd(day, 0, datediff(day, 0, b.mydateutc)) mydate, count(b.ticketid), b.empid from temp1 a inner join tickets b on a.ticketid = b.ticketid and a.ticketsessionid = b.ticketsessionid
|Read a Table and add those records into a existing parameter that was send from a SSRS report||11||64|
|Help with SQL - TOP 10 by date and by group||13||42|
|Faster way to get row count from a view than select Count(*) from ViewObject?||2||38|
|Find unused columns in a table||12||75|