Viewing 15 posts - 1 through 15 (of 253 total)
Very good article to explain the basics.
I think it is important to have Part II for such an article, raising topics like CQRS, where SQL is used for Create /...
October 14, 2024 at 11:38 am
Understood - this is live data and users perform CRUD commands 24/7.
August 27, 2024 at 4:02 pm
likely the standard method of inserting into a new table with the column being calculated at that stage, and then one of 2 options
1 - truncate source table (remove...
August 27, 2024 at 3:21 pm
Interesting... 5 years down the road and I have the same issue with Azure SQL. Any suggestion, please?
DECLARE @stmt nvarchar(max);
DECLARE @params nvarchar(max);
EXEC sp_get_query_template...
June 25, 2024 at 3:22 pm
I found a suggestion on another site (not sure I am allowed to mention here), which is based on sys.dm_db_tuning_recommendations table:
WITH DbTuneRec
AS (SELECT ddtr.reason,
...
June 24, 2024 at 8:50 am
Not relative to the amount of data, features support is primarily your concern
if you’ve successfully tested in dev and test then apply to prod
It is a bit scary to...
April 26, 2024 at 10:20 am
Thank you for the comments. I am more concerned with Prod update. Providing Dev / Test passed with no issues, what are the steps to amend the compatibility in Prod...
April 26, 2024 at 9:13 am
Start by referencing this KB article
That was my first step. Done already. But I presume there are challenges on the actual update, especially in Prod, with 100's GB...
April 25, 2024 at 1:26 pm
Take a look at Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets & Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations from...
April 23, 2024 at 2:34 pm
List of various Ids: document ids, booking id etc. Those in turn have their respective tables.
April 23, 2024 at 8:30 am
Thank you for such a detailed reply. I have just noticed I wrote 500MB instead of 500GB - mia culpa and I apologise.
My experience from SharePoint from two last places...
April 15, 2024 at 7:27 pm
Thank you all for your help and suggestions.
October 26, 2023 at 7:44 am
Thank you all for the valuable replies, but I think this discussion diverted from my original question: why my tally table's function had worse execution plan than my...
June 14, 2023 at 6:22 pm
Thank you all for the valuable replies, but I think this discussion diverted from my original question: why my tally table's function had worse execution plan than my colleague's simple...
June 14, 2023 at 8:15 am
Thank you, Jonathan. Almost every step in the execution plan now marked as "No Join Predicate" and the whole function now costs 100% with my original tally one costing 0%
June 13, 2023 at 4:39 pm
Viewing 15 posts - 1 through 15 (of 253 total)