SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Converting query from Access til SQL server

  I have a problem when I try to convert a query from Access to SQL Server This is the SQL from MSAcc…

  ronesse

  2 replies

  15 years, 1 months ago

  By: ronesse

• Get the Current Date

  I'm using GetDate() to get the current date in some insert queries. Most of what I've seen says the…

  Sioban Krzywicki

  36 replies

  15 years, 1 months ago

  By: WayneS

• How to shrink Database Snapshot (Sparse File)?

  Hi All, I have some requirement to create new database snapshot on my production database per day a…

  Reo

  3 replies

  15 years, 1 months ago

  By: Gail Shaw

• My SQLServer 2005 unexpexted is slow

  Hi, My problem is about, I have a SQLServer 2005 running normally, but unexpectedly it was very slo…

  fernando.ferreira

  4 replies

  15 years, 1 months ago

  By: fernando.ferreira

• new compressions option

  I was trying this option in a trail version and would like to know few things with the pros and con…

  Tara-1044200

  2 replies

  15 years, 1 months ago

  By: MysteryJimbo

• SSIS , stored procedures and Jobs

  hi all I was wondering if anyone could help, I need to pass 2 variables to a stored procedure that …

  gunning

  5 replies

  15 years, 1 months ago

  By: gunning

• Bulk import of data spanning tables?

  I am about to place a large number of records into a SQLserver database and it is spread over multi…

  chris-939265

  2 replies

  15 years, 1 months ago

  By: chris-939265

• MIrroring Access details

  Hi All, I am using live database & my conpany requesting for MIRRORING database..... If i…

  saidapur_satish

  3 replies

  15 years, 1 months ago

  By: ps.

• insert data in more than one tables from XML file

  Hi Folks, I have assigned a task to insert the data from XML file to the respective tables.Befrore …

  Anurag-428305

  2 replies

  15 years, 1 months ago

  By: Anurag-428305

• Shared or dedicated storage

  Hi all Maybe you could shed some light and add your opinions here. (Background) We have a productio…

  Matthew Lang

  5 replies

  15 years, 1 months ago

  By: Matthew Lang

• insert data to table and select data from view at the same time

  Hi everyone, i got a application that connects to sql server user can use the application to insert…

  dlam 18073

  3 replies

  15 years, 1 months ago

  By: dlam 18073

• Using Group By and Case I need a column to output in all situations

  Hi, Basically what I'm looking to do is sum data from a Cash Flow table and group by the Past and F…

  samalex

  1 replies

  15 years, 1 months ago

  By: LutzM

• Disk I/O Monitoring

  HI Can anybody suggest me how to check the IOPS for mssql 2000 / 2005 / 2008 database so that we ca…

  vrijesh prajapati

  2 replies

  15 years, 1 months ago

  By: Tim Parker

• Incorrect Syntax near '7'

  Can someone tell me why I'm getting this message when there's no '7' in my expression. Case when da…

  jhand6603

  11 replies

  15 years, 1 months ago

  By: jhand6603

• failing on only a portion of MERGE / BULK rows

  I have a statement like: MERGE INTO [tablename] USING (SELECT [columns] FROM OPENROWSET (BULK [dat…

  e1785

  2 replies

  15 years, 1 months ago

  By: e1785