Be very careful about just changing the LEFT JOINS to INNER JOINS or visa versa, they were coded that way for a reason, which may not be obvious without understanding...

You can use "<>" which is another notation for not equal, which is what Joe is suggestion everyone should...

No offence joe, my reason for asking was due to slivers of memories about there being a possible performance hit with the update table being in the Join rather than...

You will also need to back up the encryption keys for DR purposes

http://technet.microsoft.com/en-us/library/ms157275.aspx

I'm sure there was more than one. 😉

I do take your point though about number of records being a factor. I'm pretty much a horses for courses...

Thanks Dwain, I've read that article (+1 BTW), I did say I wasnt sure about the performance on a large dataset, and it was just another Option to consider.

Looking at...

Heres a version using the unpivot function (and Dwains temp table) with a self join on Value where the date isnt the same

CREATE TABLE #Test(

[Date] [datetime] Not NUll,

[c1] [int] NOT...

Bhuvnesh (11/21/2012)

you can test it with actual execution plan . that will give you exact picture what/where/why any...

It sounds like you have an appication that allows users to enter a policy, so why not validate the number that the user entered in the application to make sure...

Have you thought about encrypting the sensitive Data itself as an added layer of security this coupled with the above suggestions should make it pretty secure.

In the end...

Thanks Eugene, it just looks odd to my eyes.

John,

Generally the Best bowling figures use the number of wickets first, then runs conceded, eg 5-7 is considered worse than 6-100, but 6-50 would be better than both of...

Can you post the DDL (ideally temp tables/table vars) for the tables and some anonomised sample data that will give the results as this will enable us to help you.

Being...

Almost completely agree with the previous poster, Partitioning the database into seperate file groups is really only done on Very Large DB's, as it can offer some performance gains.

I'm...

I'm guessing SSMS tools is installed as this is standard behaviour for this 3rd party tool,

Do you have a menu item called SSMS Tools in SSMS? If you do...