Database Design - Attributes Arrangement

Dear Experts, Please refer to the below schema for your kind perusal. I would like to know whether …

Error 208: Invalid object name ''msdb.dbo.MSdistpublishers''

Hi Guys, We have a server setup as a distribution server, which manages the replication to & fr…

Local machine login failure on new install - why is local machine trying to login?

Hi, I've built myself a test install of SQL Server 2017 (Developer, RTM-CU1) including the agent, S…

How to subtotal an expression

I have a column, Column3,  that has the expression =iif(Fields!ARR.Value=1, Fie…

Error running execute xp_cmdshell

Hi AllI can run this from the command prompt C:\Windows\System32\WindowsPowerShell\v1.0\powershell.…

Searching strings

Hi all We've got a 3rd-party application and an associated database.We need to join two tables toge…

Complex string condition: How to get table records where 3 consecutive letters matched in string column

Hello, I have 2 Tables both have a column (App_name) which contains  application name. I need …

SQL Beginner: one to many relationship, updating single row based on many rows in join table

Hello, I'm fairly new to SQL and seem to be struggling with the concept of "one to many". I'll use …

Join with SQL View taking more time in SQL 2016

sql server - Join with SQL View taking more time in SQL 2016 - Stack Overflow   &nbs…

IN-Memory tables

Hello All!I would like to know what is the the pros & cons of In-Memory tables in SQL Server 20…

String Search

STORED PROCEDURE

Hi following is my stored procedure, its will help me calculate went a particular staff is due for …

I have to get a count of orders placed between 1 pm yesterday and 1 pm today by day

The table looks like thisOrderNo, OrderDate908, 1/3/2018 13:20:34909, 1/3/2018 15:18:41910, 1/4/201…

Hard to get CU's behind the most recent

We're looking to update our SQL 2014 SP1 instance to SQL 2014 SP2 CU8. I guess I'm thinking that th…

Transactional replication keeps applying snapshot

Hi, I created a new snapshot and applied it.  It ran the scripts to truncate all the tables an…