SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Low Memory usage / Large Transaction Log

  Hi, I am using SQL 2005 Enterprise on a Windows 2003 x86 OS. The server has 4GB RAM. The database i…

  shutts318ci

  19 replies

  14 years, 10 months ago

  By: Gail Shaw

• aggregate problem

  Hi, I have a query like this select distinct t.value,t.value1,t.value3,sum(t.value4) convert(varch…

  kris6363

  2 replies

  14 years, 10 months ago

  By: steven.malone

• Merge Split Files

  I am trying to move a database to a new server. The previous DBa for some reason split the database…

  shutts318ci

  2 replies

  14 years, 10 months ago

  By: JeremyE

• How to compare two Database's

  Hello All. I need a help scripting this. I don't want to use Red gate or any other tool. Say I have…

  coolakhil4u6

  1 replies

  14 years, 10 months ago

  By: Adiga

• Best practices for deployment of OLTP databases (Clustering vs Mirroring)

  Hello, We are working on a development of building a middleware/staging application which will be u…

  vishal.shinde

  1 replies

  14 years, 10 months ago

  By: David.Poole

• Get the data when there is no Primary key in table

  Hi, I have two tables with same kind of structure [datatype]. Both the tables has 20 columns each.…

  sqlusers

  2 replies

  14 years, 10 months ago

  By: sqlusers

• Getting error when trying to convert result to numeric

  Hi All, I am getting erro in stored procedure I am trying convert result into Numeric(10,2) to rou…

  naresh0407 93367

  2 replies

  14 years, 10 months ago

  By: naresh0407 93367

• Help-Page life expectancy very low (avg around 10to 12secs)

  we are using a SQL server 2005 SP3. i have been monitoring the pagelife expectancy and buffer cache…

  snoop123

  6 replies

  14 years, 10 months ago

  By: Evil Kraig F

• Behavior of an UPDATE Statement Using a Reference Table

  Hi: Consider the following UPDATE statement, where the values of the updated table columns depend o…

  bad_shogun

  1 replies

  14 years, 10 months ago

  By: Evil Kraig F

• SQL Server 2005 Aliases

  Hi, I'd like to create do multi-instances SQL Server 2005 install on one physical server that is go…

  leonid.yakhkind

  2 replies

  14 years, 10 months ago

  By: Geoff A

• Maint Plan runs successfully but Job History shows failed

  I'm using SQL Server 2005 with SQL Server 2005 Service Pack 3. I developed a Maint Plan which runs …

  JohnWSmith

  1 replies

  14 years, 10 months ago

  By: JohnWSmith

• Network Interface Cards being added ???

  What are the considerations to be taken by different teams and specifically by DBA team also when a…

  aby_dvd

  2 replies

  14 years, 10 months ago

  By: aby_dvd

• Lost Carriage Return Error Described

  I've been near to send a post to the world on this issue I've been fighting with for a couple of we…

  dbuendiab

  1 replies

  14 years, 10 months ago

  By: dbuendiab

• Transfer data from ms sql 2005 to acess 2003

  Hi all I am not familiar with access so I have just started to read up on this. But since time is a…

  @DJ

  3 replies

  14 years, 10 months ago

  By: SteveBell

• how design query

  hi all below i am showing my bus route table now how i can find out which route will come if i use…

  buntymanoj

  4 replies

  14 years, 10 months ago

  By: buntymanoj