SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Delete Vs Index

  Hi There, Can anyone share the links to read about HOW index affects delete operation in sql server…

  vignesh.ms

  2 replies

  11 years, 1 months ago

  By: Grant Fritchey

• Need help with performance...

  Hi everyone, We are currently using SQL Server 2012 Standard (64-bit) on single quad core processor…

  vikasrulez

  10 replies

  11 years, 1 months ago

  By: Gail Shaw

• Rounding UP values

  Hi, I need to round UP values but they should never be rounded down, below is my expected output in…

  kiril.lazarov.77

  1 replies

  11 years, 2 months ago

  By: stook

• Help with de-duplicating records in a table and updating the records to reflect eliminated dups

  Hello everybody, I have a set of roughly 1.2 million records in a table. The records came from mult…

  vecerda

  4 replies

  11 years, 2 months ago

  By: vecerda

• dynamically copy the table from one db to another db

  HI, The requirement is as below. Need to scheduled to copy table data from one database to another …

  ravisamigo

  1 replies

  11 years, 2 months ago

  By: aaron.reese

• Is there any chance to rearrange the execution plan manually?

  I have 2 tables, 1. Need 2. NeedCategory Need table has clusted index on needid column and NeedCate…

  vignesh.ms

  6 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Doubt on Coaleace

  Create table test(Names varchar(100) primary key ) insert into test values('Hugeman') inser…

  vignesh.ms

  4 replies

  11 years, 2 months ago

  By: Luis Cazares

• merge multiple rows into one

  i have no idea how to do this, basically i have data like this order_key comment 1 …

  nightowl23

  3 replies

  11 years, 2 months ago

  By: nightowl23

• Doubt on clustered index

  Hi There, Cluster index stores the data on the leaf level. But non-clustered index will have the po…

  vignesh.ms

  2 replies

  11 years, 2 months ago

  By: Gail Shaw

• Help building SSIS package or other method of extracting data

  Hello, I have a requirement to load data from the attached file. It is a .txt file that has a repet…

  vecerda

  2 replies

  11 years, 2 months ago

  By: aaron.reese

• How to write Stored Procedures to load the Data Model from OLTP to DWH ? Please Help me with this....

  How to write Stored Procedures to load the Data Model from OLTP to DWH ? Please Help me with this..…

  Krishh

  14 replies

  11 years, 2 months ago

  By: aaron.reese

• Update statement bringing unexpected results.

  I have a simple update statement (see example below) that when runs, I expect to see the number of …

  jfroberts-909895

  4 replies

  11 years, 2 months ago

  By: jfroberts-909895

• resolve sql issue by not using cursor or while loop

  Need to resolve issue by NOT using cursor or while loop (reason - I am running stored procedure ove…

  kevin_nikolai

  5 replies

  11 years, 2 months ago

  By: kevin_nikolai

• Adding certain Rows specific

  Hi All, I got a table where i need to add certain rows and minus the valu with a row can any one he…

  kriskumark96

  2 replies

  11 years, 2 months ago

  By: Luis Cazares

• How Update works for unique values?

  Hi There, Look at the following code, Create table #test ( id int primary key, Name varchar(100…

  vignesh.ms

  5 replies

  11 years, 2 months ago

  By: vignesh.ms