SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• How to replace stuff with string agg on sql server 2017 ?

  i work on sql server 2017 i need to replace stuff with sting agg string_agg so how to do that pleas…

  ahmed_elbarbary.2010

  3 replies

  2 years, 10 months ago

  By: Jeff Moden

• when execute query it take 32 second to return 2 rows so how to solve slowly iss

  I work on sql server 2017 i face issue when run simple query it take 32 second to run two rows so i…

  ahmed_elbarbary.2010

  6 replies

  2 years, 10 months ago

  By: frederico_fonseca

• Voice-Based Transport Enquiry System

  Hello All, I am working on SQL project which is a Voice-Based Transport Enquiry System and I am loo…

  Ankitdixit

  2 replies

  2 years, 10 months ago

  By: Steve Jones - SSC Editor

• OPENROWSET problem

  I have a test server (TEST1) running SQL 2012 and Windows 2012R2. One of the developers wants to us…

  n.heyen

  13 replies

  2 years, 10 months ago

  By: ssv

• How to get first row group by partid and compliance typeid and document type?

  How to get first row group by partid and compliance typeid and document type? I work on SQL server …

  ahmed_elbarbary.2010

  1 replies

  2 years, 10 months ago

  By: Mr. Brian Gale

• Welcome

  Hello This topic was modified 2 years, 10 months ago by  johnmichael122. This to…

  johnmichael122

  1 replies

  2 years, 10 months ago

  By: johnmichael122

• How to allow multi user work on same table without any issue of interact data ?

  I work on sql server 2017 I have issue How to allow mutli user working on same table without using …

  ahmed_elbarbary.2010

  6 replies

  2 years, 10 months ago

  By: Jeff Moden

• How to write query get long process job or query or stored procedure running on

  I work on sql server 2014 How to write query get long process job or query or stored procedure runn…

  ahmed_elbarbary.2010

  3 replies

  2 years, 10 months ago

  By: Jeff Moden

• How to reduce high cost index seek and hash match inner join when analysis execu

  I work on sql server 2014 I have issue on my execution plan below https://www.brentozar.com/pasteth…

  ahmed_elbarbary.2010

  2 replies

  2 years, 10 months ago

  By: DesNorton

• issue max value for records inserted all take number 4 i need it 4,5,6,7 ?

  I need to insert data to table #t with incremental by 1 so max id for records on #t is 3 so if i in…

  ahmed_elbarbary.2010

  3 replies

  2 years, 10 months ago

  By: Jeff Moden

• How to rewrite update statment with best practise and performance ?

  I work on SQL server 2014 I need to rewrite update statement with best practice CAN I Write it with…

  ahmed_elbarbary.2010

  2 replies

  2 years, 11 months ago

  By: frederico_fonseca

• are there are any thing can do after create index to enhance query speed ?

  I work on sql server 2014 i need to enhance query my execution plan as below : https://www.brentoza…

  ahmed_elbarbary.2010

  1 replies

  2 years, 11 months ago

  By: Jeff Moden

• Execution plan not show missing index so are there are remainig point to enhance

  I work on sql server 2012 my execution plan as below my query is very slow it not show missing inde…

  ahmed_elbarbary.2010

  1 replies

  2 years, 11 months ago

  By: frederico_fonseca

• How to write loop below with best practice performance ?

  I work on SQL server 2012 I have temp table get data from excel and based on data exist on excel i …

  ahmed_elbarbary.2010

  9 replies

  2 years, 11 months ago

  By: Jeff Moden

• How to get data from table Compliance Data Based on PartId and ComplianceTypeId?

  I work on SQL server 2014 I need to get data from compliance data table horizontally . based on par…

  ahmed_elbarbary.2010

  1 replies

  2 years, 11 months ago

  By: Steve Collins