Viewing 15 posts - 6,916 through 6,930 (of 59,070 total)
If most of your indexes have a "0" (equivalent to a 100 Fill Factor) and you rebuilt or reorganized them and the tables don't have an "ever-increasing" key on all...
June 8, 2020 at 5:36 pm
p.s. If you're doing any index maintenance because of logical fragmentation on any index that has a "0" Fill Factor, you're only making fragmentation worse and, in fact, perpetuating it. ...
June 8, 2020 at 4:15 pm
I have to agree with Sergiy. I'll also add that, if it is he index maintenance job, it's usually because of the "Death by Deframentation" horror that goes by the...
June 8, 2020 at 4:07 pm
What I've found is that "Data" is always correct. "Information" derived from the data is not. And even if the "Data" is skewed, it is still correct but...
June 7, 2020 at 3:03 pm
If you really want to stress test some hardware, just migrate your existing code to it. That's when you'll find out two things... your code really is crap and all...
June 6, 2020 at 11:49 pm
What I've found is that "Data" is always correct. "Information" derived from the data is not. And even if the "Data" is skewed, it is still correct but incomplete.
I love...
June 6, 2020 at 11:37 pm
Thee are several methods for doing this but they're all too long to post here with any understanding. My recommendation is that you do a search for it and pick...
June 6, 2020 at 7:19 pm
can moderator please delete my post with all html above? I apologize for that.
It would be quicker if you just edited the post and deleted the code block with...
June 6, 2020 at 7:14 pm
I have no idea why Microsoft has kept that option in the product - auto shrink will cause massive fragmentation of the database every time it shrinks. ...
June 6, 2020 at 7:11 pm
Just to confirm, COALESCE won't provide an improvement in performance over CASE, although it will make the code a whole lot easier. Behind the scenes, the optimizer converts a COALESCE...
June 6, 2020 at 3:20 pm
I have no idea why Microsoft has kept that option in the product - auto shrink will cause massive fragmentation of the database every time it shrinks. It is...
June 6, 2020 at 2:57 pm
DECLARE @DateString nvarchar(100)='Wed Jun 29 15:57:45 2019'
SELECT CONVERT(datetime,SUBSTRING(@DateString,5,100))
I've always been astounded by the implicit conversions of strings to DateTime that SQL Server handles correctly. It seriously...
June 6, 2020 at 2:08 pm
CDC can be used in AWS RDS - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.CDC.html
but CDC does not push anything - just helps a ETL job to identify what has changed.
Got it. Thank you, good...
June 5, 2020 at 10:45 pm
Sorry I should have been more detailed in my question. The variable is the collection variable for a foreach loop which is looping through the files in a folder....
June 5, 2020 at 10:06 pm
Viewing 15 posts - 6,916 through 6,930 (of 59,070 total)