Following the footsteps of Mr. Jeff Moden, I believe this would be good enough

DECLARE @StartDate DATETIME, @EndDate DATETIME, @MonthDiff INT

SELECT @StartDate = '1901-08-10', @EndDate = '4850-10-31'

...

Do not know what is the status of your problem but you cannot do such comparison. Besides you are not using the right attribute to search for. "score match_option" is...

Why don't you explicitly DENY the permissions on [dbo] schema for that AD Group.

Besides, If there is a column in both tables which have same values but all other columns could have different values then this is the solution which may outperform the...

I believe Joseph Hampton's solution(with a minor modification i.e. UNION ALL instead of UNION) is a much easier solution for SQL 2005+.

(SELECT * FROM A

EXCEPT

SELECT * FROM B)

UNION ALL

(SELECT *...

Thanks a lot Gail. It is always nice to see your detailed response with much ease to understand.

It is getting interested as I expected. Since read uncommitted isolation level could...

Glad to hear that. 🙂

There seems to be problem with the permissions rather than the query itself. You can easily identify it by fetching the server principals through connecting to the servers with a...

Ninja's_RGR'us (11/1/2011)

---

sqlzealot-81 (10/31/2011)

---

Updating stats should be done at less trafic time to avoid blocking. Instead of doing update stats i would recommande to find out the fragmentation level and do...

You are indeed outside your confort oops.. comfort zone. 🙂 just kidding, please do...

I disagree to disagree your agreeing to second point of view and agree to disagree your point of view as disagreeing :hehe: Must be time for me to get a...

Ninja's_RGR'us (11/1/2011)

---

Usman Butt (11/1/2011)

---

As far as blocking is concerned, it depends upon Auto Update Statistics option. If it is set to ON on the database, then we have further two...

Can you please let us know which Windows Server and SQL Server are you using? Moreover, is your server on a VM?

I would rather disagree slightly with sqlzealot-81. Index rebuild/reorganize should be part of the maintenance plan, but so should be updating the statistics. Index rebuild/reorganize is required to make the...

Your question is a bit weird. If I can understand correctly, then you need only some specific tables data to be in original state. Right? If this is the case...