SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Clustered Columnstore Index and Partition Elimination

  I have a clustered columnstore index that is partitioned on a date key.  If I write a simple query …

  chris.o.smith

  2 replies

  5 years, 10 months ago

  By: chris.o.smith

• How to apply rank when fetching data from table using sql query?

  Hi Everyone, I need your help to get the required results. I want to get a machine status every 5 m…

  manavairajan

  4 replies

  5 years, 10 months ago

  By: The Dixie Flatline

• One table or two?

  I have an outside company that will be sending me 2 files each month.  File 1 has approx. 280 colum…

  below86

  5 replies

  5 years, 10 months ago

  By: below86

• MSAccess to SQLServer Query Conversion

  Hi, Our client have MS-Access database which has more queries written in MS-Access 2010 version.We …

  Whizkid

  3 replies

  5 years, 10 months ago

  By: Ken McKelvey

• I am looking to optimize this T-SQL Statement (it generates very High Reads..)

    In the below SQL statement (also attached as DOC file) it has been identified that this part…

  VoldemarG

  13 replies

  5 years, 10 months ago

  By: The Dixie Flatline

• list to table, versus delimitedsplit8k

  Dear reader The list to table is build around a while loop, one item is taken of the list and put i…

  ben.brugman

  1 replies

  5 years, 10 months ago

  By: ben.brugman

• does WITH (NOLOCK) hint in Select statement really make a difference?

  In any regular Select query joining a few tables like below, does using this hint  WITH (NOLOCK) re…

  VoldemarG

  12 replies

  5 years, 10 months ago

  By: ben.brugman

• Using sftp in Visual Studio for SSIS packages

  Hi, I've inherited the maintenance of SSIS packages that were created by our former developer so I'…

  Isabelle2378

  5 replies

  5 years, 10 months ago

  By: Isabelle2378

• Issue with left join

  I have a select statement that selects studentid, studentjoiningdate, studentchargedhours, case whe…

  mcfarlandparkway

  3 replies

  5 years, 10 months ago

  By: jonathan.crawford

• Multi-column pivot table help

  I have the following data in [table_1]: last_updated type_desc size_bytes used_bytes 2019-05-23 …

  Pete Bishop

  2 replies

  5 years, 10 months ago

  By: DesNorton

• Select last non null value in field

  Hi I am struggling with how to apply this.  I want to get the status of a rental unit to populate a…

  Marcus Farrugia

  6 replies

  5 years, 10 months ago

  By: Marcus Farrugia

• result in same line

  Hello,   trying to query the result by success or failure in 2 seperate columns as bellow but …

  patdev99

  6 replies

  5 years, 10 months ago

  By: x

• Using CASE Statement to SET variable when null value

  Hi , I have a SP , that does an update to add comments to the table. However when there is a Null v…

  gjoelson 29755

  10 replies

  5 years, 10 months ago

  By: ScottPletcher

• How to Dynamically roll-up column results

  I have a table that contains data as per below script. What i would like to archive, is the previou…

  shani19831

  8 replies

  5 years, 10 months ago

  By: Jeff Moden

• Issue with left join

  SELECT DISTINCT DS.DepartmentId FROM dbo.DepartmentStore DS LEFT JOIN dbo.Student Std on Std.DS.Dep…

  mcfarlandparkway

  3 replies

  5 years, 10 months ago

  By: Chris Harshman