Thanks Gail.

Trying this now.

Sure I did and the grouping is fine.

But after putting in the piece of junk dashboard software - I now think what I really have to have is dynamic...

I apologize Lowell.

I am not explaining this very well.

This query is going to be used for as part of a dashboard. Unfortunatley the dashboard software is kinda dumb and doesn't...

Okay my bad. I apologize. I didn't do a very good job of explaining what I am having trouble with.

I'm trying to get -

Number of APPROVED claims by username

Number...

OKay I checked every single group and he is not getting in via group membership.

I also know that he is using his domain account (domain\user).

When I run - xp

account...

Thanks Steve.

I hope MS considers this a need. I'm sure there are plenty of other folks out there that can't use the cloud for various reasons.

did you try changing the compatibility level to check for cardinality issues?

We have had many and some times the quick way to tell for sure is to switch it, then...

Thanks everyone for the input.

Okay, Fair enough. Thanks for the input. Didn't know there were some differences in the local version.

I think I can easily justify the use in our environment. I think...

Understood.

In our case, we have to keep records forever. So, the tables get large but the older data is rarely used. But we still need access to the older records...

If you are using SSMS you can...

VMotion is the mechanism VMware uses to migrate a running VM from one host to another.

An Availability group provides redundant copies of a set of databases which can also...

Was going to build new sql 2014 active/passive cluster with AG and a read only node all on a new vmware environment. System admin want to use vmotion instead of...

Thanks everyone - very intersting input.

I ended up using:

CREATE TRIGGER NoDeleteMedicalGroup ON dbo.Medical_Group

INSTEAD OF DELETE

AS

BEGIN

ROLLBACK;

END;

No items in the Medical group table should ever be deleted. So, this worked...

Can you give me an example of empty code block?

I tried using this trigger, it stopped the deletes on the parent table but deleted the records in the child tables.

CREATE...