Jeff Moden (10/18/2016)

---

Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3 TeraBytes to Network Attached Storage (NAS) in 1 hour...

Really depends on your CPU and IO subsystem, as well as the load on your system. Also, if you use multiple files and disks or not.

Ultimately, I could take a...

in other words, in your query

select ...

from inserted i

calvo (10/18/2016)

---

I'm hoping for the Cubs, I know what that kind of drought feels like. If they win, that town is going to go bonkers. Not to mention the redemption...

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...