Thank you all for taking time to provide feedback. I haven't been able to go thru these yet because I'm out sick but I did want to take a minute...

Thank you to everyone who took time to respond. My point of the post was to verify that every plain/vanilla Begin (a BEGIN that is not followed by something like...

UPDATE:

I was able to successfully connect today from with VS2015. I selected (from the Menu) Tools>>Add SQL Server and it let me add and connect to this SQL Server I...

The MS Doc I'm using for these SQL commands is https://docs.microsoft.com/en-us/sql/t-sql/statements/create-login-transact-sql?view=azuresqldb-mi-current 

I really appreciate your replying but there is a disconnect somewhere and I'm sure its because of my...

Jeff - We're still in the mock-up stages of this so I don't have any actual DDL to share but I did make a mock-up in Excel of what the...

Steve -  The problem is if I try to use that in the same query as traditional aggregate like Min and MAX it throws a fit because PrimaryKey is not...

• This reply was modified 3 years, 12 months ago by  YSLGuru.

15 replies already And here I was initially concerned this might be a dumb question to even ask

I think its what Brian Gale is speculating, personal preference/style. We use an accounting software package that is for a very vertical market and to my knowledge their philosophy is...

Nope. The source code I was reviewing was exactly as I showed I just replaced the literal names with dummy variables. It had no BEGIN~END and for the life of...

• This reply was modified 4 years, 1 month ago by  YSLGuru.

FYI...

Per recommendation I created 3 temp tables  by breaking up the 3 queries and adding an INSERT command to create temp tables. I then compared the 3 temp tables using...

Not that it matters for this but just to be clear this is not something I made and if we figure out whats wrong with it I can't make any...

So could not upload the XML plan as a txt file so I'll see if it will let me do it if its archived (winrar)

UPDATE

So the site will not let...

• This reply was modified 4 years, 1 month ago by  YSLGuru.
• This reply was modified 4 years, 1 month ago by  YSLGuru.

We're having some performance issues today and so I don't want to run the Get Actual Plan piece of Plan Explorer until those are resolved. Attached are the XML plan...

Yesterday I let PE (Plan Explorer) do its thing with get the actual plan. I knew it would take some time which was fine. I was working remotely and got...

Thanks Jeff & Scott for taking the time to reply. It may sound like a dumb question but I asked anyway because the hardware/network folks keeping trying to say that...