Viewing 15 posts - 1,711 through 1,725 (of 49,571 total)
larsp777se - Friday, March 3, 2017 3:18 AMIf you use SQL Server authentication, can you still give rights to groups?
No, because there...
March 3, 2017 at 3:23 am
March 3, 2017 at 3:14 am
You downgraded from Enterprise (which has a lot of performance features over the other editions) to Standard. You should expect that things are slower.
The one that's probably biting you...
March 3, 2017 at 1:11 am
larsp777se - Thursday, March 2, 2017 8:57 PMYou can asume that they have indeed googled before posting on a forum.
No, you...
March 3, 2017 at 1:00 am
ramyours2003 - Thursday, March 2, 2017 10:13 PMthanks for the reply , I need a steps to perform the task ?
Jason gave...
March 3, 2017 at 12:52 am
March 2, 2017 at 8:24 am
March 2, 2017 at 6:49 am
Custom account, minimal permissions.
March 2, 2017 at 6:31 am
If it's 2008, then it'll be something internal that you can't affect and can't change, and can't use for your own tables. Probably just an optimisation to avoid constant writes...
March 2, 2017 at 6:30 am
Google: "In-memory OLTP" It's a feature added in SQL 2014, way too large to cover in a single forum post.
Also consider getting https://www.simple-talk.com/books/sql-books/sql-server-internals-in-memory-oltp/
It's not a...
March 2, 2017 at 5:13 am
cntr_value
Current value of the counter.
Note
For per-second counters, this value is cumulative. The rate value must be calculated by...
March 2, 2017 at 3:56 am
March 1, 2017 at 5:43 am
Generally I would say bad practice. It's not just 300MB, that's the minimum. Start doing heavy work in SSMS or BI tools and it will chew memory. And that ignores...
March 1, 2017 at 4:30 am
When you say 'doesn't work', what do you mean?
No results?
Wrong results?
Error message?
Something else
March 1, 2017 at 3:38 am
Viewing 15 posts - 1,711 through 1,725 (of 49,571 total)