SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Non cluster index vs non cluster index include

  Hello all, I noticed that there is 2 ways to create non cluster index 1) Regular 2) with include Wh…

  89netanel

  5 replies

  8 years, 7 months ago

  By: Ed Wagner

• Did you ever see a change of a collation change drastically a performance of a query?

  Hi Guys, Did you ever see a change of a collation change drastically a performance of a query? Th…

  FabricioLimaDBA

  4 replies

  8 years, 7 months ago

  By: FabricioLimaDBA

• Migrating 300+ databases. Need a script to transfer user permissions for all the users across all the databases

  Hello experts, I am soon going to be migrating 300+ databases off of are old sql server to the new …

  Feivel

  5 replies

  8 years, 7 months ago

  By: Jeff Moden

• Roll up of % and duration to Parent from Child

  Hi, I need to roll up Completed and Duration from child to the respective parent tasks . I hav…

  PSB

  7 replies

  8 years, 8 months ago

  By: Jeff Moden

• Query works until I use it in a stored procedure (contains forward slash)

  I've tried escaping the '/' forward slash in various ways I found by googling my problem but nothin…

  pharmkittie

  12 replies

  8 years, 8 months ago

  By: Jeff Moden

• Newbie Help - SQL Query

  Hi all,I am in desperate need of some help please.  I'm not a SQL expert but am trying to writ…

  dump 10119

  9 replies

  8 years, 8 months ago

  By: sgmunson

• Interview Question

  Hi. Recently I have attended a couple of interviews. I have faced a similar question about stored p…

  susmitha117

  21 replies

  8 years, 8 months ago

  By: ben.brugman

• Connection problem from SQL Server 2016 to SQL Server 2008 R2 using SSIS

  I have a SQL Server 2016 SSIS project that works just fine against SQL Server 2008, 2012, 2014, and…

  Robert Frasca

  6 replies

  8 years, 8 months ago

  By: Robert Frasca

• 2 consecutive timestamps greater than 4 hours

  Hello SSC, I posted this question earlier yesterday, but I don't think I asked the question correct…

  Lord Slaagh

  6 replies

  8 years, 8 months ago

  By: drew.allen

• Merge multiple .sql files into one single file

  Hi, Does anyone have a program or utility that can merge multiple .sql files in the windows directo…

  lewisdow123 90045

  11 replies

  8 years, 8 months ago

  By: David Burrows

• Select List from xml

  I have xml like this :DECLARE @x XML = '<revieves> <recievemessages>  <message…

  farax_x

  5 replies

  8 years, 8 months ago

  By: drew.allen

• Deleting a row(s)

  I have the following data set. Sequence    CurrentStatusId   &nb…

  sql_2005_fan

  6 replies

  8 years, 8 months ago

  By: Jeff Moden

• How to get computed column value in Stored Procedure ?

  Hi,I hope I am in the right place to post this question.  If not, please direct me to the righ…

  karenworld

  1 replies

  8 years, 8 months ago

  By: Phil Parkin

• 1 Tb is How many rows in a databse

  How many rows does a database contain in 1TeraByte?

  susmitha117

  8 replies

  8 years, 8 months ago

  By: Eirikur Eiriksson

• export to xml file with separate rows

  for exporting to xml file i use:bcp "select * from table'" queryout C:\filename.dat -S @@servernam…

  sam-433147

  4 replies

  8 years, 8 months ago

  By: Lowell