How to get Time from a RowVersion value with T-SQL Code
Check out this article to help you figure out real dates and times when using a SQL Server RowVersion value.
Functions
Learn SQL Server functions with practical tips, examples, and tutorials to improve querying and data analysis.
SQL COUNT DISTINCT and SQL COUNT Examples in SQL Server
This tip shows several examples of COUNT and COUNT DISTINCT to show how SQL Server handles them differently.
SELECT COUNT FROM SQL Server Examples and Statistics
Learn about the impact of using COUNT in your SQL Server queries along with several examples and statistics of how using COUNT impacts performance.
SQL Server Logarithmic Functions LOG() and LOG10() for Data Outliers
In this article, we look at how to use the SQL Server system functions, LOG and LOG10, to get logarithmic data values to be used for data analysis.
SQL Server OBJECTPROPERTY Function Examples
SQL Server objects have many different property attributes learn how to use the OBJECTPROPERTY() system function to return various data about objects.
Simplify SQL Date Calculations – First, Last, Nth Day of the Month
Learn how to easily calculate dates such as last day of month, nth Monday of month, and more both with and without a calendar tables.
SQL CONVERT, CAST, TRY_CAST, TRY_CONVERT and TRY_PARSE Examples
In this article, we look at various ways to convert problematic data in SQL Server by using TRY_CAST, TRY_CONVERT, and TRY_PARSE.
Metadata Functions in SQL Server SERVERPROPERTY, DB_NAME, OBJECT_ID
Learn about SQL Server metadata functions like SERVERPROPERTY, DATABASEPROPERTYEX, DB_NAME, DB_ID, FILE_NAME, FILE_ID, FILE_IDEX, SCHEMA_NAME and more
SQL Concatenate Strings Example
Learn how to concatenate data in SQL Server to make one long string instead of having separate columns.
Delay SQL Code Execution with SQL WAITFOR
In this article, we look at the SQL Server WAITFOR command to allow delays in processing either for a specified time or a set amount of time.
SQL COUNT and SQL COUNT_BIG Functions
In this article, we look at how to get a count of rows from SQL Server using the COUNT and COUNT_BIG aggregate functions along with several examples.
Random Date Generator in SQL Server
In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples.
SQL Server Configuration Functions
Learn about SQL Server configuration functions to return information about SQL Server, sessions, configuration settings and more.
SQL Average Function to Calculate Average of a set of SQL Server Rows
Learn various ways to calculate the average of a set of SQL Server rows using the AVG function along with several use cases and examples.
SQL Convert INT to String
In this article we cover different ways to convert a SQL Server numeric value into a string value.
SQL PIVOT and SQL UNPIVOT Examples to Transform Data
In this article learn how to use PIVOT and UNPIVOT in SQL Server to transform your data output along with examples.
SQL MAX Examples and Use Cases
Learn about the SQL MAX() function in SQL Server to find the maximum values in a result set along with several examples of using SQL MAX().
DATEADD SQL Function to Add and Subtract Dates and Times
In this article learn about the SQL Server DATEADD function to add and subtract various date parts from the date and time from a date.
SQL DATEDIFF and DATEDIFF_BIG Functions with Sample Code
In this article we look at how to determine the difference between two SQL Server dates using the datediff and datediff_big functions.
SQL Server datetimeoffset for Time Zones
In this article we look at the datetimeoffset data type in SQL Server and how this can be used to determine dates for different time zones.
SQL Date Format Comparison for Computed Column and Materialized Column
In this article we look at the impact of using the SQL Server FORMAT function along with various alternatives and comparisons.
SQL Date Format Comparison – SQL FORMAT vs. SQL CONVERT
In this article we take a closer look at the SQL Server FORMAT function and compare it to other approaches to do a performance comparison.
Learn SQL CAST Function with Examples and Alternatives
Learn how to use the CAST function in SQL Server to convert from one data type to another data type along with examples and alternatives.
SQL Convert Function In Depth
Learn about the SQL Server CONVERT function to convert to different data types as well as alternative options.