Common table expressions and circular references
Finding circular references that are stopping your CTE from working.
2013-09-02 (first published: 2011-01-31)
19,896 reads
Finding circular references that are stopping your CTE from working.
2013-09-02 (first published: 2011-01-31)
19,896 reads
Take your peers out of their comfort zone and do you know how well they'll perform?
2010-07-08
325 reads
2009-02-12
6,839 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers