2008-02-25 (first published: 2008-01-15)
923 reads
Scripts
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,272 reads
2008-02-21 (first published: 2008-01-09)
2,000 reads
2008-02-18 (first published: 2007-12-27)
789 reads
2008-02-14 (first published: 2007-12-20)
1,022 reads
2008-02-13 (first published: 2007-12-18)
1,720 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,110 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,451 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,979 reads
2008-01-29 (first published: 2007-11-23)
1,954 reads
Blogs
Book Review – Microsoft Power BI Performance Best Practices
I was asked to do a review of the book Microsoft Power BI Performance...
SQL Server Distributed Availability Groups and Kubernetes
A while back I wrote about how to use a Cross Platform (or Clusterless)...
Introducing SQL Server 2025 - Enterprise Ready AI
Introducing SQL Server 2025 - Enterprise Ready AI SQL Server 2025 is an upcoming...
Forums
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
A Strange Result
Comments posted to this topic are about the item A Strange Result
Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing
First time here...hoping I can find some direction and answers so I can devise...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers