.rar file attached.

Thanks for helping

Shamshad Ali.

I think there might be a way for the single query to be converted but no idea how to do this. Time is constraint, i will look into it and...

Well, here the programs are not bound, I mean the total No of program even not viewed should be counted. so there is difference in results of both queries.

Left Join...

Thank you all for helping me solving my problem. My personal experience says there is no need for FKeys to have non-cluster index. From the performance point of view there...

There are 210 tables, 24 views, 280 SPs, 50 functions with DB size of 8 GB. I am looking for a quick way to figureout the indexes issues. Each table...

There is still no any respone on my question;

From the link : http://www.mssqlcity.com/Tips/tipFTS.htm

it says "Consider using a full population when a large percentage of records were changed or added at...

After applying the alter index, out of 10 there are 8 alter statements are same - actually i ran this script twice to check there is no anything missed -...

The list or limit is not short. Tickets as you mentioned I understand but the DBA has to check things itself first, review his check list, if something is...

On sample data both seems running as same. That's why i have included sql plan here. Please review and suggest which one should be used and normal practice.

Thanks for your...

We have CDN, setup on CISCO devices more than 130 locations and we are planning to upgrade the solution for...

Your given step by step solution is already i knew and this is what i don't want to repeat like delete subscription etc. what if the setup is already done?...

People on this forum provide help for free. We don't do consultancy or design. That's what a consultant if for. You pay for their expertise, and they provide you information....

If the...

First of all, Thanks you very much for you time you looked my question and replied.

First, if this is going to support 100,000 people and it's worth a lot to...

It was so easy i can't imagine. From your subscriber server go on replication --> select local subscriptions and when you hover your mouse it will give you details about...