Thanks for the tip.  I did not know there was a way to test a random file without reading the header directly.

If I had to do this myself, I think...

A couple of decades back we created a standards document for developers creating applications using SQL Server.  We had a meeting with the developers to go over the document.  It...

There is an interesting mention about NOLOCK in

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query

Don't use NOLOCK

When building queries, don't use the table hint NOLOCK. This hint prevents Dataverse from optimizing queries.

Any change to the locking can cause an app to fail.  I would not consider NOLOCK "clean".  It actually stinks.  However, it depends upon the cost of the other options. ...

A new server CPU from AMD has 192 cores.  I wonder how many cores can be effectively used by serialized transactions.

PS I think some of our legacy apps would use...

It's sort of like denormalization for performance.  Wait for a performance issue before considering it.  The primary issue I've experienced with "WITH NOLOCK" is developers using it as the first...

• This reply was modified 1 years, 6 months ago by rstone.

FYI Testing an upgrade in place need not be risky.  A copy of production can be restored offline.  I would "fear" doing an upgrade in place for a production system. ...

I've been a DBA over 20 years.  Because of experience, our team does not support SQL Mail, SQL Server Maintenace Plans, linked servers, and upgrades in place.  We do have...

I have come to like using the DBATools module (e.g., Import-DbaCsv) for csv imports.  This is especially true if there is a lot of trial and error or it's something...

A SQL select looks really cool with a column name [SELECT] and a table named [FROM] with a where clause using like to compare column [WHERE] with column [LIKE].  Finding...

• This reply was modified 2 years, 7 months ago by rstone.

I've seen this when installing from a share that is not trusted.  Another annoying issue is elevation when using a mapped drive when the elevated user is not mapped.

I know this is an old post.  If you are still searching for a video or find this post while looking....  

https://www.youtube.com/watch?v=m71xHLX4bSE

We have one application with a poorly performing security implementation.  Does anybody have any guidance on...

I agree that that queries are responsible.  I have used extended events to help identify queries and cursors that need to be optimized.  The vendor is currently working on fixing...

Hi, I'm in the same boat.  The vendor is working on fixing the performance issues.  I too would like to be able to use spinlock information to understand what is...