Viewing 15 posts - 151 through 165 (of 5,109 total)
What edition of SQL Server are you using?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 13, 2022 at 10:19 am
CUs are cumulative. You don't have to install CU's, but it's often recommended as they contain bug fixes (technically you don't have to install SP's but they are highly recommended),...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2022 at 11:11 am
SQL Server doesn't support Natural JOINs, so what RDBMS is this for?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 8, 2022 at 12:04 pm
I'd personally recommend using the normalised approach, with 1 Course column. If you needed the data in the denormalised format (too), then you could use a VIEW with conditional aggregation...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 5, 2022 at 11:03 am
Hi
Thanks for the replies !!
I saw that the latest CU ( CU16) where not installed( should have been installed by WSUS) . After I applied it the application worked...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 4, 2022 at 11:19 am
Nothing springs to mind; it's not like, for example, when the cardinality estimator was changed between 2012 and 2014. Though you could, perhaps, have the old cardinality estimator enabled in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 30, 2022 at 8:12 am
I assumed that the reason for the look was because a recent power cut borked out Firewall/Router at the office, and I get loads of HSTS and self signed certificates...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 29, 2022 at 10:55 am
I suggest you get out of the habit of writing = NULL. Instead, write IS NULL. NOT is very useful, do not discard it!
It's only an example to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2022 at 1:21 pm
This both expected and documented behaviour: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/not-transact-sql?view=sql-server-ver16#remarks
As it states, the following logic is used for NOT:
NOT(TRUE) = FALSE
NOT(FALSE) = TRUE
NOT(UNKNOWN) = UNKNOWN
As such, in your case expression you have CASE...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2022 at 12:02 pm
switchoffset (CONVERT(datetimeoffset, jobstarted), '+04:00')
But how can I get just date\time and automate the offset based on fall\winter DST
Like myself and Jeffrey touched on earlier, you'll need to use...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 27, 2022 at 3:08 pm
I tried your SQL and got an error.
Msg 319, Level 15, State 1, Line 21 Incorrect syntax near the keyword 'with'. If this statement is a common table expression,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2022 at 3:30 pm
Can you confirm the exact format of JObject? It looks like
{"View"true,"Edit"true,"Admin"true}
Is that right?
It's real fuzzy, but the colons are there. Another reason images of data are bad, Jeffs.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2022 at 3:13 pm
As it's JSON, treat is as JSON.
I can't test this, as copying text from an image isn't easy (please use DDL and DML statements in the future), but you likely...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2022 at 3:12 pm
Can you not use SSISDB? The logging available would significantly make this easier to see where things might be going wrong. The deployment method is far better than both the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2022 at 3:08 pm
Syntax like FORMAT(tab1.g, 'yyyy-MM-dd') suggests that you are "rounding" a date and time value to just the date; you would therefore be much better off just casting/converting the value to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2022 at 8:22 am
Viewing 15 posts - 151 through 165 (of 5,109 total)