Viewing 15 posts - 1 through 15 (of 21 total)
After reading this article, I'm left with more questions.
What I took away was "It is important" and "set it to 75%".
But I wonder:
-why 75%? is this MSFT guidelines on this? ...
December 27, 2023 at 8:45 pm
Agreed! The goal is not 'pretty' , but 'have I communicated what is important?', and sometimes the 'boring' does the job better. Yes, there are days when I wish I...
August 22, 2022 at 7:19 pm
I'm in the same boat.
Activity Monitor in SSMS comes up... and the graphs at the top start to populate with data, but then they shop.
I never get any...
August 24, 2017 at 3:31 pm
Perfect post!
This is exactly what I faced...
A Business Intelligence installed by SQL Express 2008 R2, which won't work to open/read/create SSIS packets...
which can't be re-installed by a...
November 23, 2016 at 4:01 pm
ask the deep questions,
massage the data,
coax out of it what others can't get to,
it's my job to know the database structure, where the data are coming from, where they...
September 26, 2016 at 1:01 pm
Bob:
Love it! so elegant.... thanks for sharing.
Peter A.R. Johnson
Data Therapist
Federal Way Public Schools
Federal Way, WA
September 26, 2016 at 9:43 am
My self appointed title is
DATA THERAPIST
It allows me to spark some interest in the greater organization, giving me a chance to promote my ability to generate visual answers, make...
October 1, 2015 at 2:19 pm
Hugo Kornelis (5/28/2015)
DataTherapist (5/28/2015)
Apparently I have NOT been around the block enough times, because this was new to me.
I would have not suspected that 1/2 is NOT .5....!
No small...
May 28, 2015 at 10:08 am
Say WHAT?!?
Apparently I have NOT been around the block enough times, because this was new to me.
I would have not suspected that 1/2 is NOT .5....!
No small wonder that folks...
May 28, 2015 at 9:27 am
TomThomson (5/26/2015)
DataTherapist (5/26/2015)
I read it to mean 'pick one answer', because it didn't say 'pick...
May 27, 2015 at 9:26 am
Ah, but I feel that all of your comments are missing the point of the question.
I read it to mean 'pick one answer', because it didn't say 'pick two' or...
May 26, 2015 at 10:30 am
There is only one FROM clause in the main query. The other FROM clauses are in sub-queries. Here is the code reformatted for better readability:
ah yes, I didn't...
May 19, 2015 at 11:36 am
I wandered into the SQL Server Newbies area to see what kinds of questions are showing up here.
If this is 'Newbie', then I'm in trouble as a full time sql...
May 19, 2015 at 9:55 am
Columnstore indexes are ordered according to the compression algorithms. Sorting would eliminate many of the performance benefits.
In addition in the create syntax you cannot specify any column, so it's impossible...
February 23, 2015 at 11:22 am
I don't understand why the 'physically stored' options is not considered one of the right answers.
What's the fine details here that I'm missing?
A clustered columnstore index is regulating how the...
February 23, 2015 at 9:51 am
Viewing 15 posts - 1 through 15 (of 21 total)