SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• One occurrence of a word only - Delete repeated rows

  hi guys any advice how to do this please? i want to delete the rows that are repeated (not by havin…

  monzulu

  2 replies

  15 years, 2 months ago

  By: sharath.chalamgari

• Help with trigger please :-)

  Hi all, I have two tables, one called Cartwalls and another called CartwallTitles. CartwallTitles h…

  ady.foot7970

  9 replies

  15 years, 2 months ago

  By: Ken McKelvey

• grow a table's reserved space?

  i want to pre-grow a table's reserved space so that an insert will be faster (the db has room alrea…

  Todd Stu

  4 replies

  15 years, 2 months ago

  By: Michael Valentine Jones

• case statement accounting for null values

  i have a case statment in the stored procedure when the field is null i would like it to show 0 thi…

  sharonmtowler

  5 replies

  15 years, 2 months ago

  By: Evil Kraig F

• Combining two tables into one view and joining columns

  I have two similar tables: Purchases (idnum, trndate, amount) and Payments (idnum, trndate, amount)…

  sdoxey

  4 replies

  15 years, 2 months ago

  By: John Rowan

• Select Record Where the Criteria Falls Between Values in Two Columns and is AlphaNumeric

  I need to figure out how to select a record where the criteria falls between values contained withi…

  david.holley

  7 replies

  15 years, 2 months ago

  By: david.holley

• Replace semi-colon with new line

  Hello again experts, I am trying to replace semi-colon (;) for some values for a field name. For in…

  simflex-897410

  7 replies

  15 years, 2 months ago

  By: Evil Kraig F

• datetime conversion error

  Hello all I have data in the format '6/9/2006 and need to load it as datetme can any one please he…

  Eshika

  1 replies

  15 years, 2 months ago

  By: ColdCoffee

• how to failback using database mirroring

  We have database mirror configured between source and destination SQL 2008 servers with no safety a…

  praveen_vejandla

  4 replies

  15 years, 2 months ago

  By: Reo

• Getting Rid of a Cursor To Iterate Through Tablenames in sys.objects

  Hey guys As one part of a stored procedure that I need to create, I need to DELETE rows that match …

  AndrewJacksonZA

  2 replies

  15 years, 2 months ago

  By: AndrewJacksonZA

• Which table is used last

  Hi In a Database i am having nearly 200 plus tables i need to find the tables which are used last…

  parthi-1705

  21 replies

  15 years, 2 months ago

  By: Johan Bijnens

• got a parameter sniffing example/demo script?

  there's thousands of references to parameter sniffing on this site, and they all refer to how to fi…

  Lowell

  5 replies

  15 years, 2 months ago

  By: Gail Shaw

• SQL Server Service Won't Start

  Hi All, I'm stumped with a SQL Issue on my local machine, everything had been working fine then on…

  dougjjj

  7 replies

  15 years, 2 months ago

  By: chetanr.jain

• New Topic Insert querry for 3 Months Tour Data

  I am Building a "CAB Booking Application" in that i have done few things: 1> Firstly i have crea…

  ankit.uneedme

  1 replies

  15 years, 2 months ago

  By: WayneS

• SSRS - Linked Server SQL 2008 and MySQL

  Hello, Referencing an article very similar to this: http://www.ideaexcursion.com/2009/02/25/howto-s…

  MarksmanWaugh

  3 replies

  15 years, 2 months ago

  By: JeffRush