SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How do I decide which column(s), if any, I should place my clustered index on?

  I have seen a lot of discussion inadvertently pertaining to clustered indexes and which columns the…

  Jared

  18 replies

  14 years, 5 months ago

  By: okbangas

• bcp Challenge

  can i do a bcp a flat file from unix to sql server 2008 version ?

  sqlnaive

  5 replies

  14 years, 5 months ago

  By: Jeff Moden

• How to run an update statement??`

  Hi, I know this may be a basic ?? But I have and Adresss table and I want to run some SQL to update…

  jbalbo

  4 replies

  14 years, 5 months ago

  By: jbalbo

• 32bit alias on Windows 2008 R2 not working

  Hey all, I setup an alias both in my Native Client Configuration for 64bit and 32bit on a Windows 2…

  Adam Bean

  2 replies

  14 years, 5 months ago

  By: Tom257

• How to automate database scripting

  Hi, I've got a group of databases with secondary data (all the data gets transactionally replicated…

  Roust_m

  34 replies

  14 years, 5 months ago

  By: Jared

• performance of the query and index

  hi friends, I need some advice on where to start with performance tuning. I am sure it is huge topi…

  dva2007

  19 replies

  14 years, 5 months ago

  By: dva2007

• How to do order by on alias column?

  How to do order by on alias column? Select customerID,FirstName +'_'+ lastname as customerName from…

  prashant-507002

  5 replies

  14 years, 5 months ago

  By: davidandrews13

• Database mail question

  I'm investigating a possible mailing system that will send automated emails to our customers. Came …

  memymasta

  11 replies

  14 years, 5 months ago

  By: memymasta

• Passing dates to SQL Server 2008 Tables

  Hi Guys, This might not be the right forum for this query I have my ADO code up and working and am…

  Tallboy

  2 replies

  14 years, 5 months ago

  By: prashant-507002

• Compatabilty mode

  we have sql 2000 databases , is it possible to change the compatabilty of the databases to sql…

  ramyours2003

  1 replies

  14 years, 5 months ago

  By: Adi Cohn-120898

• How to maintain the encrypted password in SSIS XML configuration file

  Hi All, How to maintain the encrypted password in SSIS XML configuration file ? Thanks & Regar…

  deepak.a

  1 replies

  14 years, 5 months ago

  By: okbangas

• Need Help Creating a View

  I have a Table called UserAbsences with a couple of columns, UserID & DayID. Both of these col…

  thanks19

  2 replies

  14 years, 5 months ago

  By: ChrisM@Work

• Redirect requests for default instance to named instance

  Hi all, We have moved our database from default instance to named instance of SQL SERVER 2008 R2 (d…

  MichaelBrown

  3 replies

  14 years, 5 months ago

  By: okbangas

• Function to find latest record in tables

  I'm working in reporting, very much on the fringes of SQL managment, so be gentle with me. 😛 For mu…

  phual

  3 replies

  14 years, 5 months ago

  By: phual

• float to varchar

  I have fax number in two tables. I need to update data from tableA to tableB. fax_number column in …

  sql_novice_2007

  5 replies

  14 years, 5 months ago

  By: ChrisM@Work