Recently one of my friend was doing some investigation in a new/unknown database and had really hard time locating the primary key – foreign key relations. Like it’s really tough to locate these relations when not enforced at database level in terms of primary key and foreign key constraints. But generally all database developers keep […]
2011-09-14 (first published: 2007-08-15)
2,784 reads
Delete files on a fileshare leaving behind files not older than n-days.
2011-09-13 (first published: 2008-04-02)
10,059 reads
2011-09-12 (first published: 2011-09-02)
1,509 reads
2011-09-09 (first published: 2007-11-19)
8,936 reads
Script one or all roles in a database. Includes users, obect permissions and column permissions.
2011-09-08 (first published: 2008-01-08)
5,266 reads
Generate the scripts that will allow you to compare tables pass/fail.
2011-09-07 (first published: 2007-12-28)
12,597 reads
2011-09-06 (first published: 2011-08-13)
1,978 reads
2011-09-05 (first published: 2007-01-25)
3,951 reads
This function returns the difference between the date in text format
2011-09-01 (first published: 2011-08-30)
1,039 reads
2011-08-31 (first published: 2011-08-24)
2,547 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
Comments posted to this topic are about the item BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers