SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• How to send mails from sql server 2016

  Hi All I am setup mail configuration in sql server database but it is not send and return error. li…

  polo.csit

  10 replies

  7 years ago

  By: pietlinden

• Generate Inserts.

  From the past : /* Procedure: sp_generate_inserts (Build 22) (Copyright © 2002 Narayana Vyas Kond…

  ben.brugman

  3 replies

  7 years ago

  By: Sue_H

• 2016 SSIS inquiry

  I have to modify a simple SSIS package that extracts a table from a database and copies it to anoth…

  fizzleme

  1 replies

  7 years ago

  By: Phil Parkin

• Estimated Number of Rows 4,056,100,000,000,000,000,000,000 !

  I inherited a long convoluted query that rebuilds a summary table every morning. It recently starte…

  homebrew01

  8 replies

  7 years ago

  By: William Rayer

• Does adding a column to my table will trigger a update change in Change Tracking

  Hi, I am using Change Tracking to tracks changes in a table. I would like to create a new column in…

  Gamleur84

  0 replies

  7 years ago

  By: Gamleur84

• Concatenate date for JSON payload

  Afternoon, I'm working on encoding a json token and I'm getting this - "Conversion failed when conv…

  delizat4g

  2 replies

  7 years ago

  By: delizat4g

• Solve a problem without using Loops

  I know I can solve this problem using a looping strategy but I was hoping someone could suggest a w…

  tfeuz

  3 replies

  7 years ago

  By: tfeuz

• Creating and Joining CTEs in SQL

  I am new fairly new to SQL coding.  I am trying to write and join two CTEs to return one data set s…

  Eric

  21 replies

  7 years ago

  By: dmbaker

• Create objects under multiple schemas

  Hello All, Is there a way by which if I create an object under the default dbo schema the object sh…

  sac.nan

  12 replies

  7 years ago

  By: Joe Torre

• Good sources for SQL training?

  I'm relatively new to SQL and would like to beef up my knowledge of how it operates and query comma…

  rickkumar

  3 replies

  7 years ago

  By: ScottPletcher

• Learning SQL!!

  Hello sysadmins. I've been tasked with becoming more familiar with SQL, and I've only really just b…

  rickkumar

  2 replies

  7 years ago

  By: ScottPletcher

• Create table with synonyms

  Hi all   I've having a bit of a tidy up of our functions as we have the same function all over…

  richardmgreen1

  0 replies

  7 years ago

  By: richardmgreen1

• get 1st row per group

  CREATE TABLE [dbo].[EmployeeTest1]( [JobTitle] [varchar](50) NULL, [BirthDate] [date] NULL, [Mar…

  mtl20144102

  1 replies

  7 years ago

  By: mtl20144102

• Why a query would pick unrelated index

  Hi I came across a scenario where a query is picking totally unrelated index in the execution plan.…

  S_Kumar_S

  5 replies

  7 years ago

  By: Jeff Moden

• SSRS 2016 Sample Reports

  Are there any available SSRS 2016 Report samples out there? I'd like to introduce our BI/Reporting …

  ImYourDBA

  3 replies

  7 years ago

  By: John Bevilaqua-427875