How busy is the disk when you go to do the backup?  Is it an SSD or HDD?

I have a database that is roughly 400 GB and it can back...

My guess (as I've not seen your system or that behavior before) is that it isn't actually fixing anything.  What I expect is happening is you have a query that...

If memory serves, ASYNC_IO_COMPLETION wait type is related to writing to disk.  Quick google tells me that is correct:

Occurs while waiting for non-data-file disk I/O to complete. For example while...

It depends on the query.  If the query is an INSERT or an UPDATE query, adding an index may slow it down.

You can update statistics though without creating indexes.  Those...

The issue is with your UPDATE.

So lets run through this code logically.

Make the objects - no problem here

Set variables - no problem here

loop - "while @rows > 0" ok, lest...

I think you forgot the execution plan.  Without that it is incredibly hard to say with any certainty what would help.

indexes may help, or you may already have the ones...

I've found that SOMETIMES you need a CHAR(10) AND CHAR(13) before it puts in a new line.  Other times, I've found that having both confuses the tool representing the data...

Yep.  Alternately to making your presence known online, if you know people in your community who are looking for DBA's or even a DBA group (SQL Server user group in...

It depends.  Are you looking to change jobs/careers or stick with your current position?

If you are sticking with your current position, see what the company expects of you.  Talk with...

My opinion on this - it depends.  If the demand for DBA's and Developers is low in the area you live in, finding contracts may be tricky.  I imagine the...

I am not familiar with PLSQL, but with the method you are doing in that query, you are doing a 1-1 comparison, so @ID MUST be a single value, unlike...

That part is the EASY bit.  Set the report parameter to allow multiple values.  Then set the report parameter to be a variable in the query and use your WHERE...

This one is actually answered in the documentation.  First I went here:

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-parameters-report-builder-and-report-designer?view=sql-server-2016

which gives an overview of report parameters in SSRS 2016.  From there, I searched for "Data Type" which listed...

Could you provide:

1 - what you have tried already?

2 - sample output for what it should look like?

I am not sure what "stick" means or what your output should look...

• This reply was modified 5 years, 3 months ago by Mr. Brian Gale.

Congrats!  I have the same certificate and I think I got the same score actually.

Are your plans to keep going and getting more certs or stopping at the MTA?