your Table structure has all the columns in brackets, so that the name with spaces doesn't break the CREATE TABLE command..
your Foreign keys simply need to have the same logic.

Doing a best guess at Foreign keys depends on the design and proper naming conventions.
for example, do all the tables have primary keys? are they properly named? (ie TableNameID...

The SQL Error Log has what you are looking for
Every time an instance is restarted, the previous log is closed and marked as archived, and the new one is...

Hashbytes is a varbinary(8000) return value, so you need a larger column, and then you are all set.
you do NOT need to filter or edit your columns for dashes...

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),
   ...