SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• An exercise in query optimisation.....

  Hi all, I am starting to work in an environment where database DevOps plays a very important role a…

  kevaburg

  7 replies

  8 years ago

  By: kevaburg

• Query running slow across linked server

  Hi all Firstly, apologies for the lengthy post, but I'm trying to get everything in I thought would…

  richardmgreen1

  25 replies

  8 years ago

  By: kevaburg

• .bat file fails in SSIS

  I have created a Execute Process task that runs a .bat file. This bat file creates a very small .tx…

  BI_Developer

  18 replies

  8 years ago

  By: Sue_H

• Leverage window function to break out of triangle join?

  I have an issue where I wrote a triangle join and then realized that when doing some testing and I …

  Maxer

  6 replies

  8 years ago

  By: Maxer

• SSIS - scripts get deleted by deploy process

  Hi there I'm pulling my hair out with SSIS deploy problems! The problem is as follows: If I deploy …

  Bleeping DBA

  3 replies

  8 years ago

  By: Bleeping DBA

• Challenge: Insert a specific number of rows based on an integer column in one query!

  I am creating promo codes. They are issued simply by inserting a record for the customer into the P…

  Jasmine D. Adamson

  14 replies

  8 years ago

  By: Jasmine D. Adamson

• replace text in large number of view and procedure definitions

  I want to find and replace one particular word (happens to be the name of a database, which I know …

  isaac_654135

  6 replies

  8 years ago

  By: kevaburg

• BCP Import From Snapshot Replication For Recovery

  To start with, I used the following link as my base to start: Older Post I am attempting …

  kDBAjan

  6 replies

  8 years ago

  By: kevaburg

• Substring

  I get a files with a dates e.g Generate20170922, These files are stored like this in the db. I want…

  hoseam

  8 replies

  8 years ago

  By: Thom A

• SQL Server Replication. How does SQL Server deal with conflicts?

  I have an SQL server database setup for replication, My boss asked me what happens if  I …

  Paul Giles-Randall

  5 replies

  8 years ago

  By: Ant-Green

• SSIS: Case clause with sintax error

  Dear all, I am creating a derivated column task. It has a case in the expression but I always get t…

  river1

  8 replies

  8 years ago

  By: river1

• Why Grant User View Definitions to Database Objects?

  I have setup a user defined role to grant members of the role certain access to database objects li…

  andrew.jones 69458

  12 replies

  8 years ago

  By: kevaburg

• The order of TRUNCATE and DROP / DISABLE NONCLUSTERED INDEXES

  Hi folks... I'm hoping for some guidance on TRUNCATE and NONCLUSTERED INDEXES.  I've been told…

  Utrolig

  8 replies

  8 years ago

  By: ScottPletcher

• Column stats or density for each table

  Hi to all sql lovers.Is there any way to get for each table and each column for example this:SELECT…

  povamartin

  12 replies

  8 years ago

  By: sgmunson

• Query completed with errors

  Hi, Guys i try to delete large data from my db about 1.5 mln rows ( 2012 Sql server), actually i de…

  iseedeadpeople

  8 replies

  8 years ago

  By: kevaburg