Agreed. But the issue is that the vendor is called because of performance issues and they claim the need to rebuild indexes. I argue against and then we...

I understand that I could connect to each instance, but its not highly available then. So I want to use the availability group name to connect. The issue...

Thanks for the info.

Grant...

I think your point is valid and I may have looked past that. If running it via SSMS and the ADO connection can yield different execution plan results then...

I can look at doing that check, but how would that differ from what I have already done? In essence since I ran the application with profiler to catch...

Late post here.. but interesting fact to consider is that you can also take the VM and make it see the 4 vCPUs as one cpu with 4 cores via...

Thanks. I will look at deploying it as soon as possible.

Why do you think this is the solution? I don't see anything in the release not indicating my issue. Did I miss something?

Already applied. I could try to re-apply. But I also have this issue with SQL Server Management Studio.

Thats where I have been moving towards. Creation of accounts that are "Finace_Jobs", "Engineering_Jobs", etc. But I started considering the idea of trying to utilize the proxy accounts...

Look up doing subselects. You need to select out to get it all on "one row". Otherwise you will want to do the logic in the UI.

But it...

I did an install of the insta client. Will reboot tonight to test. But I dont have a network/admin folder for the tnsnames.ora file. Any idea where...

I have the 10G x64 Client install. I did a custom install and specified the drivers and windows interfaces and did a reboot. So maybe the issue is...

Awesome... this is what I was looking for. Something that was little cleaner than converts and concatenation of dateparts. Seems like it should work well. Thanks.

I knew there was a sys schema. But there is an associated user sys as well that has no login? I never really noticed, but I ran a...