2008-03-09
43 reads
Articles
2008-03-09
32 reads
Forum Search Changes
Forum Searching The forum search is back, allowing you to search for specific issues in our discussion forums. There is a search link above the forum thread lists. Please report any issues to the webmaster.
2008-03-08
19 reads
Linked Server Optimization
This article demonstrates the negative affect that linked servers can cause in queries and offers alternatives to speed up performance.
2008-03-07
15,725 reads
The Truth Table
Truth tables are an important part of working with logical values in SQL Server. Yousef Ekhtiari brings us some T-SQL that can help you construct those many variable truth tables and ensure you are getting the results you expect.
2008-03-07 (first published: 2007-04-19)
11,937 reads
Using VBScript to Automate Tasks
This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.
2008-03-07 (first published: 2003-11-04)
103,009 reads
Apply Test-Driven Development to your Database Projects
This article from MSDN discusses the benefits of TDD and bringing unit testing to your database development.
2008-03-07
3,320 reads
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
2008-03-07
35 reads
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
2008-03-07
38 reads
Extending SQL Server Reporting Services with SQL CLR Table-Valued Functions
This article describes how to take advantage of SQL CLR table-valued functions to combine different types of data sources to create rich and exciting SQL Server Reporting Services reports.
2008-03-07
2,625 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers