SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Doing a Range Scan on a composite index

  I know TSQL doesn't support tuples (e.g. WHERE (Col1,Col2) > (10,8)) but if I have an index as s…

  Gabriel P

  2 replies

  8 years ago

  By: The Dixie Flatline

• How to find % between two dates for the delay

  Hi Team, I would like to find out the percentage for the delay only, I have the ScheduledDate and …

  shagil.a.gopinath

  4 replies

  8 years ago

  By: shagil.a.gopinath

• Adaptive data models

  I am looking for literature or online resources on adaptive data models. Any pointers would be much…

  Orlando Colamatteo

  2 replies

  8 years ago

  By: Orlando Colamatteo

• Intellisense Tools

  Just wondering what everyone's take is on the Intellisense tools that are installed as add-ins to S…

  vinodajacob

  3 replies

  8 years ago

  By: sean redmond

• I need to read through a file containing postgres DML (inserts, updates, deletes) and remove characters to make the DML compatible with SQL Server DML syntax

  I have a script file that looks like this: Generated by Devart dbForge Data Compare for PostgreSQL …

  GaMusicMan

  5 replies

  8 years, 1 month ago

  By: GaMusicMan

• Rounding in tsql

  Hi ALL, I have a situation where I should round a col in a table Ex Units Desired Resul…

  ntreelevel

  16 replies

  8 years, 1 month ago

  By: Luis Cazares

• How to deploy a report in ssrs

  Hi, I am a new bee to sql server. I want to know how to deploy a report in SSRS. Can someone help? …

  Khalisi_MSDev

  2 replies

  8 years, 1 month ago

  By: Khalisi_MSDev

• Count the occurrence of word in a Resume Table

  I have a table called Resume with columns in Text, Word and PDF format. I enabled Full Text Search …

  shambhavi13

  27 replies

  8 years, 1 month ago

  By: Jeff Moden

• does DATEFROMPARTS() work in 2016?

  am working in dev environment sql server 2012. Need to create a date from 'snapshot month' (6) and …

  polkadot

  5 replies

  8 years, 1 month ago

  By: Gail Shaw

• sql server 2016 - Grant Fritchey

  Hello, Do you know if Grant Fritchey has a book on sql server 2016 yet? Thank you

  arkiboys

  6 replies

  8 years, 1 month ago

  By: Gail Shaw

• Option recompile and temp tables in a proc.

  https://blogs.msdn.microsoft.com/robinlester/2016/08/10/improving-query-performance-with-option-rec…

  MadAdmin

  2 replies

  8 years, 1 month ago

  By: MadAdmin

• Using new GetIdentificationStringByID to get Column Name in SSIS

  I'm using SSIS to load tab-delimited text files into a SQL staging db. Naturally, I'm having to dea…

  lduvall

  16 replies

  8 years, 1 month ago

  By: frederico_fonseca

• explain composite index structure and work? How B Tree for composite index work internally?

  HI Champs, explain composite index structure and work in sql server ? How B Tree for composite inde…

  ravi@sql

  1 replies

  8 years, 1 month ago

  By: Gail Shaw

• TSQL and if it can be done in set

  Hey Experts, This recently came up at work and the solution to the problem was utilizing a loop. I…

  brad.mason5

  6 replies

  8 years, 1 month ago

  By: Umer Akram

• SQL 2016 OPENJSON Array

  Hi, I have a mix of data in a table as follows: person_id interests 1&nbsp&nbsp&n…

  rka

  2 replies

  8 years, 1 month ago

  By: The Dixie Flatline