Viewing 15 posts - 1 through 15 (of 247 total)
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...
November 30, 2014 at 11:59 pm
Divine Flame (10/9/2014)
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...
October 9, 2014 at 8:51 pm
Let me try answering it as this looks like a mix of question from BP fundamentals and new features in SQL Server 2014.
in microsoft doc there is written on...
October 9, 2014 at 2:30 am
The only way to get a historical record of queries run is to run a trace at the time that you want to observe. Otherwise you have dipped-out.....
October 8, 2014 at 4:52 am
What statement causes execution plan gets created and stored in cached in memory. ...Is it all queries or limited?
SQL Server creates execution plan for each and every query statement....
October 8, 2014 at 4:49 am
Did you try recycling the services post changing the Time Zone?
October 8, 2014 at 4:43 am
October 8, 2014 at 4:40 am
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...
October 7, 2014 at 3:33 am
Thanks Guys, I got the clue..:-)
August 4, 2011 at 5:34 am
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...
August 4, 2011 at 5:04 am
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..
August 3, 2011 at 5:54 am
aah. I just realized it.
Accidently I posted it in Azure Administration forum. Thanks for bringing it to notice.
December 12, 2010 at 9:50 pm
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...
November 29, 2010 at 6:26 am
I got all my info from this site :
Ok. I am gonna try this to see if I can do with it..
Thanks for sharing this information.
November 29, 2010 at 6:14 am
Assuming the address looks something like this :
How is someone going to be able to resolve...
November 29, 2010 at 6:09 am