Viewing 15 posts - 1 through 15 (of 207 total)
Loved the analysis, one thing bothered me. Either I have a gross misunderstanding or the author said something incorrectly:
Fill factor is defined as the maximum percent of the fullness...
November 25, 2019 at 2:12 pm
Good question, and I wondered the same thing. I took the defaults when I built the volumes on the S2D Pool. This query shows that the block size is 4096,...
September 16, 2019 at 7:26 pm
March 7, 2019 at 8:49 am
I think the two most important things are a keyboard that suits YOU, and a big monitor. I use a Dell 34 inch curved monitor, and I like it so...
October 17, 2018 at 6:47 am
May 15, 2018 at 9:56 am
Can someone explain to me the difference between the horrible, trendy neoword "rearchitected" and the simple, elegant, perfectly adequate word "redesigned" please? I'm fine with folks that need an ego...
May 14, 2018 at 2:31 pm
April 11, 2018 at 10:30 am
To answer several questions:
No, we don't use a web app. Using a web service would certainly isolate SQL Server from the authentication issue, but it would just move...
March 30, 2018 at 8:22 am
I see your point if you live in a world where all your users are part of your domain. But if you serve up applications that connect to SQL Server...
March 30, 2018 at 7:20 am
January 12, 2017 at 11:12 pm
I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often. I'm wondering what...
August 14, 2015 at 12:27 pm
I agree with one poster who said that seeing examples by some of you that have used them to get set based answers, or simplify complex queries, would be very...
August 14, 2015 at 10:04 am
I'm not reading it on a tablet or a phone. You've just wasted half of my nice monitor, and made me scroll twice as much.
July 2, 2013 at 10:46 am
We ended up with a corupt msdb after a power outage. Restored the msdb backup, and noticed that emails were not going out after jobs completed. Went into...
June 30, 2011 at 3:15 pm
Add me to the list. What is the best protection, and how much (approximately) of a performance hit are we looking at?
July 20, 2010 at 7:34 am