SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Redo Transaction Logs

  I have two disconnected SQL Server 2008 R2 instances with the same databases, but with different da…

  emchugh7

  1 replies

  11 years, 3 months ago

  By: Grant Fritchey

• Combining Columns into One

  How do I take several columns with different data on each and create a new column to combine all th…

  hermanator

  4 replies

  11 years, 3 months ago

  By: hermanator

• Adding column

  Hi All, I am trying to understand the process that SQL Server does when I add column to table? Tha…

  Barcelona10

  1 replies

  11 years, 3 months ago

  By: Barcelona10

• 2008 Central Management Server - Schedule Multi Server Query?

  Hi Everyone - I have a 2008 Central Management Server that we're able to run queries from against a…

  cpyne

  27 replies

  11 years, 3 months ago

  By: jswong05

• Daily Database growth difference

  Can someone please help me on below query to add a column that calculates the difference in amount…

  DBA_Learner

  4 replies

  11 years, 3 months ago

  By: Jack Corbett

• The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time.

  Hi, We have suddenly acquired the above message in a process that has been happily running for year…

  thespratty

  10 replies

  11 years, 3 months ago

  By: thespratty

• Populate TEST environment from PROD backup, truncate some tables, then shrink then rebuild or rebuild then shrink?

  The use case is to refresh lesser environments like DEV and TEST with production data, but I don't …

  jallmond

  3 replies

  11 years, 3 months ago

  By: Gail Shaw

• Using Extended Events to Monitor SQL Statements at Database Level Like with SQL Audits?

  I'm attempting some research on SQL statements that hit multiple databases. I've been comparing SQL…

  AbrahamLeftJoin

  1 replies

  11 years, 3 months ago

  By: Grant Fritchey

• Comparing two very large data sets - which join should i use?

  I have two very big tables (close to 1 bilion records each), these two tables are pretty much 1-1 r…

  curious_sqldba

  4 replies

  11 years, 3 months ago

  By: Grant Fritchey

• Calculate months based on parameters

  I have this code: /****** Object: StoredProcedure [dbo].[RPT_Human_Resources_Head_Count_Summary]…

  hoseam

  1 replies

  11 years, 3 months ago

  By: spaghettidba

• Excel Document as attachment via dbmail

  Hello All, I'm trying to export the results of a query in an excel file and send that file via atta…

  mayankminawat

  4 replies

  11 years, 3 months ago

  By: mayankminawat

• Replicating one table. May I use a linked server?

  Hi, I have to regularly pull data from a table on another instance (only INSERTs into this table) i…

  TommyF

  3 replies

  11 years, 3 months ago

  By: spaghettidba

• False Error 8152 / String or binary data would be truncated

  Hello, This is a bizarre situation we have started getting in some of our client environments. Basi…

  Michael Oberhardt

  9 replies

  11 years, 3 months ago

  By: john42

• How can I Prepend 2 CHAR in front of an INT?

  SELECTc.cust_fullname AS Name, c.cust_membership_id AS Account, t.c_amount AS Amount, …

  chef423

  4 replies

  11 years, 3 months ago

  By: Luis Cazares

• Case Statements and Performance

  I am reviewing a query that has case statements in it to replace codes with word values. (There are…

  K Currie

  3 replies

  11 years, 3 months ago

  By: ScottPletcher