Server Configuration

Performance and sys.dm_db_index_physical_stats
We have a procedure that collects fragmentation data before re- indexing a production database. On two separate occasions, when executing 'sys.dm_db_index_physical_stats', users have reported timeout issues. The mode is 'LIMITED' Thanks in advance. ... 16 Dec 2009 04:44

Taking database offline
Hello, I want to take the database offline to do a restore. It is taking forver.... Its sql 2005 enterprise sp2. I tried rebooting the server. Server is windows 2003 enterprise. tnt ... 15 Dec 2009 08:58

Linked Servers & index access
I'm looking at the linked server configuration and am stuck on a why question. When configuring, if you want a remote user to be able to use the indexes on the server being configured, you must explicitly state so. The default is that remote users will not be able to use the indexes. Why on earth would you ... 16 Dec 2009 10:09

SQL-2K and TCPIP 6
I am running XP with SP4 and SQL 2K SP4. I have TCPIP6 deselected in network protocols and I get this ERROR when starting SLQ 2K <<< Error from Event Log SuperSocket info: FillAddress(MSAFD Tcpip [TCP/IPv6]) : Error 0. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.... 14 Dec 2009 15:29

move to new windows server and upgrade sql server 2000 to 2008
Hi I need to move/upgrade one of our sql server (sql server 2000 SP4 on windows server 2003) to a new sql server 2008 on a new windows server 2003 R2 box. What is the best way to upgrade move the databases /logins etc. If I just backup and restore the database logins/passwords will not be transfered. ... 16 Dec 2009 04:44

Can't authenticate in SQL Mgmt Studio
SQL 2005. No problem logging directly into the server with sa credentials. However, can't authenticate using same credentials in SQL Mgmt Studio - receive error message 10061 - TCP provider - No connection could be made because the target machine actively refused it. I get the same error when trying to set an ... 14 Dec 2009 09:54

Nolock Hint
Does the performance gain stems from the that sql server doesn't need to dirty or in middle of transaction rows? If yes, is that the only reason? Thanks in advance ... 14 Dec 2009 00:11

cannot obtain provider factory for data provider named 'microsoft.sqlserverce.client3.5'
Hello everybody, I work with VS 2008 on the Windows 7. MS SQL Server 2008 Express is installed on the machine as well as SQL Server CE 3.5 SP1. In the machine.config there is an entry: <add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data ... 12 Dec 2009 17:51

Windows 7 Enterprise x64 + SQL 2008 Enterprise x64 + Oracle Client/Drivers
I am trying to use SSIS to connect to a couple of 10g databases but no luck on Oracle 10g connections. I can't seem to find the right Oracle client or drivers to get things going. Has anyone run into this before? Any advice would be greatly appreciated! -- Message posted via SQLMonster.com http://www.sqlm... 12 Dec 2009 02:45

Table partition for each week
am looking to partition my table for 52 weeks (Per week) , could you please help the best way to achieve that in SQL 2005/2008? Thanks!! ... 13 Dec 2009 07:46