General

• Topics

  Started by

  Posts

  Last post

• How do I flatten this data out to one row?

  I’m totally lost, I think it can be done with a union query but I can’t get it to work. Any help is…

  kawi6rr

  3 replies

  8 years, 10 months ago

  By: kawi6rr

• What is your experience with Team Foundation?

  I was looking for some feedback on those of you who actually use TFS for SQL Server development? Do…

  xsevensinzx

  4 replies

  8 years, 10 months ago

  By: GabrielPoulsen

• Transaction Timeout

  Good Day. We are running an SQL Server 2008 Database . Every 5 minutes a job inserts data into a ta…

  lianvh

  4 replies

  8 years, 10 months ago

  By: jakev1273

• What is the best to remove xp_cmdshell calls from t-sql code

  I'm maintaining large t-sql based application. It has a lot of usages of bcp called through xp_cmds…

  Mcin

  14 replies

  8 years, 11 months ago

  By: Jeff Moden

• Reverse string without built in functions

  Hello all. I am trying to write a function which reverses passed string WITHOUT using any built-in …

  pshvets

  30 replies

  8 years, 11 months ago

  By: Jeff Moden

• Knowledge Transition

  Hi All, I will be takeing up a new project from an existing vendor for a client. I would like to kn…

  NottyHeadedBoss

  1 replies

  9 years ago

  By: GSquared

• Pivot table queries

  Apologize in advance if this has been answered already as I couldn't find what I'm looking for. I w…

  keiths 29597

  2 replies

  9 years ago

  By: keiths 29597

• Month and Day of Datepart

  Hi,   I need to get a two digit day and month out of the datepart and it's only bringing back …

  rasoulov

  7 replies

  9 years ago

  By: j-1064772

• How to Convert .dat (Btrieve data file) to SQL Server

  Hello all experts, Greetings ! I need your help. I work on data-migration projects and I am respons…

  luhar.mitul

  5 replies

  9 years ago

  By: eemagliamc

• How to filter fur multiple facilities

  In our facilities table we have multiple facilities. AMB KFC KHC KPIC A person can be assigned to m…

  kawi6rr

  5 replies

  9 years ago

  By: Alan Burstein

• Enormous Transaction Log!

  Good day and thanks for looking at my post. I have a Stored Procedure which runs every hour during …

  tcalloway

  8 replies

  9 years ago

  By: Jeff Moden

• Can eliminating blocking / deadlocking ever be BAD for performance?

  I've been working on a large, multi-user, multi-customer SQL database system for several years now …

  julian.fletcher

  9 replies

  9 years ago

  By: Jeff Moden

• Make Rows to a Column

  Hi Experts, Please help on below. How can i accomplish this query using t-sql. below is the origina…

  jaquino012

  12 replies

  9 years, 1 month ago

  By: SQL learner22

• Service Desk SLA Report

  Hi all, I need assistance with regard to a DBA task. I need to create an SLA report that will show …

  eudith

  2 replies

  9 years, 1 month ago

  By: eudith

• Visual Studio 2012 stops working on project switch

  I have VS 2012 Ultimate installed on my 64bit PC and it is starting to drive me nuts. I can open a …

  Brandie Tarvin

  2 replies

  9 years, 2 months ago

  By: Brandie Tarvin