SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• rewrite two queries to single query

  sf

  ramrajan

  9 replies

  11 years, 8 months ago

  By: Ed Wagner

• Transfer data from SQL Server to MySQL

  I have a SQL Server 2008 R2 database from which I need to export data, to be subsequently read into…

  pdanes

  4 replies

  11 years, 8 months ago

  By: pdanes

• Script to determine longest running stored proc in 2005

  Hey all, I am in the process of migrating a 2005 db to 2012 and I need to find out which of my proc…

  Lord Slaagh

  1 replies

  11 years, 8 months ago

  By: SQLRNNR

• Calling a script on remote linux machine

  I have two machines, one has sql server 2008 the other one has linux. I have a batch linux commands…

  DBABC

  2 replies

  11 years, 8 months ago

  By: DBABC

• 2 questions

  sdf

  ramrajan

  7 replies

  11 years, 8 months ago

  By: SQLRNNR

• stored proc will not run against remote server

  try to run a stored proc to a remote server and get the following error: Could not find server 'KY1…

  gchappell

  1 replies

  11 years, 8 months ago

  By: Neeraj Dwivedi

• Replication failure with repeated synchronisation then unable to find stored procedure

  I have set up replication between SQL Server 2008R2 (publisher), 2012 (distributor) and 2008 (subsc…

  DrNo DBA

  1 replies

  11 years, 8 months ago

  By: Gazareth

• Help with Stored Procedure which runs every 30 minutes..

  I would like to create a stored procedure which runs every 30 minutes. The main purpose for this is…

  Chitown

  6 replies

  11 years, 8 months ago

  By: Chitown

• Best practice for number comparisons in SELECT statement

  Hi, just wondering what the best practice in sql is for If SYS is positive ( >= 0.00) then SYS …

  mattech06

  4 replies

  11 years, 8 months ago

  By: Koen Verbeeck

• change supplied date format for select statement

  Hi, as part of a select statement I'm wanting to grab a date range, in effect something like this A…

  mattech06

  6 replies

  11 years, 8 months ago

  By: mattech06

• Trimming Left and Right of side of cell

  Hello all, I am looking for a script to trim the left side and right of a cell. I can trim either …

  RazorbackDBA

  9 replies

  11 years, 8 months ago

  By: RazorbackDBA

• Drop Identity column from temp table

  Hi I'm selecting * from my perm table into my temp table(SELECT * temp INTO FROM perm), and it will…

  hoseam

  52 replies

  11 years, 8 months ago

  By: ScottPletcher

• DELETES not wrapped in a transaction, will they commit after each one?

  If I run a single query of a bunch DELETES statements and it is not wrapped in a BEGIN TRAN, COMMIT…

  ggoble

  5 replies

  11 years, 8 months ago

  By: ScottPletcher

• sql failover cluster and load balancing...

  Is there such a thing called 'Load balancing' on fail over cluster sql 2008? any input helps

  Tac11

  4 replies

  11 years, 8 months ago

  By: Tac11

• Queries running slower in SQL 2008 than in SQL 2000

  We are in the process of migrating from SQL 2000 to SQL 2008. We encountered a few queries that run…

  Frank Carrelli

  23 replies

  11 years, 8 months ago

  By: RazvanS