SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Timeout Expired Error occurred while executing a SQL query

  I have received the following error while executing a query in SQL Server Execution Timeout Expired…

  IT researcher

  2 replies

  8 months ago

  By: Ken McKelvey

• Error 15151 While enabling Replication in SQL Server

  While enabling replication, I am getting the following error Error 15151: cannot find the user 'use…

  IT researcher

  1 replies

  8 months, 1 week ago

  By: IT researcher

• how to use Case or IF in a where clause?

  I have a query that joins a base table to a sentTable that tracks records sent from the base table.…

  lee.hopkins

  3 replies

  8 months, 1 week ago

  By: ScottPletcher

• Help with unique constraint

  Hi All, I have a table using the below structure.  Currently it's set up to be unique over names an…

  daytonbrown2

  12 replies

  8 months, 2 weeks ago

  By: daytonbrown2

• Error 28054 related to master key root cause and solution required

  I am getting the following error in SQL Server Error Log randomly on few days. I want to know the r…

  IT researcher

  1 replies

  9 months ago

  By: Johan Bijnens

• Perfromance Impact Benchmark of Data Compression on write operation

  I would like to get the benchmark test case results of Write operations (insert , update) after Pag…

  IT researcher

  3 replies

  9 months ago

  By: MMartin1

• How to attach Database created in higher version to lower version of SQL Server

  I have attempted to attach a database created in a higher version of SQL Server to a lower version,…

  IT researcher

  3 replies

  9 months ago

  By: Grant Fritchey

• Is there a possibility to have a full outer join in SSRS datasets?

  Is there a possibility to have a full outer join in SSRS datasets? I would like to have full outer …

  noorrocks 86488

  7 replies

  9 months ago

  By: misskelly1020

• MS SQL options to handle a large table, from the options listed below

  Hi, I have a SQL Server database with a table that contains 50 million rows, I expect the row count…

  rafter

  8 replies

  9 months, 1 week ago

  By: Jeff Moden

• Call Dates Effective Range

  Hi Everyone, I have the data in the below form : Desired output: Here what I did is I made a rang…

  Yash34

  5 replies

  9 months, 1 week ago

  By: Jeff Moden

• update field on a select query

  I have a sql query that runs on demand to generate a report. I want to update a field REPORTSENT to…

  lee.hopkins

  3 replies

  10 months ago

  By: lee.hopkins

• Connect to MySql databse

  Hi, I have installed MySql connector and configured the ADO.NET Source(.NET provider/MySql data pro…

  a2zwd

  2 replies

  11 months ago

  By: a2zwd

• Split fields sql 2017

  I am trying to split fields in sql 2017.  The column holds the following.  I am pulling the first 5…

  tylerschuler75

  4 replies

  11 months, 2 weeks ago

  By: Jeff Moden

• OPTION(QUERYTRACEON 9481), Dynamic SQL & DBCC TRACEON error.

  I'm in a bit of an odd-ball situation...  a) We are in the process of upgrading all SQL Server inst…

  Jason A. Long

  2 replies

  1 year ago

  By: Meera

• Commit transaction inside loops

  Hello, our users are complaining about blocking during a delete loop so I'm thinking that adding be…

  PHXHoward

  11 replies

  1 year, 1 month ago

  By: PHXHoward