SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Question on Extended event

  Hi Experts, Is there a way to capture Timeout errors using Extended Events. Just incase if anyone h…

  vsamantha35

  11 replies

  9 years, 5 months ago

  By: vsamantha35

• Set based solution for Geographic problem

  I have two sets of data that have geographic data associated with them. One is a set of customers,…

  Steven.Grzybowski

  7 replies

  9 years, 5 months ago

  By: The Dixie Flatline

• Why does the query optimizer choose this way?

  I read the classic article https://blogs.msdn.microsoft.com/craigfr/2006/07/13/index-examples-and-t…

  Peter Shilovich

  17 replies

  9 years, 5 months ago

  By: The Dixie Flatline

• Joining and Pivoting Data Question

  Anyone able to help someone who is struggling to figure out how correctly join and pivot data from …

  slr010877

  6 replies

  9 years, 5 months ago

  By: slr010877

• Is it a bad idea to declare a cursor within a TRY block?

  I've come across some T-SQL where a cursor is declared within a TRY block. Naturally its opened the…

  Rod at work

  9 replies

  9 years, 5 months ago

  By: drew.allen

• How to get free space inside my data files??

  Hi Experts, Have some doubts on SQL Server space management. I am running SQL Server 2012 SP1 Enter…

  vsamantha35

  5 replies

  9 years, 5 months ago

  By: Gail Shaw

• DELETE making SELECT slow in RCSI

  Hi All, I have a table which has million rows and database is set under RCSI. The table has a clust…

  Tarun Jaggi

  19 replies

  9 years, 5 months ago

  By: ScottPletcher

• t-sql email

  In a t-sql 2012 database, I need to run a script that checks to see if there is more than 1 record …

  wendy elizabeth

  1 replies

  9 years, 5 months ago

  By: Thom A

• Calculating diffrence in minutes using datetiff function

  Hello, I have a problem where i want to get the diffrence in minutes between two times, my datatype…

  JALLY

  3 replies

  9 years, 5 months ago

  By: The Dixie Flatline

• XML DML Delete

  Hi there, In the example below, I want to delete a node based on the value of one of its elements. …

  Kimberly Blum

  3 replies

  9 years, 5 months ago

  By: Kimberly Blum

• simple dynomic Transpose 2 column as 2 rows

  Hi friends , i would like to transpose powerunit_natlang and transmission_natlang c…

  Anand BI Developer

  5 replies

  9 years, 5 months ago

  By: Luis Cazares

• query to stop running when a specific value in a row. odd request.

  i have a table that has a type column to indicate record type for our software. table1 t_col1 &…

  roy.tollison

  10 replies

  9 years, 5 months ago

  By: The Dixie Flatline

• Window Function Question - 3 month rolling average

  Hi Everyone, I am trying to achieve a 3 month rolling average calculation with the first two rows (…

  jguffey

  6 replies

  9 years, 5 months ago

  By: Alan Burstein

• Need to group within a query I'm already grouping

  My company mails letters. The following query returns the total number of letters mailed, split ou…

  Goalie35

  3 replies

  9 years, 5 months ago

  By: Goalie35

• Only insert records where the new value differs from the current value

  How could I create a query that looks at a new batch of user data, compares it to the values that c…

  Goalie35

  4 replies

  9 years, 5 months ago

  By: Goalie35