I checked https://msdn.microsoft.com/en-us/library/ff878487.aspx#RestrictionsAG and found the paragraph

Maximum number of availability groups and availability databases per computer: The actual number of databases and availability groups you can put on...

I confused TDE with 'Always Encrypted' and got it 'right'.

I just look back and think 'Damn! I must have been good!'

My basic feel is that GUIs are great if you have less than about 5 of something to do. More than that and it is usually worth it to...

pmadhavapeddi22 (9/30/2016)

---

Stewart "Arturius" Campbell (9/30/2016)

---

Nice, easy question to end the week on, thanks Steve.

Just a point of confusion in the options:

a table variable, a table in the table, or a...

I tried this a few ways. The following

select avg(x), avg(round(x, 0)), round(avg(x), 0) from (values(9.5), (9.00), (8.50), (8.00), (7.50)) a (x);

resulted in the following error which was surprising...

sipas (8/26/2016)

---

sknox (8/25/2016)

---

The correct answer is "it depends."

MOST of the time you'll get two rows as explained in the answer.

HOWEVER, each GETDATE() within each SELECT is evaluated separately. When the...

For those who thought this was easy: I previously worked with Oracle databases where TRUNCATE cannot be rolled back. I got this one right because I had previously been...

ako58 (8/16/2016)

---

http://qa.sqlservercentral.com/questions/Foreign+Keys+(FK)/144670/

CREATE TABLE #TableTest1 (

ID INT NOT NULL,

CONSTRAINT PK_ID1 PRIMARY KEY(ID)

);

CREATE TABLE TableTest2 (

ID INT NOT NULL

CONSTRAINT FK_TableTest1_ID FOREIGN KEY (ID) REFERENCES #TableTest1(ID)

);

INSERT INTO #TableTest1 (ID)

VALUES

(1);

INSERT INTO TableTest2 (ID)

VALUES

(2);

select *...

I have been to one SQL Saturday in Austin/Round Rock, TX Jan 30 from south of Houston. Was about 200 miles each way and I did as a day...

Nice article. I have a quibble on the latitude and longitude 'rules'. Other than the poles, latitude degrees should never be higher 89 and anything over 80 should...

I expected the answer to be that there was an error because tbl did not exist. Since that wasn't an option, I did some experimenting around the open transactions...

THANK YOU! That worked very well. Instead of using #temp I put it in a CTE and it ran in 11 seconds which is acceptable performance for my...

morlindk (7/14/2016)

---

Really interesting - and by testing out, I both learned something and got it right.

Still, my preferred answer would be simply "Yes, it Works". - You input a row...