Viewing 15 posts - 31 through 45 (of 262 total)
So I would have an Ingredient table (IngredientKey, IngredientSK, IngredientName, Category, UnitPrice, ActiveDate) and then use FILTER() and/or TOPN() to get the most recent active Ingredient value relative to...
June 23, 2022 at 10:15 am
I think your Ingredient table containing the price should be set up as a slowly changing dimension (even if it changes fast). That way the Recipe fact doesn't have to...
June 22, 2022 at 10:29 am
I think the problem is that you're trying to use the same parameter for two procedures that are running concurrently. You'll need to have a separate set of parameters for...
June 20, 2022 at 11:39 am
A few things occur to me.
April 21, 2022 at 3:20 pm
The table lock was an attempt to fix a previous deadlock - on the assumption that the queries were locking different groups of rows and then needing to grab more.
There...
February 22, 2022 at 6:31 pm
Thanks for the response. I executed the queries in SSMS to obtain the actual execution plans (see attached) and they both had Degree of Parallelism = 1. The tables involved...
February 22, 2022 at 4:47 pm
Spot on, Jeff !
The main point for people to prefer varchar over char is that their GUI development tool doesn't have to bother with trailing spaces.
Lordy. I understand...
February 17, 2022 at 9:16 am
We still use CHAR in places where the length is fixed, eg. Sedol, ISIN, 2 and 3 character ISO codes for countries, currencies, etc. We also used CHAR(5) for our...
February 11, 2022 at 12:36 pm
Hardcoding as a sin is all well and good, but what do you do in the case of a date-from-date-to pair of columns? When all entries but the last...
January 12, 2022 at 12:14 pm
You don't need to create a temp table and join to it. You can have the query in a stored procedure that has a parameter which is a "user defined...
September 3, 2021 at 10:05 am
My daily commute was around 2.5 hours. The alarm still goes of at the normal time because my wife has to go into work (in a school), so I ended...
September 1, 2021 at 9:35 am
Thanks Jeffrey, I've corrected my sample code.
July 29, 2021 at 7:37 am
I agree with Jeffrey that the most likely cause is that someone has created an additional address record for the affected customer.
July 28, 2021 at 9:48 am
The pattern we use for a similar process is this.
MERGE INTO final_table
USING (SELECT key_column_1
, key_column_2
...
July 28, 2021 at 9:41 am
I've used BEGIN DISTRIBUTED TRANSACTION. I've got a control table in one database that is kept in line with a copy in another database via a linked server.
June 28, 2021 at 3:31 pm
Viewing 15 posts - 31 through 45 (of 262 total)