Standard Edition AG has a single DB per AG, and two servers only. (same as database mirroring was)

If you have multiple DBs that you need to make highly available, you...

No.

When last did checkDB succeed?

Can you manually create a database snapshot on that database?

CheckDB shouldn't need to lock the DB. It'll only try to do that if it can't create the usual database snapshot it uses.

Are there any other messages in the error...

aaron.reese (10/17/2016)

---

I am thinking I should probably try to cover the following topics

--Data Type considerations and mapping .NET datatypes to SQL datatypes

--Indexing strategies (Don't use GUIDs as PK, make sure...

Anyone seen the crystal ball?

http://www.sqlservercentral.com/Forums/FindPost1826636.aspx

jasona.work (10/17/2016)

---

Yeah, the company in question stands up every workstation "from scratch," every time. No two PCs are the same model, there's no standardized OS deployment, nothing. It's...

Gut feel here, an updated resume and a script, export, recreate (and you may not get everything back)

Why do you say the log isn't being truncated? Where are you looking and what are you expecting to see that you aren't?

It sounds like you're expecting the file size...

Since SQL executes those sequentially, there's only one running at a time. If you stop the execution (SSMS stop button or app timeout) then that session stops executing, the running...

My earlier statements stand.

Investigate your queries and make sure that what you think is happening is really happening, and targeted recompile hints on the queries are far better than on...

With recompile might fix that, might...

I'm no sure what you're asking regarding the unlimited size. A data file won't automatically grow to unlimited (and you wouldn't want it to, that's 16TB). It'll grow by its...

No, it applies only to the procedure it's on.

Why are you planning to add it? There's very few good reasons to recompile an entire procedure.

er.mayankshukla (10/14/2016)

---

Now, after the statistics is created on the index, whenever I insert rows to the table, shouldn't the statistics be auto-updated when the number of row inserts reaches the...

That's not an error, it's a warning that nulls are being eliminated due to aggregates.

Depending on the requirements, that may be a warning you can ignore, or an indication that...