Yes, I know...

Slight bit of misunderstanding there. Let's say we have a VARCHAR(50). Now let's say that our data stored there is 'dog'. It doesn't use storage out to 50 characters. It...

For most of us, most of the time, that's way too much detail. It begs the question, what problem are you really trying to solve.

However, if you want crazy detail...

I haven't experience this, but I'd make sure that I'm running the latest version of SQL Server Management Studio.

Additionally understanding that the WHERE clauses and JOIN criteria (if any) for data manipulation queries are subject to all the same rules as a SELECT query. Something like a function...

Here's a very thorough article on BULK INSERT. In general, it can be faster for large data moves. It may use less locking. It may use fewer log resources....

Make sure you're capturing the performance metrics on the server so that you're getting processing time there and eliminating the round trip measurement. You want to know which part of...

Thank you Grant Fritchey!

I don't have Web Service RDS, but I ran below SQL Statement on local SQL Server  and got information as the file.

SELECT dl.deadlockgraph

FROM

(

SELECT dl.query('.') AS deadlockgraph

FROM...

Saw that. Fixed it.

I'd say that REORGANIZE is unlikely to because it touches so few pages normally when it changes indexes. A REBUILD on the other hand, that might do it. I only...

1. For deadlocks you can look into the system_health Extended Event session to find more occurrences. I have an example query here on this blog post on AWS RDS....

The only real way to improve "move all the data, all at once, right now" style queries is spending money. Buy bigger, better, faster, more hardware. That's the answer. Or,...

So, let's be clear up front, I work for Redgate Software and we make a tool that competes with Foglight, so you can take that into account with what I'm...

Run DBCC checks on your system databases. It sounds like either one of them is corrupt, or you're hitting an issue with tempdb, as was suggested in the error message...

Also, look for hidden issues like triggers.

You can look at execution plans for INSERT/UPDATE/DELETE queries, same as for a SELECT query. Common issues affecting performance can include stuff like foreign...