SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Is it worth splitting a stored procedure for performance reasons?

  I have a stored procedure that takes as input many parameters from the user interface related to th…

  N_Muller

  3 replies

  11 years ago

  By: ZZartin

• The owner () of job <Job Name> does not have server access problem

  I started having this issue yesterday, after applying a change to bring my server(s) in compliance …

  jasona.work

  8 replies

  11 years ago

  By: jasona.work

• SSIS - 32 bit and 64 bit

  I built a SSIS(writing out to a flat file ) in 32 bit machine and it woks fine . But however when I…

  Guras

  5 replies

  11 years ago

  By: Scott Coleman

• Sql Query Using CASE WHEN

  Hi all, I need a help to solve following query.... select pub.Publication, CASE WHEN ed.Edition='AL…

  shirish1987

  1 replies

  11 years ago

  By: djj

• Converting getdate

  Hi, I need to compare the date column. The date column is 2012-01-22 in this format. So I need to c…

  ramana3327

  5 replies

  11 years ago

  By: ScottPletcher

• SQL 2008 R2 - Trouble Aggregating Data From Common Table Expression

  Greetings, I am trying to create a small data set for use in a charting program. However, I am not…

  dragonlancer1970

  2 replies

  11 years ago

  By: dragonlancer1970

• Index alignment in partitioning

  Good morning, First up; I've yet to use partitioning in a production environment, and pretty much l…

  Matthew Darwin

  21 replies

  11 years ago

  By: ScottPletcher

• 50000 error executing stored process

  we are queirying an stored procedure multiple times same time,from our application. In this case, f…

  meetmohanat

  21 replies

  11 years ago

  By: Lowell

• Group by clause - question

  I am trying to print Companies with less than 100 employees for all dates. Here's my table structur…

  rash3554

  4 replies

  11 years ago

  By: David Burrows

• i have object with name "utils..deletelist" in my database .where can i find the same in the object explorer ? what kind of object it is ? is it a table or proc etc ...?

  i have object with name "utils..deletelist" in my database .where can i find the same in the object…

  MVIT

  3 replies

  11 years ago

  By: MVIT

• DTC Select works, insert update fails cannot begin distributed transaction

  We have a rather large environment and have just a couple of boxes out there that we are getting ca…

  Frankie-464050

  2 replies

  11 years ago

  By: Eirikur Eiriksson

• Update incoming rows based on % calculation

  I have below records coming in from source files ProdName Amount TranType P1 100 A P1 100 S P2 200 …

  sujit.sg

  3 replies

  11 years ago

  By: sujit.sg

• TDE enabled DB stuck in limbo during Decryption

  Sql server 2008R2 (SP2) Ent, PROD DB myDB was encrypted. During Release mistakenly (Vendor created …

  Yuri55

  2 replies

  11 years ago

  By: Yuri55

• Deadlock involving query against sys.tables

  I got what to me is a weird deadlock. There's an ALTER INDEX ALL REBUILD WITH (SORT_IN_TEMP_DB = ON…

  Sioban Krzywicki

  5 replies

  11 years ago

  By: ScottPletcher

• Triggers

  Hey, I want to create a trigger so that when a column is updated in one table in one database, anot…

  lanky_doodle

  3 replies

  11 years ago

  By: Gail Shaw