Thanks @Shahfaisal

Very crisp and clear information.

Was wondering if there is a way out for dynamic partitions. Something like a partition should automatically adopt the next year's data in...

Divine Flame (10/9/2014)

---

Hi friends,

My assumption regarding the in-memory tables is that we create the tables & we configure which tables we want to make as in-memory tables. These tables use...

Let me try answering it as this looks like a mix of question from BP fundamentals and new features in SQL Server 2014.

freddyism00 (10/2/2014)

---

hi,

in microsoft doc there is written on...

Default...

SQL Server creates execution plan for each and every query statement....

Did you try recycling the services post changing the Time Zone?

jacksonandrew321 (10/7/2014)

---

Through windows account I am getting inside the sql server but when I choose to connect through sql authentication then its denied. Do I need to create user login...

I echo here with @TheSQLGuru as Enabling compression only changes the physical storage format of the data that is associated with a data type but not its syntax...

Thanks Guys, I got the clue..:-)

Tried placing the State <> 'Closed' filter here and there but not helping much.

If I am removing one 'OR' filter its working but I need to make it work with...

Indeed it was quite simple but I couldn't find out..earlier I was trying it with 'URL' + ID and it was not working...

Thanks for the solution..

aah. I just realized it.

Accidently I posted it in Azure Administration forum. Thanks for bringing it to notice.

with Report viewer, the problem I am currently facing is that if I give it a server name and report path, its working fine for the user who had explicitly...

Ok. I am gonna try this to see if I can do with it..

Thanks for sharing this information.

Ninja's_RGR'us (11/29/2010)

---

I've never done it that way (not even sure it's possible).

Assuming the address looks something like this :

http://reportServer/reports/...

How is someone going to be able to resolve...