SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• bulk insert headache

  windows 2016 server with sql 2016 doing a bulk insert on a space delimited text file. The file resi…

  fizzleme

  9 replies

  5 years, 11 months ago

  By: fizzleme

• CREATE INDEX does not utilize all CPU cores

  Hi all, it's the first time that I am observing the behavior that not all CPU cores are used to com…

  svenflock

  3 replies

  5 years, 11 months ago

  By: svenflock

• Joining on VarBinary(8000) column

  Hi All, Having inherited a poorly performing database we've redesgined and come up with some potent…

  waxb18

  2 replies

  5 years, 11 months ago

  By: heb1014

• Find the Originating DB Name, Not the Current DB Name

  I am considering creating a "Tools" (or similar name) database to hold common procedures and functi…

  fahey.jonathan

  2 replies

  5 years, 11 months ago

  By: heb1014

• SYMMETRIC KEY Incorrect syntax near 'TRIPLE_DES'

  Hi All   I'm using SQL2016 I'm having an issue with a piece of code generated in SQL2008 Sampl…

  DamianC

  6 replies

  5 years, 12 months ago

  By: DamianC

• update table b if b.time falls between any of table a rows start/stop

  I'm trying to find a way to rewrite this dusty old cursor set based, if possible. It's updating a c…

  delizat4g

  11 replies

  5 years, 12 months ago

  By: delizat4g

• Read xml with namesapces

  <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <…

  fafful

  1 replies

  5 years, 12 months ago

  By: Phil Parkin

• how to call same logic using different parameter in if then else stored procedur

  ALTER PROCEDURE [dbo].[employee] @isemployee int AS IF (@isemployee = 0) BEGIN DECLARE @Email Varch…

  mcfarlandparkway

  4 replies

  5 years, 12 months ago

  By: jcelko212 32090

• SQL Server Merge replication issue

  We recently moved our 2008 R2 database to a 2016 server.  The compatability level was changed to 20…

  crystal.hoffman

  1 replies

  5 years, 12 months ago

  By: sterling3721

• Best way to write query that shows orders that\'ve purchased 2 specific products?

  Basically, I just want to write a cleaner query than what I have, which involved setting up 2 temp …

  Goalie35

  6 replies

  5 years, 12 months ago

  By: Goalie35

• SSIS - dynamic file name in data flow task

  Hi, I have a data flow task which exports a table to csv and then FTP the csv to a remote location.…

  Rushdi Basir

  5 replies

  6 years ago

  By: Rushdi Basir

• Using T-SQL to programmatically edit and save a SSIS config file

  I want to be able to edit a SSIS Config file for a different company, each time that I ran it. Each…

  Weegee2017

  3 replies

  6 years ago

  By: GonnaCatchIT

• Dynamic - Row Level Masking.

  Hi, I have looked into Dynamic Data Masking and Row Level Security, Is there any we can combine bot…

  koti.raavi

  2 replies

  6 years ago

  By: David Burrows

• select several lines randomly according to several categories

  Hello, I have the following dataset: Family Room subfamily 1            5               6 2        …

  abdalah.mehdoini

  6 replies

  6 years ago

  By: Sumathi

• Errors in searching for linked servers in procs

  I'm currently trying to build a document for our project manager  and one of the tasks is to find o…

  MVDBA (Mike Vessey)

  3 replies

  6 years ago

  By: MVDBA (Mike Vessey)