Viewing 15 posts - 31 through 45 (of 1,987 total)
Nvarchar(max). Every now and then the developers get a reminder to review those. They sneak in when you're in a hurry.
SELECT table_schema,table_name,COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE data_type in ('nvarchar','varchar','char','nchar')
and CHARACTER_MAXIMUM_LENGTH=-1
ORDER...
June 7, 2024 at 2:13 pm
Thanks
Steve for the Json references, Phil for the validation, Frederico for the date suggestion.
My workaround is storing it in an nvarchar(max) variable, replace the wanted character and write it back...
June 3, 2024 at 3:40 pm
We're currently using to much on-premises addons (sql agent, SSRS, SSIS, linked servers). Currently spoiled with our hardware infrastructure.
If we move, it would be Azure SQL for small databases.
May 27, 2024 at 8:05 am
Kubernetes is indeed complex to setup and maintain. That's why except the odd containers we work with vm's on-premises.
The cloud can handle that complexity better behind the scenes.
May 21, 2024 at 9:21 am
Querystore could have been full at that moment, then it switches to readonly mode skipping your query.
Query store capture mode also influences what is captured. https://www.sqlozano.com/query-store-customising-your-capture-mode/
May 15, 2024 at 11:47 am
https://www.brentozar.com/archive/2012/03/how-decide-if-should-use-table-partitioning/
I'm quite hesitant to use partition because it requires maintance and good queries that support it. Maybe the odd partition swap.
As Brent usually mentions, what is the developer trying...
May 10, 2024 at 10:12 am
Recently I had the opportunity of 3 monitors and I liked it.
1 as main screen, 2 as internet browsing / compare, 3 as backgrond monitoring/email etc
May 10, 2024 at 9:20 am
The 504 gateway error is annoying. So far the posts went through
May 8, 2024 at 9:56 am
We don't have an official off hours call support duty. The occasional call may get fixed if the person feels up to it, otherwise it is postponed to working hours.
May 3, 2024 at 2:51 pm
The square ones didn't complete
https://joeydantoni.com/2016/11/02/circles-and-squares-what-do-they-mean-in-the-query-store/
May 2, 2024 at 1:15 pm
The library is open-source, you may find the information there https://github.com/codebude/QRCoder
April 29, 2024 at 9:33 am
For simple operations Standard Edition is fine. Differences can be found at https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16#choose-sql-server-features
Is the execution plan between 2008 and 2017 the same? Are they fully patched?
April 25, 2024 at 2:34 pm
If it bugchecks I would considering contacting MS Support, since you are allready on the latest CU.
April 23, 2024 at 8:44 am
Happy bunny hopping / bell watching / ... . Easter is nearby
March 27, 2024 at 4:14 pm
Viewing 15 posts - 31 through 45 (of 1,987 total)