SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• will not using the statement terminator ';' break code in future?

  i've been searching for some definitive (or as definitive as it can be, since we dont all work for …

  davidandrews13

  7 replies

  13 years ago

  By: ScottPletcher

• How do you know how much RAM you need?

  Running the System Diagnostics Report (a Performance Monitor built in report) on a Windows Server 2…

  inevercheckthis2002

  4 replies

  13 years ago

  By: RML51

• Display last label value on x axis always

  I dont want to display each and every value on xaxis, i want to set interval to 'auto' but want to …

  SQListic

  2 replies

  13 years ago

  By: SQListic

• NEWID()

  Hi All, I have to know which algorithm is used in NEWID() function or to know how it works internal…

  ningaraju.ne 46825

  7 replies

  13 years ago

  By: Jeff Moden

• Sum

  HI, I have table like the given below gradelosalhisal 17001200 212011400 314012000 420013…

  karunakar2351

  2 replies

  13 years ago

  By: Luis Cazares

• Assist me the merge statement performance in sql server..

  Hi Everybody, Im using following query, is there any other alternative way? MERGE DistinctData AS …

  vignesh.ms

  6 replies

  13 years ago

  By: RandomEvent

• calculaing percentage Increase or Decrease

  Hi, I need help for calculaing percentage Increase or Decrease in Price of some Product for last tw…

  Rakesh.Chaudhary

  2 replies

  13 years ago

  By: Steve Jones - SSC Editor

• Data Sync between two Applications on different Database servers and sync should be done on set up tables data on both sides

  Hi Everyone, I am in a situation where two applications are interacting from two DB servers and i n…

  HSagar

  4 replies

  13 years ago

  By: Steve Jones - SSC Editor

• Duplicates

  When you have a temp table being populated. Can you join on that table so you don't get duplicates…

  cdl_9009

  6 replies

  13 years ago

  By: cdl_9009

• SQL Agent Job Scheduling

  Let's say we have an instance of SQL Server (the default instance) and two PROD databases within in…

  GBeezy

  4 replies

  13 years ago

  By: RandomEvent

• DeNormalize Key Value Hierarchy table

  Hi All, I have an hierarchy table as below which stores the key data.And the value for this key wil…

  ningaraju.ne 46825

  1 replies

  13 years ago

  By: Sean Lange

• Track username and time of action on delete for rows

  I've been trying on this one for a while. I implemented change data capture, but I found interpreti…

  DataAnalyst011

  7 replies

  13 years ago

  By: Sean Lange

• CTE in MERGE

  Can we use CTE in MERGE statement ? If possible then please post a sample code of that... _________…

  kapil_kk

  1 replies

  13 years ago

  By: Koen Verbeeck

• IP Restriction Feature

  There should be a feature in database to allow only certain IPs to delete the data. Can we keep a l…

  OnlyOneRJ

  14 replies

  13 years ago

  By: OnlyOneRJ

• Full and transaction log backup chain breakup

  Hi , let us suppose i take full backup f1 and now suppose i take 3 transaction log backup t1,t2,t3…

  anoop.mig29

  19 replies

  13 years ago

  By: SQLRNNR