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 1 year 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...

We have one SQL 2005 server left.  We can't upgrade it yet because it is the last version with the compatibility required by an old application.  The application is being...

Please, not another null or non-null debate. SQL Server has a clear implementation of NULL. The flat-nullers should just get over it. Far more important are domain...

ebouras (8/23/2016)

---

N_Muller (8/23/2016)

---

If you have temp tables (#tables) with indexes in a stored procedure where ansi warnings are turned off for aggregation of null values, the procedure fails. Regardless...

If you don't like the warning, it's often easy to update the query to explicitly replace the default behavior. To be honest, I have used this setting when I...

Thanks. I've been collecting performance counters on several servers. The easy calculations like average, extreme, and deviation tend to wash out performance details. I want to get...

PS Microsoft announced some good news the day before April 1st: Xamarin will be free for users of Visual Studio. It was not a joke. Now back to...