SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Adding a failed node back to cluster

  Hi, This is on SQL Server 2005 / Windows 2003 environment. Node 1 of a 2-node cluster crashed, db i…

  inund8ed

  1 replies

  11 years, 1 month ago

  By: inund8ed

• comparision data between two servers

  hi, I have two servers one is prod and test(replication of prod), I need to compare all the tables …

  satish.chamakura

  1 replies

  11 years, 1 month ago

  By: Jack Corbett

• msdb marked suspect error 3313

  Can someone offer advice on how to bring up msdb ,marked suspect? the server was rebooted and this …

  steven.gambale

  3 replies

  11 years, 2 months ago

  By: Rudyx - the Doctor

• Return row values where exists in table, "not scanned" where missed scan

  Hi SSC, I have two tables - Production and Inspection. I want to return all production records beca…

  kabaari

  13 replies

  11 years, 2 months ago

  By: kabaari

• Pivot help? ...or other approach?

  This is the type of data that I'm working with: USE TestDB GO CREATE TABLE testtable ( ID INT IDE…

  inevercheckthis2002

  6 replies

  11 years, 2 months ago

  By: Ed Wagner

• Index Types and Primary Keys versus Space Used

  I recently received a script from a developer where there were comments through the object creation…

  DB_Newbie2007

  5 replies

  11 years, 2 months ago

  By: prabhu.st

• Configuring a Linked Server to Sybase

  Pardon my ignorance but I've been at this for over a week and finally had to ask for some help. I'm…

  petey20

  3 replies

  11 years, 2 months ago

  By: mysorian

• Does snapshot in two database has any know issue in following situation.

  Hi, I have two database D1 and D2, i am using snapshot isolation (ALTER DATABASE MyDatabase SET …

  rajemessage 14195

  1 replies

  11 years, 2 months ago

  By: rajemessage 14195

• For varchar(max) should i use normarl update or .write in following situation

  Hi, I want to update a col , which is null initially. and i have to run UPDATE STMT at many places…

  rajemessage 14195

  3 replies

  11 years, 2 months ago

  By: Umer Akram

• Common Script for Insert

  Dear All, How to write a script for "Common Script for Insert Statement" in SQL Server 2005?

  naraayanan1983

  3 replies

  11 years, 2 months ago

  By: Umer Akram

• Can balance tree go un balance in following condition. ( b-tree of primarykey)

  Hi, Please tel me how b-tree of clustered index will look like if i have 1,2,3,4 then there is gap …

  rajemessage 14195

  1 replies

  11 years, 2 months ago

  By: Gail Shaw

• SP4 installation on active/passive cluster

  I am going to be installing SP4 on SQL Server 2005 installed on a Windows 2003 R2 Active/Passive cl…

  inevercheckthis2002

  5 replies

  11 years, 2 months ago

  By: Hakan Forsberg

• does choosing indexed table col for where clause helps and does order of table matters?

  hi, In following querys, i tried to check the plan i noticed both where same as far as the ind…

  rajemessage 14195

  19 replies

  11 years, 2 months ago

  By: below86

• Concurrency read by .net report application

  Hi all folks! In my production environment, I have this working stored procedure: SET ANSI_NULLS O…

  Birby1974

  4 replies

  11 years, 2 months ago

  By: Birby1974

• The query processor could not produce a query plan because a worktable is required, and its minimum row size exceeds the maximum allowable of 8060 bytes. A typical reason why a worktable is required is a GROUP BY or ORDER BY clause in the query. If the query has a GROUP BY or ORDER BY clause, consid

  The query processor could not produce a query plan because a worktable is required, and its minimum…

  ksrichakra123

  5 replies

  11 years, 2 months ago

  By: oky