BTW, you'll get a lot more attention by posting your stuff to a new question. The only people likely to respond to this are those of us who are following...

You may have kind of outlined the issue. You truncated the data, which will empty the statistics automatically. The SELECT query runs after the truncate, but before the data load...

You're past the edge of what Express is used for. I'd strongly advise you to upgrade to a paid version of SQL Server. You can take advantage of more and...

I'm going to agree with Jeffrey here. I think you would need to tear down the existing AG before you can create a new AG, especially using the same name.

Open Microsoft SQL Management Studio on the Source server. Log in to your SQL server. Expand the server and as well as Databases. Right click on the name of your database and go to Tasks...

Oh crud. Sorry. I totally missed that this was a managed instance. I actually have never set up Extended Events on MI. I've done it multiple times on Azure SQL...

Just be careful what you use the Developers Edition for.  If the databases on your SQL Express system are production databases in any way, shape, or form, it's a...

If you go to the Microsoft certification web site, they list all the topics you need to study for the test. Study those topics. Done.

The service account that SQL Server is running under must have access to the folder where you expect the Extended Event session to write to. It's nothing about creating the...

So, you want to return a list of procedures that are SELECT queries with result sets, but not INSERT, UPDATE, DELETE queries?

Honestly, I'm not sure how I'd go about doing...

• This reply was modified 5 years ago by Grant Fritchey.

I'd suggest reading the Stairways series here on SQL Server Central. The introduction to T-SQL stairway has a lesson plan on GROUP BY. Scattered throughout the second...

If you set the parameters yourself, as Jeff is suggesting, then you don't have to worry about simple parameterization or forced parameterization (either of which is what you're hitting). That's...

No arguments here. Just as many business are hybrid when it comes to the cloud, many are hosting multiple data platforms. I've been learning (relearning to a degree) some Oracle...

Call me anything you want, just not late for dinner.

The job of administering databases was radically different in 1995 than it is today. Technology has shifted radically.

Yet, there's still a...

You can set up Availability Groups and other HA solutions using Azure (or AWS, GCP) as the secondary. I haven't had to do it myself in years & years, so...