Viewing 15 posts - 151 through 165 (of 5,111 total)
This is a copy paste of this post, which is also a copy paste of this reddit post. I suggest looking at the responses there.
July 13, 2022 at 10:45 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),...
July 11, 2022 at 11:11 am
SQL Server doesn't support Natural JOINs, so what RDBMS is this for?
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...
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...
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...
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...
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...
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...
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...
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,...
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.
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...
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...
June 22, 2022 at 3:08 pm
Viewing 15 posts - 151 through 165 (of 5,111 total)