Viewing 15 posts - 1 through 15 (of 130 total)
Thanks so much for the feedback and corrects. I have updated it. I'm sure it sill reflect once the changes are approved.
June 13, 2020 at 7:19 am
Absolutely profound. I think it also speaks to the difference between buying an asset and buying a liability as often talked about by Robert Kiyosaki. An asset produces generates revenue,...
May 21, 2020 at 2:18 pm
It's great to see this article! I'm going to sit this pie fight out though. Two items I would toss in fwiw:
May 21, 2020 at 2:13 pm
There is one things that could probably be added to this. An identity is incremented when an attempt to insert is performed. Even if the insert fails, the identity...
May 21, 2020 at 2:10 pm
Plan Guides. I have never used them either. Sounds intriguing.
Thanks Sir for the article.
November 12, 2019 at 10:13 am
Thanks for the article. 1 Trillion rows caught my attention. How would you compare and RDBMS row to a NoSQL row. Can I consider a NoSQL "row" as a single...
September 2, 2019 at 8:39 am
Inspired to see you never stop learning and teaching new technology, Steve.
When I first used SQL Server on Linux, I noticed SSMS on my machine didn't render the Linux directories...
July 18, 2019 at 8:39 am
I think by default,table data is separated into Hot Data(that is frequently accessed)...
January 16, 2019 at 7:13 am
I may have missed this in the article but what determines what rows stay on prem and what rows stay in the cloud by...
January 15, 2019 at 10:37 pm
January 15, 2019 at 10:29 pm
Thanks very much for the article. The performance differences captured and quite impressive.
Wondering whether we can "LAG to more than one row behind" (haven't looked at the syntax...
January 14, 2019 at 2:25 pm
January 3, 2019 at 2:59 pm
January 3, 2019 at 2:58 pm
January 3, 2019 at 2:56 pm
Great Article. Particularly loved the trace flag tips.
Wondering about two things though:
1. Can we set optimize for ad-hoc workloads simply because we have a large database?...
June 11, 2018 at 2:45 am