Viewing 15 posts - 91 through 105 (of 240 total)
I would like to see documentation on this:
When a new transaction requires a new page, SQL Server doesn't apply the 80% fill factor for new pages allocated.
I have...
February 6, 2018 at 7:33 am
Why isn't this SQL Server KB showing up in Windows Update? I feel like these have showed up there in the past, though since we're on 2008 R2 it's been...
January 18, 2018 at 7:53 am
Kaye Cahs - Friday, December 15, 2017 7:07 AMWhy is there no ContactID 4?
Isn't that where "Brett" should go?
My favorite Vikings Quarterback...
December 15, 2017 at 8:04 am
I am one of those introverts, but I also work with some people I really enjoy being around. I prefer to go to the Christmas party, eat the free dinner,...
November 14, 2017 at 8:16 am
The error I get indicates 18 bytes of internal overhead:
Msg 1701, Level 16, State 1, Line 6
Creating or altering table 'CompressionTest' failed because the minimum row...
November 13, 2017 at 7:43 am
I would like to see a reference in the answer as well. I found two different Microsoft documentation pages and neither one mentioned a 7 byte overhead.
November 9, 2017 at 7:32 am
I don't know whether dressing formal helps you work better or more professionally. I have worked in both formal and casual environments, and I much prefer casual. The place I...
November 1, 2017 at 7:59 am
I think this mostly depends on the size of the organization. If your IT department is 5 people like mine, you probably don't have a SAN admin and you need...
October 27, 2017 at 7:25 am
"By definition, the first two numbers in the Fibonacci sequence are either 1 and 1, or 0 and 1, depending on the chosen starting point of the sequence, and each...
October 20, 2017 at 9:06 am
I don't get this:
One trillion integers won't fit in an INT column so a BIGINT type is needed.
Can someone explain?
September 26, 2017 at 7:56 am
I'm curious about ON. Is that referring to the columns used in the JOIN? If so, why would that be before the JOIN?
August 31, 2017 at 9:33 am
LOL, with the Power BI update that just came out, the timing on this article is funny.
Regardless, thanks for sharing Daniel Taylor. It's great to see more Power...
July 13, 2017 at 7:31 am
Does anyone else dislike the new docs.microsoft.com documentation pages? I find them so much harder to read than the msdn pages.
June 5, 2017 at 1:27 pm
April 6, 2017 at 8:51 am
Prayer is a great way to recharge after a stressful day. Like St Augustine said, "You have made us for yourself, O Lord, and our hearts are restless until they...
March 31, 2017 at 7:44 am
Viewing 15 posts - 91 through 105 (of 240 total)