SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• DEADLOCK problem in our production DB

  Hi Folks, I am facing below issue in our production DB and would like to understand the reason behi…

  Suresh Arumugam

  7 replies

  13 years, 10 months ago

  By: viiki.seth

• Using DISTINCT within a JOIN

  Hi, Does someone know how can distinct be used within a join to restrict duplicates ? The requireme…

  pwalter83

  3 replies

  13 years, 10 months ago

  By: Jeff Moden

• DISTINCT problem

  I have data that I am importing from a text file into SQL that has some records that I am unsure ho…

  krushkoder

  5 replies

  13 years, 10 months ago

  By: krushkoder

• Importing txt File into SQL Server

  I want to import the a txt file into SQL Server . I Am using BCP in to import. Importing works fine…

  rakkpra

  5 replies

  13 years, 10 months ago

  By: rakkpra

• Is there a way to find out the current daylight savings state

  Without any pre-populated tables, or external parameters passed is it possible to find out if the s…

  buddy__a

  3 replies

  13 years, 10 months ago

  By: Lowell

• verifying after production data migration

  Dear Experts, We are migrating the Production database from one SQL server 2005 to shared SQL serve…

  Gangadhara MS

  3 replies

  13 years, 10 months ago

  By: TheSQLGuru

• Complex update query

  IDGroup A|Group B| Group C 1:True| False | True 2:False | False …

  sc-w

  9 replies

  13 years, 10 months ago

  By: John Mitchell-245523

• Dynamic to Static Port

  I want to assign static ports to my sql server instances ( 3 in a cluster ) . I got a nice link htt…

  aby_dvd

  2 replies

  13 years, 10 months ago

  By: Taggs

• Version of SQL 2005

  Hi fellow SQL affiliates, I would like to update our server to SQL 2005 SP 2 on out Database hotel.…

  leemunyasia

  6 replies

  13 years, 10 months ago

  By: Meet George Jetson

• Making a SUM of COUNT

  Hi, I have a requirement to do a SUM of the COUNT within a CASE statement: SUM(CASE WHEN e.EQUIPMEN…

  pwalter83

  8 replies

  13 years, 10 months ago

  By: JonFox

• Oldest Unsent Transaction/alert for time behind

  I keep receiving the following email: The alert for 'time behind' has been raised. The current val…

  SQLdba-473999

  3 replies

  13 years, 10 months ago

  By: Billy the Cook

• Clustered and Non-Clustered Indexing in SqlServer2005

  Hi, I want to know the details about Clustered and Non-Clustered Index in SqlServer2005.How to cre…

  poornima.s_pdi

  7 replies

  13 years, 10 months ago

  By: Gail Shaw

• Collation Sequence difference between table variables and temp tables

  I have a query developed on one server, which runs fine. However when I try to run it on another SQ…

  Tom257

  3 replies

  13 years, 10 months ago

  By: Ken McKelvey

• unexplained Performance difference in queries between UAT/Live database

  HI All, I have a most vexing problem that I haven't been able to get to the bottom of yet. I have a…

  Claudie36

  2 replies

  13 years, 10 months ago

  By: Eric M Russell

• Database mail issue

  DBMail service on one of our SQL boxes keeps stopping for no apparent reason. I have checked the lo…

  Frank Lain

  2 replies

  13 years, 10 months ago

  By: Frank Lain