Viewing 15 posts - 31 through 45 (of 7,465 total)
What have you tested ?
Here is an example ( but you'd still have to validate performancewise in your environment )
drop table #test
CREATE TABLE #test
...
May 14, 2025 at 1:58 pm
Check your SQLMI instance / Compute + storage / Backup section
May 14, 2025 at 9:03 am
Perplexity has a nice explenation and steps to try resolve the issue(s):
SSPI handshake failed error code 0x80090311
May 13, 2025 at 11:08 am
Hugo Kornelis provided a nice update on the Merge problem cases in Sep 2023 "an-update-on-merge"
May 5, 2025 at 7:55 am
there should not be a column with csv content in a 4 NF relational table.
Have a look at parent - child relationships in Codd's relational theory with normalforms
May 4, 2025 at 3:55 pm
Notably, your concerns are coverd by "intelligent"
Ofcourse a dba will still need to interprete and test all this .
We still do not want indexes like "[<Name of Missing Index, sysname,>]"...
April 30, 2025 at 2:39 pm
How about having SQL Server analyse and intelligently propose new indexes, based on missing indexes information in the plan cache or Query Store.
Nowadays we still have to collect all missing...
April 30, 2025 at 7:43 am
What's in a name ?
With sql accounts, anybody can use them ( provided the password is known ). And unless you build a strickt login trigger that refuses the connection...
April 25, 2025 at 12:19 pm
"The specified availability group does not contain an availability replica with specified name"
I would triple check for typing errors in the replica sql instance name.
If I'm correct, this statement should...
April 14, 2025 at 11:42 am
In "C:\Program Files\Microsoft SQL Server\nnn\Setup Bootstrap\Log" you can find more installation related information.
Using SQL Server Configuration Manager, you can check "SQL Server Network Configuration" for both instances and see if...
April 8, 2025 at 12:26 pm
This sounds like a good place for monthly partitions. The monthly switch out takes nearly zero time or resources and then the switched out part can just be dropped...
April 8, 2025 at 6:07 am
And does it work as expected during a failover and an active transaction?
Well .... first tell me what you would expect.
April 4, 2025 at 4:14 pm
yes. we see the function. but we do not have sysadmin.
SELECT roles.principal_id AS RolePrincipalID , roles.name AS RolePrincipalName , server_role_members.member_principal_id AS MemberPrincipalID , members.name AS MemberPrincipalName FROM sys.server_role_members AS...
April 2, 2025 at 11:48 am
Also keep lock escalation in mind, so you don't lock the full table during these deletes ! (and e.g. prevent inserts being able to be processed )
a while loop handling...
April 1, 2025 at 7:11 am
of course, it is obvious the gouvernement has its influence in deepseek !
I've asked it about gouvernement sensitive subjects, to which the western world may be interested in.
It started answering...
April 1, 2025 at 6:15 am
Viewing 15 posts - 31 through 45 (of 7,465 total)