SQL Server Archives - Discount Windows ASP.NET Hosting

SQL Tutorial : DATETRUNC New T-SQL Enhancements in SQL Server

Craig Johnson1 month ago06 mins

This post will explain the operation of the recently introduced DATETRUNC function, provide some useful examples, and discuss how it varies from more conventional data manipulation techniques. The purpose of this article is to help SQL developers, DBAs, and data engineers learn how to take advantage of this new feature in SQL Server 2022. Understanding…

SQL Server

Performance Tips for SQL Server Maintenance

Craig Johnson2 years ago2 years ago09 mins

Many organizations fail to update their SQL Servers, leaving them at risk for downed systems, data breaches, and poor performance. SQL Server Maintenance: Performance Two routine maintenance areas that are often overlooked are statistics updates and index maintenance. Statistics Updates SQL Server provides a default feature that will auto-update the server’s statistics. Statistics in SQL…

What are Different File Extension in .NET?

How to Create Field Customizer Extension?

How to Use .NET MAUI Custom Fonts?

Visual Studio 17.8: Transforming Developer Experience

ASP.NET 8 Introduces a New Authentication and Authorization Mechanism

Cache Busting Angular Builds in 7 Minutes

SQL Server

SQL Tutorial : DATETRUNC New T-SQL Enhancements in SQL Server

Performance Tips for SQL Server Maintenance