Search Results | SQL Server Performance Forums

Restoring master

Thread by: khchaitanyaprabhu, Jun 15, 2007, 3 replies, in forum: Getting Started

Hi.. I am trying to restore master of sql 7 on sql 2k. It throws error as master of earlier version cannot be restored. Can anyone guide me....

Impact of change of structure on table size

Thread by: khchaitanyaprabhu, May 29, 2007, 3 replies, in forum: Getting Started

Hi.. I have created 2 tables Emp_Int _Table Emp_Id int not null, Amount int Clustered index on Emp_Id Emp_Varchar_Table Emp_Id int not null, Amount...

Index - Fill Factor

Thread by: khchaitanyaprabhu, May 7, 2007, 3 replies, in forum: General DBA Questions

Hi.. As all of us know that while creating Index for a Table there is Option for specifying Fill factor. This option specifies how full SQL should...

SQL Server not starting

Thread by: khchaitanyaprabhu, Apr 27, 2007, 7 replies, in forum: Getting Started

Hi..<br />When I tried to start SQL Server from service Manager, in the bottom of the window it displays message as "Starting..." but after couple of...

Work load Governor

Thread by: khchaitanyaprabhu, Apr 19, 2007, 1 replies, in forum: Getting Started

Hi.. I would like to know what is SQL Server 2000 Workload governor and it's functions ? Thanks

Kinds of Reads.......

Thread by: khchaitanyaprabhu, Apr 15, 2007, 2 replies, in forum: Getting Started

Hi all.. Recently I came across following terms , I will be grateful if someone explains the same. "Unrepeatable Reads" "Dirty Reads" "Phantom Rows"...

Log Shipping in SQL 2000 -Connection Error

Thread by: khchaitanyaprabhu, Mar 31, 2007, 3 replies, in forum: SQL Server Log Shipping

Kindly share details of prerequisites for setting Log shipping in SQL 2000. I am facing problem when connecting to Destination server as "Connection...