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,782 reads
Delete files on a fileshare leaving behind files not older than n-days.
2011-09-13 (first published: 2008-04-02)
10,055 reads
2011-09-12 (first published: 2011-09-02)
1,508 reads
2011-09-09 (first published: 2007-11-19)
8,935 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,265 reads
Generate the scripts that will allow you to compare tables pass/fail.
2011-09-07 (first published: 2007-12-28)
12,595 reads
2011-09-05 (first published: 2007-01-25)
3,948 reads
2011-08-31 (first published: 2011-08-24)
2,544 reads
Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).
Useful when rebuilding indexes online.
2011-08-30 (first published: 2011-08-25)
760 reads
2011-08-24 (first published: 2011-08-12)
1,164 reads
The DBA life is fraught with pain. Those battles that we endure are mostly...
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Hello, I would like to ask whether it is technically possible to redirect a...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Comments posted to this topic are about the item TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers