SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Error in t-SQL code

  Dear all, I have the following code and I always get an error . it seems to be related witg dates. …

  river1

  2 replies

  8 years, 7 months ago

  By: ChrisM@Work

• KEY Lookup vs RID Lookup

  Hi everyone, There is a ton of information about key lookup vs rid lookup, but it seems I can't fin…

  Gamleur84

  9 replies

  8 years, 7 months ago

  By: Gail Shaw

• SSRS: Addind a parameter to the dataset query

  Dear all, I have created in my dataset a parameter named @pDB  and I have build the query belo…

  river1

  4 replies

  8 years, 7 months ago

  By: Thom A

• How to set remote location for File table directory in SQL server 2016?

  Hi All, I need a help. I want to change File table directory with different location(Remote locatio…

  manavairajan

  3 replies

  8 years, 7 months ago

  By: Sue_H

• SQL Server Performing too bad when a SQL Job Executes On Schedule.

  Hi , I have a SQL Job which is hooking up an sps pulling data from the table/s which is having…

  vineet_dubey1975

  1 replies

  8 years, 7 months ago

  By: sgmunson

• Migration to SSIS 2016 using SSMA

  Some advice appreciated from someone familiar with large scale migrations. Simple answers welcome a…

  a_ud

  5 replies

  8 years, 7 months ago

  By: a_ud

• Transaction Processing When Calling Sub Stored Procedures

  Hi,  I have come across an interesting scenario, but am not sure what the outcome would be. If…

  Paul Giles-Randall

  2 replies

  8 years, 7 months ago

  By: Paul Giles-Randall

• Using SQL command inside DFT

  Hi, I'm trying to re-populate a sql table thru a DFT, which should be very simple, however it keeps…

  BI_Developer

  2 replies

  8 years, 7 months ago

  By: BI_Developer

• SSIS package to load data produces more unused space in SQL 2016 than SQL 2005.

  I recently migrated a database from SQL Server 2005 to 2016 and noticed the free space in the datab…

  Amy56035

  3 replies

  8 years, 7 months ago

  By: sgmunson

• How to pivot multiple column?

  Hi Experts,I have the following table and would like to pivot first 3 columns, order should be base…

  Naveen J V

  3 replies

  8 years, 8 months ago

  By: Luis Cazares

• Challenging string handling in T-SQL

  Hello Experts, I have a data in a table as shown in the first column (A) and would like to update a…

  Naveen J V

  7 replies

  8 years, 8 months ago

  By: Jeff Moden

• Unable to create column store index on a partitioned table holding computed column

  Dear Friends,I am trying to create a column store index on my table that holds a computed column, i…

  kannan_egd

  7 replies

  8 years, 8 months ago

  By: kannan_egd

• How to import unknown length of UTF-8 characters with Import wizard?

  Hi everyone, I have a Flat file formatted in UTF-8 and it has unknown number of characters length a…

  shogunSQL

  3 replies

  8 years, 8 months ago

  By: lsalih

• Using Case with 2 different variables in one query

  Hello Experts,I am trying to use 2 cases in the same query and is not working, this is the code: Se…

  montserrat.deza

  4 replies

  8 years, 8 months ago

  By: montserrat.deza

• Salesforce data and missing foreign keys

  For reporting purposes we have synced our SFDC data onto a SQL server using a third party middlewar…

  Ozymandias_EBON

  6 replies

  8 years, 8 months ago

  By: Ozymandias_EBON