T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Performance Tuning Large update statement--HELP

  I have a 1.2 TB database in which I am updating a couple columns across 11 tables. T1 (F_name, L_Na…

  dspink

  8 replies

  12 years, 8 months ago

  By: dspink

• archive process

  hi i need to Create process to archive the records ,anybody has any script or any ways to do it tha…

  riya_dave

  11 replies

  12 years, 8 months ago

  By: Jeff Moden

• Forecasting Year Numbers

  Hi all Apologies if this is posted in the wrong section but I didnt really know where it belonged. …

  carl.meads

  5 replies

  12 years, 8 months ago

  By: Dwain Camps

• sp_send_dbmail Query

  Regarding the @query parameter, BOL states: "Note that the query is executed in a separate sessio…

  dan-572483

  4 replies

  12 years, 8 months ago

  By: ScottPletcher

• Locking on update...inner join

  Thought I would re-write as it didnt make sense to me! When an update query is based on a join, so …

  david.alcock

  2 replies

  12 years, 8 months ago

  By: david.alcock

• complex joins retrive the echivalent results

  Hello I have a problem on doing an complex join between multiple tables : Here is my tables GLCMS …

  Beniamin Joke

  15 replies

  12 years, 8 months ago

  By: J Livingston SQL

• ALTER SERVER ROLE syntax error

  HI all I am trying to run the following but I get a syntax near 'ROLE' error, but it looks ok to me…

  Kwisatz78

  3 replies

  12 years, 8 months ago

  By: louigopal

• Denormalizing into a grid

  I just read the article on using UNPIVOT to normalize data. I noted that it said that UNPIVOT doesn…

  rray 44280

  6 replies

  12 years, 8 months ago

  By: Dwain Camps

• GetDate() 5 Years ago without time formated 'YYYY-MM-DD'

  I'm trying to restrict a query to go back five years ago. I have the following query which is not i…

  Welsh Corgi

  12 replies

  12 years, 8 months ago

  By: Steven Willis

• Check series is valid or not

  Hi, I have a scenario in which I have to check that whether I am correct no of series or not... Cre…

  kapil_kk

  7 replies

  12 years, 8 months ago

  By: Steven Willis

• Finding the most recently modified row from a group of tables

  I'm thinking there's some clever way of doing this, probably involving a CTE and recursion, but I'm…

  rray 44280

  6 replies

  12 years, 8 months ago

  By: ScottPletcher

• Running Dynamic SQL

  Hi All, I have in the past created dynamic SQL in a tally table and looped through to execute it. …

  Ness

  3 replies

  12 years, 8 months ago

  By: MMartin1

• performance of sp

  hi my sp is taking 5 min in prod.any way i can improve performance BEGIN TRY DECLARE @alerts TABLE …

  riya_dave

  7 replies

  12 years, 8 months ago

  By: Cowboy DBA

• MIN and MAX values with a subquery.

  Hi Everyone I have the following query in one of my databases. It returns 20 rows. SELECT C_…

  Johnny H

  4 replies

  12 years, 8 months ago

  By: Johnny H

• If Exists

  Hi all, I just want to know that in my below code is it possible to combine first two exists condit…

  kapil_kk

  9 replies

  12 years, 8 months ago

  By: kapil_kk