When it comes to validating users’ input, dynamic SQL or not, I like to use the belt and braces method of validating the input by running it through the sys.dm_exec_describe_first_result_set...

M$-JSon might not be strict 😉

😎

• This reply was modified 2 years, 9 months ago by Eirikur Eiriksson.

Quick thought, this can be simplified by using OPENJSON

😎

Here is an example:

USE TEEST;
GO
SET NOCOUNT ON;
GO
---------------------------------------------------------------------
-- Declare the test variable
---------------------------------------------------------------------
DECLARE @TSTRING NVARCHAR(MAX) = N'["Acct Vert - Chemical","Acct Vert...

You might want to read up on Foreign Keys

😎

Log entry: Error: 17806, Severity: 20, State: 14. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed....

Start with a simple aggregation and work from there!

😎

Here is the first part:

SELECT
    COUNT(T.BookId)
   ,T.TransferDate
   ,T.BookStatus
FROM dbo.Transfer T
GROUP BY T.TransferDate
...

I did not get the second part of the suggestion though. I already have a clustered index which is my primary key (tenantId, id). did you mean that I...

To start with:

1. The DDL (create table) code
2. Indices details
3. Usage stats
4. Code for all triggers
5. Constraints and...

As I...

For a simple row count, you can query sys.dm_db_partition_stats.

😎

Suggestions:

1. Try running the query with option maxdop=1, the cost of parallel execution might be the costliest part of the query.
2. An...

The simplest way would be to create a new table, insert the data from the original table, rename both tables and run an update to catch any changes made between...

Hi Alexander,

and welcome to the forum.

😎

Hello All,

My first statement works but performs poorly. Subsequent statements generate errors.

Any insight into why the error? Any alternate syntaxes that might work that I can try on my...

Here is a suggestion that should get you passed this hurdle

😎

USE TEEST;
GO
SET NOCOUNT ON;
GO
---------------------------------------------------------------------
-- SAMPLE DATA AS POSTED
---------------------------------------------------------------------
;WITH SAMPLE_DATA(listing_id, [date], available, price) AS
(
    SELECT...

Just...