Sure.

I have separate scripts for creating table and for creating indexes.

SET ANSI_PADDING ON
GO


CREATE NONCLUSTERED INDEX [IX_User_LastName] ON [dbo].[User]
(
[LastName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB =...

Thanks a lot.

@Grant

Do you know how I can identify "Parallel query worker thread was involved in a deadlock"? I saw such a message in the SQL Server Profiler but didn't see any...

@Mr. Brian Gale, @Grant Fritchey, @jeff Moden

thanks a lot.

1. Can I conclude about the appropriateness of the index based on scans, seeks and lookups in this table?

2. Do...

First of all, I saw that we have Amazon RDS for SQL Server.

Regarding script for index maintenance (https://ola.hallengren.com/) it looks like the same as what I want to...

We don't have any maintenance on DB.

It is a virtual machine. I saw that a lot of indexes take a lot of space:

Everything works very slow.  The...

I have a Standard Edition.

I have poor performance of my SQL Server and saw that a lot of tables had fragmentation more than 90 %.

Unfortunately, I didn't see any blocks. Can it be some locks? Because there is a lot of information and I can't understand what is better to concentrate on. I saw...

I saw that my queries and SP with the same execution plan have different time execution.

I would like to investigate maybe something can block it...