Thom A (10/18/2016)

---

I would say that's a little ambiguous of a question. You don't state whether the time in the question is your local time, or the UTC time, which...

No good process. Like anything else, I'll propose something to my wife and then debate it. Certainly I could use that...

Ugh, not a great week. Not sure anything on my bench would have made a difference. That Eli really came through this week.

Phil Parkin (10/17/2016)

---

Spammers have upped their game recently. Some are starting to mention 'SQL' or 'database' in the subject line, the ****ers. What's the latest on migration to new forum...

I got this from someone late last night. 1 database per AG, limited restrictions on how the secondary works.

You can have more than one AG, but each has a...

I might recommend you read these as well:

http://www.sqlservercentral.com/stairway/72382/

http://www.sqlservercentral.com/stairway/72494/

You'll have to alter the database file and add space.

This is going to be very complex. The issue is that SQL Server cannot decrypt values, so it becomes problematic to try and use a temp table where you are...

Two nodes: https://msdn.microsoft.com/library/cc645993.aspx

MS seems to recommend no more than 10 dbs/AG, though this is based on testing of 10 Ags on an instance. More can result in memory issues and...

I would go with the second one. If you have indexed the PKs, then this can result in less scanning. In the first query, you must scan all of a,...

I'd never RAID 0 stuff. Too much effort to rebuild, unless you are backing up somehow.

That's me, however. I have been meaning to get a "quick rebuild" system going so...

Not SQL specific, and doesn't address the way in which someone uses the lab. I was hoping for...

I've added a SELECT to all answers.

However, in retesting, I get these answers for the four respectively (cut and paste the code in SSMS 2016).

NULL

Dak Prescott

Trevor Siemian

TrevorSiemianNorthWestern2

Tom, not sure why...

Read this: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Gail talks about catch-all queries.

Voted, and tweeted