Following are the standard changes we would normally consider;

1. Database backup - In case if we need to do outside of the regular schedule.

2. Online Index Rebuild - To...

Following are the standard changes we would normally consider;

1. Database backup - In case if we need to do outside of the regular schedule.

2. Online Index Rebuild - To...

select a.* from A

where not exists (select 1 from B where A.ID=B.ID)

Here is another method;

Create a stored proc in each DB to delete the empty tables and then exec that SP by using sp_MsForEachDB.

Another suggestion is, backup the database and delete the duplicate rows so that it will remain single record instead of multiple dup records. You can easily remove dup rec if...

Reasons for slowness will be a badly written query. Use the profiler to see the reads, writes, cpu and duration figures.

Then get the actual execution plan and check where...

Good article to start learn about new features of SQL Server 2008.

I have seen most folks have raised their concerns for syntax errors and the output of Q4 and Q5.

Here are the clarifications for those.

There was a syntax error in table...

The output of Q4 and Q5 are correct.

The only mistake is column headers should be interchanged in the result set shown in the article.

(InnerJoinTest2_PK, InnerJoinTest1_PK)

Use the order by statement as...

stupid puzzle for the day.

stupid question.

The article link could not be found.

http://msdn.microsoft.com/en-us/magazine/cc164174.asp

Please provide the correct link.

Oops. I missed the point.

Use the above method. I was thinking about server roles. sorry for the confusion.

sp_addsrvrolemember - Adds a login as a member of a fixed server role.

sp_addrolemember - Adds a database user, database role, Windows login, or Windows group to a database role in...

What kind of a database this is? I mean how often transactions are happening on what size in this database. This may be due to heaving data load going to...