Server Configuration

Rebuild Index on SQL 2005
After rebuilding indexes, my db grew from 40gig to over 100gig. Almost all of it is used. Any help is apreciated. Thanks in advance ... 16 Feb 2010 18:24

Different MS SQL versions on a server.
If there's different MS SQL versions on a server will they conflict with each other? Please advise and thanks. ... 16 Feb 2010 12:57

How to get a database out of recovery mode
Hi, I have detached a database, moved the files to another drive and attached the DB again. It appeared in read-only mode, so I tried to change the mode to read-write... but unfortunately it failed When I look in the error log there is a stack dump where some of the info are Location: "logmgr.cpp":5527 Exp... 16 Feb 2010 12:57

Sql Server 2005. Best configuration and parameters.
Hi, We have a website (.NET 2.0 on IIS 6.0) and a Sql Server 2005 (9.0.4035) running on the same machine, a Windows Server 2003 R2 Service Pack 2 with 8 GB RAM (Xeon E5405 2 Ghz). The website works with stored procedures. And max 20 users at the same time. We are wondering the best following parameters for ... 13 Feb 2010 09:19

Link Server error
I've link server set up and running the store procedure , the link server user is sysadmin. The sproc was running fine till 3 weeks suddenl its failing giving below error. Any help is appreciated (Message 0) OLE DB provider "SQLNCLI" for linked server "ServerA" returned message "No transaction is active.". [SQLS... 12 Feb 2010 19:08

Fragmentation
I have noticed there utilities to defragment index. I couldn't find anything like it for base table. If it doesn't exist, why? There is no such a thing as full table scan in sql server? Thanks in advance ... 12 Feb 2010 12:21

Varchar to datetime conversion
Hi, why SELECT CAST('2009-02-12 00:00:00:000' AS DATETIME) returns '2009-12-02 00:00:00.000'. This drive me crazy: can you help me? Thanks in advance. Massimo ... 12 Feb 2010 11:11

RPC vs. RPC Out for Linked Servers
When configuring a Linked Server the Server Options tab has check boxes for RPC and RPC OUT. Can someone explain why you would or wouldn't need to enable either of these options? Thanks! ... 11 Feb 2010 18:30

Need field uniqueness but don't want index
I have three fields in a table that I need to make sure they are unique. I could create an unqiue contraint (index) for it but one of the three fields in there is to maintain the uniqueness and doesn't involve in any key join or search argurment and this field is often updated as well. Is there a way that I can ... 11 Feb 2010 21:53

Page Splits
I am attempting to analyze the number of page splits occurring on a server. DECLARE @PageSplits bigint DECLARE @CntrValue bigint select @PageSplits = sum(leaf_allocation_count) from sys.dm_db_index_operational_stats (NULL,NULL,NULL,NULL) select @PageSplits = sum(leaf_allocation_count) - @PageSplits from... 11 Feb 2010 10:34