sure the final result must be one of those data types....but you can convert your columns to the acceptable data types and you are all set.
and anyplace they say...

files are actually zip files with a sqlplan extension.

On Plan1_server1 you can see the estimated and actual number of rows are way off(estimated = 91.2K, actual = 1.8K,...

variable, string OR [COLUMN NAME] of type varchar/nvarchar  is accepted for the parameter!
so if you choose a column, or the converted value of a column that is NOT a...

For the RevenueAmt, if the datatype is MONEY, the convert function has an additional parameter and will insert your commas for you. if it si a decimal, you have to...

I did this once, when we identified that developers were using the application login as their  dev login to do work. I got the management buy in that this should...

As John Mitchell noted in the other thread,,all you can do is reasonably infer the person, based on the IP address or hostname(whihc technically can be spoofed in the connection...

the first table should be sysjobs, as some jobs may exist but have NEVER been executed,and thus have no history.
also, the joins should be LEFT JOINs, since jobs could...

Robert, are you talking about each Server in an Always On Availability Group, or a Windows Server Failover Cluster with shared storage and a cluster aware SQL instance?

You...

I've seen issues like this in the GUI scripting; when you use an older version of SQL Server Management Studio(lets say 2008 or 2012) and are connecting to a higher...

you could do it as a string representation like this:

/*--results
ElapsedString    Days    Hours    Minutes    Seconds    Milliseconds
3:03:30:11    3    3    30    11    446
*/
WITH MySampleData
AS
(
SELECT
   [Days]    = datediff(day,0,ET-ST),
   ...

ok since you are inserting into a table, you do not need the ORDER BY in the end.

You could fiddle with changing it to use EXISTS instead of...

i would think about slicing the new SAN into three drives; two big ones for the SQL stuff for db and logs, and a new,smaller one for the disk-based packages.

I've done this with a script task in an SSIS package. it is a good size snippet of code, with lots of caveats.... the end result is exactly what everyone...

Yes, you'll end up needing  bunch of case statements, one for each column.
This could also be done int he presentation layer, so for example SSRS could use an expression...