I actually really liked the uCertify course for MTA-Database Fundamentals.  That is the one I took for getting my MTA.  That being said, if you have used SQL Server for...

Possibly a dumb question, but are both DEV and PROD using the same account to run the tool that connects to SQLPROD?  I mean an AD account, not a "local...

if the ID field was an IDENTITY, you generally don't include it in your INSERT statements as SQL will auto-increment it.  If you include a value, you need to SET...

I think it depends on your workloads and environment.  For example, if you have a data mart that gets re-loaded nightly using the truncate->reload methodology, and you are doing hourly...

There area  lot that can do it I'm sure.  The first few that come to mind are SSMS and Visual Studio though.  Both of these can see all of the...

An alternate approach would be to look at the files in the file system.  If you select multiple files (in Windows anyways), it will tell you the file size.  And...

First - I'd recommend against crossposting.  I found your post on here, Microsoft and VMWare.  This is the only one with replies though.

I do not have failover clustering set up...

if I understand right, you want to do an insert into 2 different temp tables from a CTE in a single query?  If so, I don't think that is possible. ...

My approach - get a monitoring tool to grab the data for you rather than watching things yourself and check the tool over a large timeline to get a baseline.

And...

I think the easiest way would be to join the tables in the query, but that may not be possible.  Failing that, I think your second dataset would need a...

Another approach would be to go back to your query where you have all of those CTE's and UNION all of the data from the non-master table in your second...

a_car11 - Just so I understand the question correctly, you want to get all of the records that ONLY exist in 1 of the 50 tables, correct?  I just want...

I think you will want to look into windowing functions.  in this particular example, remove your GROUP BY and change your SUM to:

,SUM(B.MappedAmont) OVER (PARTITION BY A.BudgetId,...

Offhand, I am not sure if activity monitor could do that, but I would not be surprised.  If I remember right, it opens a transaction when you open it and...

Not entirely sure why that would need to be "DNSLess"... you can use DNS without using ODBC.  But maybe I'm just misunderstanding the terminology.

Which brings me back to the first...