SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Backup script for Availability Groups

  Hi, I am trying to write a script that assesses whether an availability group is Primary or not. I…

  kevaburg

  3 replies

  9 years ago

  By: kevaburg

• Help for SQL begginer

  I set up a trial with MS Azure and was practising SQL on MS SQL Server 2016 using the sample databa…

  james.h291183

  1 replies

  9 years ago

  By: Gail Shaw

• Nested loop no join predicate

  Hi All, I have the following T-SQL; With CTECTD1(dossierno,custno,regnno,costcentre,odometer,fuel,…

  ringovski

  3 replies

  9 years ago

  By: ringovski

• SSMS 2016 / Windows 10 / Multiple Desktops

  I've started playing around with the 'multiple desktop' feature in Windows 10 and have noticed that…

  Phil Parkin

  13 replies

  9 years ago

  By: sgmunson

• SSMS 2016 Settings being lost

  Hi All, I've come to the point now where I'm getting down right annoyed that SSMS 2016 "Forgets" a …

  Thom A

  3 replies

  9 years ago

  By: Thom A

• Create TAB delimited file using BCP cmd line

  Hello, I am trying to export data from our staging environment to a .txt file on my local machine. …

  Lord Slaagh

  2 replies

  9 years ago

  By: Lord Slaagh

• Nonclustered Columnstore with only one rowgroup even with > 1 million rows

  Hi, I have some real time OLTP analytics and aggregates that we perform on OLTP tables. I am testin…

  Yell McGuyer

  2 replies

  9 years ago

  By: Yell McGuyer

• the promotion has decided to go out with a bang

  Tennessee vs. Nebraska Live Stream Georgia vs. TCU Live Stream Sun Bowl 2016 Live Stream Liberty Bo…

  angelopoche

  1 replies

  9 years ago

  By: John Rowan

• SQL beginner needs assistance! ( I know, I know, GREAT! Right?? lol)

  I need to choose multiple misc. accounts from an account table using a list from one of our account…

  jason.shaw

  6 replies

  9 years ago

  By: Yell McGuyer

• Msg 245, Level 16, State 1, Line 2 Conversion failed when converting the varchar value 'F' to data type int.

  I get the error when i query all or any data with F or S at the end. Some new ID numbers are now …

  nilknarf

  16 replies

  9 years ago

  By: Samantha.Fahrmann

• Need help with SQL query

  Hi All, I'm pretty new to this and am in need of some help writing a query. I'll try to explain. I …

  Simon Hammill

  6 replies

  9 years ago

  By: Joe Celko

• Help with delimited SQL

  Hi Guys, I am trying to execute an array of comma delimited SQLs in a stored procedure. I call it a…

  nadersam

  12 replies

  9 years ago

  By: Phil Parkin

• Upgrading from SQL Server 2008 R2 to SQL Server 2016

  Hi All , We have all application databases in SQL Server 2008 R2 . I am looking forward to upgrade …

  SJanki

  2 replies

  9 years ago

  By: SJanki

• SQL Help- Pivot/Case

  Hi IDKEYQuantityContainerPRODUCTGRPNAME 120161125111 A 120161125111 A 12…

  greeshatu

  5 replies

  9 years ago

  By: ChrisM@Work

• Compare subset with subset in same table

  I have a table with 2 columns, FormulaID, IngredientID The table contains formulanames with the ing…

  hamzajosh

  8 replies

  9 years ago

  By: hamzajosh