4-4-5 Calendar Functions, Part 1
New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.
2010-09-06 (first published: 2009-09-28)
24,355 reads
Articles
TSQL Challenge 38 - Calculate SQL Stars awarded to the Winners of TSQL
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string.
2010-09-06
1,475 reads
Rebuilding Indexes using the SSMS Database Maintenance Wizard
Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. the Rebuild Index task of the SSMS Database Maintenance Wizard drops and rebuilds every index in a database. It is effective but an off-line activity that is resource-intensive, so it not always the best way of avoiding index fragmentation in a production database. Brad explains..
2010-09-06
3,710 reads
Introduction to SQL Server Statistics
A free virtual chapter presentation by Andy Warren on Sept 7, 2010 at 12:00EDT. This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more!
2010-09-03
4,089 reads
Sending scheduled SQL query results via HTML e-mail using SSIS
Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.
2010-09-03 (first published: 2008-04-23)
58,969 reads
SQLBits - The 7 Wonders of SQL
Last day for early bird registration for the next SQLBits conference on Sept 30th-Oct 2, 2010 at York University. SQLServerCentral has a discount code if you'd like to attend.
2010-09-03 (first published: 2010-07-29)
4,121 reads
Automatic Restart of SSIS packages after Failover or Failure
SSIS makes it possible to minimize work lost by starting after the last successfully executed control flow task upon restarting a failed package. From there, one challenge many seek to overcome is automatically restarting that package at that point without any manual intervention. This would make it possible for your SSIS packages to be running, your cluster to failover, and your SSIS packages to restart and complete without you having to respond to the failover and restart them.
2010-09-03
2,181 reads
SQL or MDX query trace in SSRS - trick of imagination or a real thing?
I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...
2010-09-03
2,456 reads
SQL Saturday #50 - East Iowa
Come to a SQL Saturday in Iowa City on Sept 18, 2010 and get a free day of training from the SQL community.
2010-09-03
954 reads
Restricting SecurityAdmin on SQL Server 2005/2008
Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.
2010-09-02
6,447 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
How do I explain that SQL Server should not be used as a code repository?
This week my BI Developer colleague proudly showed me a new Power BI report...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers