2008-02-27 (first published: 2008-01-21)
1,031 reads
Scripts
2008-02-25 (first published: 2008-01-15)
930 reads
Sorted views in 2005 and TOP clause
These examples show how You can circumvent the problem with not working TOP 100 PERCENT and ORDER BY in views.
2008-02-22 (first published: 2008-01-22)
1,289 reads
2008-02-21 (first published: 2008-01-09)
2,006 reads
2008-02-18 (first published: 2007-12-27)
814 reads
2008-02-14 (first published: 2007-12-20)
1,035 reads
2008-02-13 (first published: 2007-12-18)
1,736 reads
Change column type on constrained columns
Use this proc if you need to alter a column that is part of a primery key
2008-02-04 (first published: 2007-12-10)
1,122 reads
2005 Clean Indexes For All Databases on a Server
Check Indexes on all databases and rebuild/reindex based on fragmentation
2008-02-01 (first published: 2007-04-05)
1,467 reads
String Tokenizer with Complex Search
Sample solution to replace string in expressions with multiple delimiters.
2008-01-31 (first published: 2007-12-05)
1,994 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers