2008-02-27 (first published: 2008-01-21)
1,029 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)
811 reads
2008-02-14 (first published: 2007-12-20)
1,035 reads
2008-02-13 (first published: 2007-12-18)
1,735 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,121 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,464 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
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers