SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SSIS Excel Data Source - Ignore Excel Sheets When Not There

  Hello SQLers Does anyone know if it is possible to ignore an Excel sheet within a workbook, if it's…

  Baxter P

  1 replies

  15 years ago

  By: gklundt

• Baffling DATEPART("dw"...) difference for day of week

  Hi all, I've come up against a REAL head scratcher when trying to get a simple expression working a…

  Joseph Fallon

  10 replies

  15 years ago

  By: mister.magoo

• Some questions concerning SQL Server 2008

  Hi everyone, Really need some help. My company is upgrading SQL Server 2005 to SQL Server 2008 R2 x…

  KTG

  2 replies

  15 years ago

  By: Shawn Melton

• Platespin

  A quick question: Would anyone ever use platespin as a DR solution for SQL? Is it better to use SQL…

  BU69

  1 replies

  15 years ago

  By: PaulB-TheOneAndOnly

• Password Expire

  Hi, I am created a user ABC, i want to this user expire after 21 day's...... Please if you …

  saidapur_satish

  4 replies

  15 years ago

  By: Reo

• SSIS Data Flow Fail

  Transferring 2 million records from SQL server to Oracle using simple OLE DB Source and Destination…

  danielagger98

  4 replies

  15 years ago

  By: danielagger98

• open cursor takes long time

  i have an open cursor, on a table : Set @TempTableCursor = Cursor Local FAST_FORWARD For Select …

  peleg

  3 replies

  15 years ago

  By: Jeff Moden

• Stored Procedures for multiple like condition search

  Hi All, Please go through the screenshot which i had attached I have a table with 4 columns.The fir…

  ashvinero

  1 replies

  15 years ago

  By: LutzM

• reason to set Max Server Memory

  I have a machine that has a fair amount of ram. SQL Server max memory setting is not set, so it tak…

  winston Smith

  3 replies

  15 years ago

  By: Grant Fritchey

• Unexpected performance improving.

  Hi I have a problem that i couldn't find the reason. We have a erp application running on sql serve…

  ocolakoglu

  3 replies

  15 years ago

  By: LutzM

• What is wrong with this query?

  hi, I have write the query like ----------------------------------------- insert into tbl_xml(E…

  kuppurajm

  11 replies

  15 years, 1 months ago

  By: Jeff Moden

• 1 column vs 2 columns (using integer and varchar)

  hi i need to store a value that can be integer or string (depends on a key value) is it better to u…

  michel.zdw

  4 replies

  15 years, 1 months ago

  By: ChrisM@home

• Database Diagram

  Hi All, I have created database diagram in SQL Server 2008 two days back and it was created success…

  manoj2001

  3 replies

  15 years, 1 months ago

  By: gopal-254292

• Searching entire Database

  Hi Everyone, I have a quick question that I was hoping to get some feedback on. I am currently req…

  scott.lucas-1068252

  2 replies

  15 years, 1 months ago

  By: scott.lucas-1068252

• How to rename a column using alter command

  Hi, Can anyone help me to get the query to alter/rename the column name in sql without using the …

  Rasu

  2 replies

  15 years, 1 months ago

  By: Rasu