Viewing 15 posts - 16 through 30 (of 5,109 total)
So, did anyone here get burned by the Cloudstrike debacle Friday?
We didn't but a couple vendor did. But, afterwards I was surprised one had suffered the outage when I...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 22, 2024 at 4:02 pm
Seems like you could achieve this with a couple of CTEs. I assume that the value of T_date could differ, hence why I use window aggregation functions rather than non-windowed....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 5, 2024 at 10:13 am
Create a calculated variable to hold the SQL statement you need
"Select * from BIG_view where Value_Date = '" + @ValueDate + "'"
Wouldn't it make more sense for the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2024 at 2:27 pm
So is this view using linked server queries? If so, that could well be the real problem, as such queries can often be slow, especially if the server running the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2024 at 12:27 pm
SSDT, which is just database projects (now) is installed via the installer. Open the Visual Studio Installer and then modify your Visual Studio Install to add "Data storage and processing"...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 5, 2024 at 4:43 pm
That's not possible. Old systems are shut down unfortunately.
Then, hopefully, someone can power them back on and get the keys back.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 31, 2024 at 5:06 pm
That's not possible. Old systems are shut down unfortunately.
Then, hopefully, someone can power them back on and get the keys back.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 31, 2024 at 5:00 pm
That's not possible. Old systems are shut down unfortunately.
Then, hopefully, someone can power them back on and get the keys back.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 31, 2024 at 4:59 pm
You've not provided an error and you've posted enough posts here to know we have some expectations of your post. There's nothing in your post we can use to help you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 15, 2024 at 9:05 am
Are these nested views, by any chance?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 19, 2023 at 9:28 am
It would likely be helpful for you to provide some kind of reproducible example, as that'll help us understand what's going on. Can you perhaps post some DDL for some...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 12, 2023 at 9:53 am
Dunno... I particularly like road trips for pork chop dinners. 😀
If you can supply the catapult I'm sure I can put the pork chops down as an "expense". 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 23, 2023 at 3:50 pm
Ok... let's all gather hands in a circle around Thom and repeat the DBA prayer with me...
I'm not sure the strength will help me as it's likely to be...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 23, 2023 at 3:33 pm
As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years). I get the "fun"...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 23, 2023 at 2:49 pm
This does actually sounds like your data does have line breaks and/or carriage returns at the end of the data but you aren't seeing them. Perhaps you're copying the data...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 26, 2023 at 7:36 am
Viewing 15 posts - 16 through 30 (of 5,109 total)