Derek Slinn (9/1/2016)

---

I think the answer is wrong,

Both are stored in tempdb database.

technically table variables can just be in memory if there is only a small amount of data in...

Thank you for the post, this is really so new to me.

I used till the value and the mentioning the path of the xml element but never ever tired...

+1

Thank you for the post, good one.

I checked all the correct answers and at the end unchecked the last one... inserting the NULL row to the existing 6 data rows...

Thank you for the post, Steve, good one.

I see a small mistake.:-)

Note: I don't use these functions much (apart from PERCENT_RANK), and didn't recall using PERCENTILE_REL or reading about it. so well... ummm.... really don't do the google search on this...

Thank you for the post, Nagaraju, good one.

Thank you, Steve.

This is the solution:

1. (refer to the Jin Chen's reply in the post):

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7f477018-aa14-4db0-8989-ce763b122a2a/sql-server-express-2008-reporting-services-rsaccessdenied-error?forum=sqlreportingservices

2.(followed by) Configure a Native Mode Report Server for Local Administration (SSRS):

https://msdn.microsoft.com/en-us/library/bb630430.aspx

3. (related)

http://stackoverflow.com/questions/5651245/can-not-access-report-manager-url-in-reporting-services-configuration-manager

I followed the steps from 1...

Thanks for the post, Steve. Interesting one.

(never used this at all. Sometimes I really wonder will I ever get a chance in real-world to use such features? Or, just...

I just tried this step, from the "Encryption Keys" section in the SSRS Configuration manager, I deleted all the files under "Delete Encrypted Content". Now again when I try the...

Thank you for the post, Steve, really good one.

(I had read one blog some time back about adding multiple files to single file group claiming for some performance improvement; apart...

Thank you for the post, Steve, good one. I got this from the off-line BOL

Thank you for the post,... well.. really creepy.

I was just reading the Rules on Regular Database Identifiers and some rules it fails to imply, seems like a bug.

(may be this...

Thank you for the post, good one.

(I felt this was a trick question as started reading the choices and had to compare with the BOL to see any word that...