SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Remove decimal values

  Hi, I am using this query to show my column as money and I need to remove the decimal values on top…

  vigneshkumart50

  5 replies

  11 years, 10 months ago

  By: ChrisM@Work

• Restore Script

  hi All, I need some suggestions - I am supporting large number of Development and Test databases. A…

  Sachin Diwakar

  2 replies

  11 years, 10 months ago

  By: free_mascot

• Bad performance. EXECSYNC wait type?

  Can anyone shed some more light on the EXECSYNC wait type? I've seen it appear in WAITSTATS on oth…

  Colleen M. Morrow

  4 replies

  11 years, 10 months ago

  By: BalasundaramRangasamy

• query plan cache gets cleared every hour

  I'm working for a client who creates a reporting database from a production system by shipping and …

  OldCursor

  9 replies

  11 years, 10 months ago

  By: Grant Fritchey

• Rename Server

  I have server name called X and i want to convert this server using Virtual to virtual.However, I w…

  Admingod

  1 replies

  11 years, 10 months ago

  By: JeremyE

• How to use an optimization for all operations in sp_executesql?

  Hi I have a C# solution with many parameterized sql queries. I would like to be able to add optimiz…

  jdk77

  2 replies

  11 years, 10 months ago

  By: Grant Fritchey

• 166 days to create index

  I have a table containing 2,163,568,622 rows hosted on SQL server Standard 2008. Attempted to creat…

  scott_lotus

  16 replies

  11 years, 10 months ago

  By: below86

• Need help with query.

  The data contains medications given to patients. If a patient is given Vitamin K, DrugID='VITA100T2…

  NineIron

  2 replies

  11 years, 10 months ago

  By: NineIron

• Finding Position Plain text inside html markup using SQL

  Consider following string I would like to thank whomever did the proofreading on Consider followi…

  shirish1987

  1 replies

  11 years, 10 months ago

  By: Lowell

• Reset sp_prepexec

  Can we reset sp_prepexec and sp_execute When i am running the sp_prepexec the id is generated say i…

  yuvipoy

  1 replies

  11 years, 10 months ago

  By: LutzM

• Why Use Error Handling?

  I have always believed best practice when writing stored procedures or any SQL code is to include e…

  dhechle

  2 replies

  11 years, 10 months ago

  By: Grant Fritchey

• time-out in a Job using link server

  i have this error in a job, this job is using linked server Message Executed as user: Domain\user. …

  M-Hol

  2 replies

  11 years, 10 months ago

  By: LutzM

• SSIS change destination to named instance

  Hi We have several SSIS packages where destination is 'SQL Server Destination'. Now they are moved …

  JanM-66

  4 replies

  11 years, 10 months ago

  By: Eyal Levin

• Tried to dynamically create schema, GO separator is not recognized

  I need to create a schema in every database, and here is my code that I try to execute dynamically:…

  SQL Guy 1

  1 replies

  11 years, 10 months ago

  By: Sean Lange

• spliting data rowwise

  create table #temp ( range2 varchar(15), descrip varchar(10) ) insert into #temp select '10-13','te…

  s.ravisankar

  2 replies

  11 years, 10 months ago

  By: mickyT