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

Iulian -207023 (10/13/2016)

---

Nice one, but I thought there is a way to pass just the script's name.

The same way there is catalog for SSIS and a reporting DB for SSRS,...

What's the free space in the data file? You can check in properties for the database, or use this:

exec sp_spaceused

Adding data won't grow this until the free space runs out.

If...

For the AWS/Azure people with labs, anyone want to write an article that would allow someone to duplicate your lab?

I am all for working to live and spending time with family and friends.

I also believe you need to work on your career, which might be time away from work....

I had to work on this for XE recently.

K, I'll ask someone to look at this.

So I'm in the gym in Vegas the other night, watching Cubs v Giants. See the Giants go up and seem to be playing well. Saw the hit off the...