Since the server with same name is in different domain you should not see any issue. My manager had asked me to upgrade one 2005 production server to SQL...

-- we have about 3000 users potentially hitting this sql server, and about 4000 active connections.

Is this statement right? Is there no connection pooling?

From various projects what ever I had learned, the most important thing is the say " NO " very diplomatically. First I use to say " NO " very...

Just curious ! ! !

Why Anirban always had same response to all articles ?

Don't know about 2008 but once tried to move mssqlsystemresource database in SQL server 2005 and all hell broke for me. Have to install and configure complete server again.

With last...

I don't think its possible. Always detache a database that is currently not in use.

I think answer should be option 1 and 3.

-- Impersonating allows a member of the sysadmin fixed server role or db_owner fixed database role to impersonate another user

http://blogs.msdn.com/sqlclr/archive/2006/06/16/635003.aspx

There is no hard rule from MS to specify this number. Basic number for analysis is taken as 300 and afterwards it just depending on you application and server...

check this: point 3 in http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/oltp-performance-issues.mspx

or go through this thread in sqlservercentral.

http://www.sqlservercentral.com/Forums/Topic302812-65-1.aspx#bm303097

USE Databasename

GO

DBCC SHRINKFILE (Databasename_data, 1)

GO

I put " 1 " as target in most of the time since it will take the nearest value to shrink that file.

We had this issue sometime back and changing the max degree of parallelism to 1 had increased performance a lot. Mine was a 8 processor and 4 dual core...

I assumed 32 is the max limit but its 50.

http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx

50 instances on a stand-alone server for all SQL Server 2005 editions except for Workgroup Edition. Workgroup Edition supports a maximum...

NO. ...

I wasn't sure about " Remote " option. But since from last two days all options are correct, I selected Remote option.

Can some one post a sample query or...

I am Steve.