SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Input Parameter Validation..

  Hi All, I have a SP which has input parameter field where the data type is float. I want to perform…

  thundersplash845

  8 replies

  13 years, 12 months ago

  By: Sean Lange

• Identifying a process that is blocking our APP

  We have a customer who is experiencing hanging in our APP. We have found that it is a process that …

  gringodavid2002

  4 replies

  13 years, 12 months ago

  By: gringodavid2002

• total_pages in Sys.allocation_untis returning negative values ?

  I want to get the allocated space for a database. In goggling i find the below link http://msdn.mic…

  kumarreddy72

  3 replies

  13 years, 12 months ago

  By: Gail Shaw

• Surrogate Key Vs Foreign Key

  Hi, I have a child table(C) which has the composite primary key(A1+B1) from Table A and B. Now i wa…

  santhosh_ms3

  1 replies

  13 years, 12 months ago

  By: Grant Fritchey

• case statement

  Hi, I used case statement shown below, but it gives me wrong values(see result)..do i need to cast …

  sql4us

  10 replies

  13 years, 12 months ago

  By: sql4us

• SQL server 2005 Insert into table select * from table

  my procedure runs successfully except for first insert query does not insert rows into the table bu…

  vikramp 2790

  2 replies

  13 years, 12 months ago

  By: vikramp 2790

• Rebuild index -Timeout error

  I received the below error while rebuilding indexes on the large table . Do you have any info about…

  mirjawad_2k

  5 replies

  13 years, 12 months ago

  By: mirjawad_2k

• Reading nVarChar date in reverse and store in DateTime column

  A table has dates stored as nVarChar in the format: dd/mm/yyyy. I have added a new DateTime column …

  @RDBMS

  2 replies

  13 years, 12 months ago

  By: Andre Guerreiro

• How to Maintain History of data in tables.

  Hi All, I am part of development of an erp application.I need to capture the history of data which …

  hemanth T

  3 replies

  13 years, 12 months ago

  By: Steve Jones - SSC Editor

• Someone Deleted a Table

  Oooops! A friend of mine deleted a table used to import order data from hand held devices into the…

  tfifield

  16 replies

  13 years, 12 months ago

  By: tfifield

• get due amount of of all invoices of given supplier

  hi i have 2 table... first... tbl_Purchase Purchase_idbigint Location_Idbigint PU_Refnvarchar(5…

  dilip.aim11

  7 replies

  14 years ago

  By: dilip.aim11

• 2 distinct instances of SQL Server 2005 - One jerks the other

  Hey all, We have a server with 2 instances of SQL-Server 2005 enterprise - Instance Production - In…

  steve-lauzon

  8 replies

  14 years ago

  By: steve-lauzon

• Disappointed with List as table Function

  I was surprised at the performance issues when it comes to the following UDF I have in place ALTER…

  JKSQL

  3 replies

  14 years ago

  By: Lynn Pettis

• Anyone use Polyserve?

  My company is considering buying Polyserve to do some consolidation/HA. HP did the product demo a…

  Anders Pedersen

  2 replies

  14 years ago

  By: San-Man

• How to get a list of scheduled jobs (time and date it runs) across multiple servers?

  Hi there, i've been given a huge list of servers to check if any of them have DBs with jobs that oc…

  MissPukeyCow

  2 replies

  14 years ago

  By: MissPukeyCow