ditto

About to head off to SQL Saturday Phoenix. Anyone else going?

I'd disagree here. The indexes are going to be created in the same manner. Whether...

Wayne West (4/15/2016)

---

...

For me, the worst thing about a cloud provider (and I hate that term -- it's just a VM on someone else's hardware, and that's all it is!...

Eric M Russell (4/15/2016)

---

Aggregate downtime per year is a common baseline measurement, but it may not be the right question. In many cases it's really a matter of how much...

Terje Hermanseter (4/15/2016)

---

My company runs a 24/7 business. As a DBA I take down our main DB servers for maintenance every 6th week for about 1 to 1 1/2 hour...

Thomas Hütter (4/15/2016)

---

Well, concerning downtimes of Azure, here's some recent experience of mine:

I attended 2 SQL events so far this year, at both there were speakers breaking their demos because...

I'll echo my sympathies.

I'll also say that you should setup a backup when you create a db. That's a good time to just make sure you at least run one...

Because of what GilaMonster brought up, get the DBA involved. Make a permanent table.

Apologies, forgot to tick the second answer. 🙁

Points awarded back to this time.

MarlonRibunal (4/14/2016)

---

Kick-off Meeting - that's the one important meeting in any project. It is where all the parties gauge their expectations.

and you said this:

Sometimes I think the problems in software...

Well, apparently I don't write good questions to teach these people things.

Maybe some of you should write some questions to help people learn how to write DML?

:-P:-D:w00t::hehe:

Seriously, looking for...

You want to be careful with triggers, and think through carefully if this always needs to happen, including when DBAs need to fix data.

However, if you do need to...

I agree with adding an index. Often the indexing by vendors, including Microsoft, is poor.

Support won't like it, so you'll need scripts ready to remove anything you add, and re-create...

Iulian -207023 (4/14/2016)

---

yes , nice question

Last week I think there was a topic on parallel queries , now this Query Store. Really nice.

Is there a way to make a sandbox...