Viewing 15 posts - 5,176 through 5,190 (of 59,068 total)
It'll be interesting when someone realizes the mistake they made my omitting the parentheses from the "decimal" notations and either includes them in the future or decides to remove them...
May 31, 2021 at 12:49 am
To be honest, I'd love to go back to the good ol' days where the closest thing to a computer in a car was intermittent wipers and cruise control. It...
May 31, 2021 at 12:26 am
Like Granny used to say, "Mind the pennies and the dollars will take care of themselves". 😀
In this case, I'd concentrate on the tables that need to be PITted. The...
May 31, 2021 at 12:13 am
If the last_access column is null then no reads or writes have occurred:
WITH cte AS (
SELECT database_id, dt, op
FROM sys.dm_db_index_usage_stats
UNPIVOT (dt for op in (last_user_lookup,...
May 30, 2021 at 11:54 pm
The table does not have an index that I can use to speed up the join
This is why I previously posted what I did. There are sometimes "tricks" that...
May 30, 2021 at 11:42 pm
I suppose you could use a Factless Fact Table as a "bridge" or "join" table for this type of thing but what I recommend is paying real close attention to...
May 30, 2021 at 11:25 pm
You do realize that you're missing a single-quote in that, right?
May 30, 2021 at 4:44 pm
Shifting gears a bit, here' a search that will lead you to many different fairly easy methods of doing simple things in HTML from T-SQL.
https://duckduckgo.com/?q=create+html+table+in+t-sql&ia=web
You can easily get a...
May 30, 2021 at 12:32 am
There doesn't appear to be any information in any of the tables that associates a given CarID with an invoice. The closest thing to that is the InvoicesCostCenterAllocations table but...
May 28, 2021 at 8:49 pm
Jeffrey Williams is spot-on with his post above. I'll add that you should post the example data in a "Readily Consumable Format". Please see the article at the first link...
May 28, 2021 at 7:17 pm
Reported in The Economist just last week: "Working 55 hours or more a week is 'a serious health hazard' according to the World Health Organisation, in a first global...
May 28, 2021 at 7:08 pm
I suspect that there's some pretty nasty accidental many-to-many joins based on the account number and date. Take a look at the article at the 2nd link in my signature...
May 28, 2021 at 1:52 pm
I realise that I am a bit late to the party. The percentage increase is one that many people get wrong.
When I demonstrate similar issues, I like to use...
May 28, 2021 at 12:54 pm
I'll go one step further... stop using REORGANIZE except to compress LOBs and then make sure that you do a REBUILD right after because it also compresses the indexes. It...
May 28, 2021 at 12:15 am
Viewing 15 posts - 5,176 through 5,190 (of 59,068 total)