Viewing 15 posts - 676 through 690 (of 49,571 total)
November 1, 2017 at 1:03 pm
Regarding your earlier question about a version of SSMS for Linux, announced this morning was SQL Operations Studio (aka Project Carbon), a cross platform SQL client for Windows,...
November 1, 2017 at 12:54 pm
October 31, 2017 at 10:10 pm
October 31, 2017 at 9:02 pm
Something or someone is rebuilding the indexes and removing compression, or dropping and recreating the indexes without compression.
Put some auditing in place on DDL statements and identify where...
October 31, 2017 at 12:32 pm
Then you're looking at a sliding window scenario. There's lots of documentation available on how to do that.
October 31, 2017 at 11:38 am
If you're after better performance, don't waste your time. Partitioning is not for performance, it's for data management, fast loads, fast deletes.
If you want to be able to...
October 31, 2017 at 11:23 am
Do you mean that you're looking at a later date and seeing the indexes as uncomressed (Compression = None)?
October 31, 2017 at 11:21 am
Once you've got SP1, then partitioning is the same as for Enterprise edition.
That said, why are you considering partitioning? What's your goal?
October 31, 2017 at 10:25 am
October 31, 2017 at 10:24 am
tommyleo - Tuesday, October 31, 2017 1:40 AMCan you reccomend off-the-shelf database?
Application, not database. Application will be a combo of forms,...
October 31, 2017 at 10:19 am
October 30, 2017 at 7:21 pm
October 30, 2017 at 7:07 pm
October 29, 2017 at 10:23 pm
Interesting. Looks like they back-ported it down to 2014 in SP2. Kinda unexpected.
What's SELECT @@Version on that server?
October 29, 2017 at 9:24 am
Viewing 15 posts - 676 through 690 (of 49,571 total)