SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• NEED TO CONVERT AN INTERGER TO A STRING THEN USE AS A JOIN TO THE TABLE.

  I have a stored procedure where i am trying to join an order table to a customer table by cust # (d…

  sharonmtowler

  2 replies

  16 years ago

  By: sharonmtowler

• exclude BIT column from the Group By clause

  Hello All, I have a query which is returning columns in various datatypes. this query uses the gro…

  Vincy-856784

  2 replies

  16 years ago

  By: LutzM

• possible to return the amount of keywords found using function contains

  I am fairly new with full text search. I managed to put the contains search right. But is it possib…

  sai.mopidevi

  1 replies

  16 years ago

  By: rakhi.bhatia

• convert Access query iif to SQL statement

  I want to convert Access query iif to SQL statement but got errors: IIf(#TUploadTo.WCFComplete=True…

  adonetok

  4 replies

  16 years ago

  By: mferanda

• Question about nested stored procedure

  I have a wrapper stored procedure which in turn calls other 10 procedures. In outer procedure I put…

  SQL Guy 1

  2 replies

  16 years ago

  By: Grant Fritchey

• How to do the load testing sqlserver 2008R2

  Hi All, how to perform the load testing in sql server 2008R2, when 2 r 3 users connecting to server…

  kommagoni

  6 replies

  16 years ago

  By: jasonlorraine1999

• Query Performance tuning

  I have self join query which is taking very long time to execute as it is cost about 30000 and exec…

  Vijay_Raju

  3 replies

  16 years ago

  By: Vijay_Raju

• CONNECT TO REMOTE PC

  How to Connect SQL Server of a Remote PC? I want to connect My Home SQL Server PC To My Office SQL …

  ßhavin

  6 replies

  16 years ago

  By: Ali Tailor

• Sql server and sql agent wont start

  Hi, I have installed sql 2008 and evreything worked fine until i restart my computer.When i restart…

  dino.maric

  4 replies

  16 years ago

  By: Ali Tailor

• Difficulty setting up transactional replication

  Hey all, I am attempting to test setting up transactional replication on two computers on a network…

  SQLUserC

  2 replies

  16 years ago

  By: SQLUserC

• Optimizing Server Config & DB Config etc

  Hello, I've recently been looking at how we can improve our current environments from a server conf…

  Pete-L

  3 replies

  16 years ago

  By: Enterprise DBA

• Runing some SQL statment inside stored procedure and out side stored procedure

  I have some sql statment,which when I run it individually they are pretty fast,but when I put them …

  Aspet Golestanian Namagerdi

  2 replies

  16 years ago

  By: LutzM

• Get min and max rows without a cursor

  Hello. I'm trying to get the "before" and "after" records for a telephone customer when they change…

  ken.trock

  7 replies

  16 years ago

  By: ken.trock

• Count Child node from table on base of parent id.

  Hi There, I'm creating MLM software. I'm stuck on sharp sql curve. I've created tables. Now I need …

  j_tush

  4 replies

  16 years ago

  By: j_tush

• sp_addextendedproperty for Instances

  I want to add some blurb for an instance such that I could write some T-SQL to bring the blurb back…

  nzrdb6

  1 replies

  16 years ago

  By: Lowell