Hi All,

Looking for answer on what do I expect to happen on very first day for PL SQL job role, given 5 years of experience in resume. Because it...

What version of SQL Server were you using on the old server and what are you using on the new server?  This is really important because a new "Cardinality Estimator"...

No.  Using (*) as a part of a COUNT is NOT discouraged.  It will allow SQL Server to pick the best index to use to accomplish the count.  The use...

It's because <insert drumroll here>, it's an "Estimate". 😀

It's like asking someone how many wheels there are on their truck.  Because of "statistics" on the subject and you've identified it...

Awesome.  Thanks, Johan.

I created [_sandbox] database for this purpose, deployed the script and scheduled it to run every minute.

It's been 15 or 20 executions since then - no issues.

I'm telling you...

Once I fixed all the &lt; and &gt; entitizations and changed the database name to one of the one I have, it ran first time with no issues.  I wonder...

Awesome.  Thanks for the feedback!

I have a csv file that is input into a varchar(max) column in an Azure SQL Database table.  When the file is inserted into this table column I would...

Use CASE instead.

my take on this is " if you need to ask if NOLOCK should/can be used on a particular case then you do not know about it's issues and...

An admin account has privileges to manage services for other people in your organization. The Admin console is only available when you're signed in to an admin account. If...

Bit of a sidebar question on my part because I've not installed nor even downloaded SSMS since they made that change...

Do...

I'm curious... WHY?

Just remembered a thing about insufficiently specified requirements.

A wife sends her husband to a grocery shop:

- Buy a loaf of bread and if there will be eggs buy a...