SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Where are the operation being done in SQL Server?

  Hi Experts, I would like to know where are the operations, say, "my select statement does the …

  latheesh.jaya

  3 replies

  15 years ago

  By: latheesh.jaya

• Partition Order_Products line table based on date in Order header table

  Hi, I have an Order_Products table which has all products for all orders in our database for the pa…

  JayK

  1 replies

  15 years ago

  By: pietlinden

• Transactional Replication(Push) and initializing from a backup file

  Hello my friends, I have a rather larger DB that I would like to create replication for. Because th…

  Mr J

  1 replies

  15 years ago

  By: Mr J

• Improving Windows startup time w/lower priority SQL Server...

  Hi... I have been a SQL Server developer for years but just installed SQL Server 2008 (not r2) 64-b…

  1pbfoot

  1 replies

  15 years ago

  By: Gail Shaw

• time difference in hh.mm

  I have one computed column Shorthours. In this computed column i want to display the result in hh.m…

  pnasz

  4 replies

  15 years ago

  By: Jeff Moden

• Unable to deploy from Database project when CDC is enabled

  We are using Visual Studio database project for database development. We recently enabled CDC on c…

  Randy Emerson

  1 replies

  15 years ago

  By: GSquared

• Using a common seed generation for multiple tables.

  Hi, I'm new to SQL Server 2008, and I like to seek your help in achieving the following. We are try…

  Randy Emerson

  12 replies

  15 years ago

  By: Randy Emerson

• Selecting value(s) from a field that will equal a selected value

  Hello. I apologize if the question is not in a proper format. I am trying to find a way (Via SQL o…

  lacelle

  1 replies

  15 years ago

  By: WayneS

• Getting latest date from columns

  Hi all, I'm wondering what is the best way to get the latest datetime from several columns. The que…

  torpkev

  2 replies

  15 years ago

  By: torpkev

• Database migrated from 2000 to 2008 R2

  I restored a sql server 2000 database to a sql server 2008R2 instance and it went throught the upgr…

  DBABC

  2 replies

  15 years ago

  By: DBABC

• Track table row deletion

  What is the best way to track the user who deletes any records in a specified table? User informati…

  sukino.li

  6 replies

  15 years ago

  By: sukino.li

• ERROR_MESSAGE() returns different message then the one shown in the message tab in MSQL Management Studio

  Hello guys I'm hitting a wall here, i have a certain procedure1 call a procedure2 on a linked serve…

  skerjanc.matej

  3 replies

  15 years ago

  By: skerjanc.matej

• import data from excel file to sql server database

  plz..........help any one .....how to import data from excel file to sql server database

  gupta.sreekanth

  2 replies

  15 years ago

  By: Mike John

• Merging data from another system into mssql

  Hi I am looking for some advice or best practices on merging data from a separate system into a mss…

  all4miller

  2 replies

  15 years ago

  By: all4miller

• Querying 8GB table is taking too long - need to just query last 3 months of data

  Hi, We have an issue running a reports in that the query can take up to 4:30 minutes to run. we iss…

  JayK

  3 replies

  15 years ago

  By: JayK