SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• 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

  16 years 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

  16 years 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

  16 years 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

  16 years 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

  16 years ago

  By: Ramdas

• 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

  16 years 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

  16 years 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

  16 years 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

  16 years 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

  16 years 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

  16 years ago

  By: JeffRush

• In Line Subquery versus Join query

  Guys, I am trying to figure out the advantages and disadvantages in terms of performance for in lin…

  am-244616

  5 replies

  16 years ago

  By: Jeff Moden

• When I double-click .sql file it does not open in SSMS

  When I click on a .sql file, Management Studio opens, but the .sql does not open and display in the…

  mkovas

  4 replies

  16 years ago

  By: mkovas

• Index fragmentation

  Hi, Can anyone pls explain how index get fragmented on frequent insert, update and delete operat…

  Gopi S

  3 replies

  16 years ago

  By: @SQLFRNDZ

• Problems with SP2?

  I hadn't noticed many, if any, posts here on SSC regarding problems with 2008 SP2, just thought I'd…

  Wayne West

  8 replies

  16 years ago

  By: Wayne West