SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Add date to bcp file name

  I have an SQL Job set up to send a file to a folder. I need to add getdate() in the format, yyyymmd…

  NineIron

  2 replies

  10 years ago

  By: NineIron

• mysterious slowdown every 4 minutes

  Hi I' ve a database used to a gaming application. 99% of procedure called by the application are 2 …

  andrea.dimaio

  19 replies

  10 years ago

  By: andrea.dimaio

• Killed/Rollback

  Last weekend a SQL Server Instance was migrated from WIN2008R2 to WIN2012R2, everything was fine. W…

  brunoperroni87

  1 replies

  10 years ago

  By: spaghettidba

• Passing calculated date from SQL Agent job to SSIS package

  I'm running into a problem trying to pass a calculated date field from a sql job to SSIS I've set …

  dhighley151

  2 replies

  10 years ago

  By: James.Gossett

• Non Existent Logfile showing in Database Properties

  Okay, I'm about to go nuts with this one. I have a database that used to have 2 log files. That lo…

  Brandie Tarvin

  2 replies

  10 years ago

  By: Beatrix Kiddo

• Wait type - PREEMPTIVE_SP_SERVER_DIAGNOSTICS very high

  If this wait type "PREEMPTIVE_SP_SERVER_DIAGNOSTICS" is very high what does it mean? What's the dow…

  SQL_Hunt

  2 replies

  10 years ago

  By: AlexMcCo

• Migrate Databases Report Server and Report Server tempDB

  Hi All, I am about to migrate some databases consist of user databases and also Report server and R…

  WhiteLotus

  6 replies

  10 years ago

  By: BLOB EATER

• xp_cmdshell Issue

  Hi Members, I have below scenario: SQL Server 2008R2 SP2 These is an SSIS package which applicatio…

  siddharthsingh02

  1 replies

  10 years ago

  By: Sachin Nandanwar

• sp_send_dbmail sending duplicate emails to user

  Hi, I have a insert trigger, and the purpose of the trigger is to send email to different dept for …

  SQLisAwe5oMe

  5 replies

  10 years ago

  By: SQLisAwe5oMe

• IS NULL AND IS NOT NULL

  What would be the best way of writing: First use TBS.Datetime if NULL then TBS1.Datetime, if both N…

  SQLPain

  3 replies

  10 years ago

  By: Jacob Wilkins

• How to find out if any user aliases are being used on SQL Server instance?

  Hi, I am planning to upgrade from SQL 2008 R2 to SQL 2014. User aliases have been discontinued in …

  Roust_m

  3 replies

  10 years ago

  By: ScottPletcher

• How to extract JSON String data to C# (datagrid view)

  Hello Experts Do we have any standard script available to extract any unknown JSON script to C# dat…

  SQL_Hunt

  1 replies

  10 years ago

  By: Luis Cazares

• Adding totals for previous two days

  Hi Sql Experts, Need help in finding total for last two days data. on 3/3/2016 i need to get sum of…

  dhanekulakalyan

  4 replies

  10 years ago

  By: Alan Burstein

• Replication question.

  Hi everyone. I just rebuilt all Peer to Peer replication on 4 servers. BR - Originator ID = 91, …

  cj.marchand

  1 replies

  10 years ago

  By: cj.marchand

• About Index - Can we create a nonclustered index on clustered index column

  Hi All, I know that we can create a nonclustered index on a clustered index column. Can anyone let …

  p.shabbir

  12 replies

  10 years ago

  By: ScottPletcher