MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will try to give information about learning the physical size of a table in SQL Server. In SQL Server, in some cases you may want to know the physical size of a table. We use the sp_spaceused procedure for this operation. We run our...
Hello everyone, In this article, I will try to give information about which database uses how much RAM in SQL Server. In SQL Server, you may want to know how much RAM each database uses in some cases. You can easily do this using the code below. SELECT [DatabaseName] =...
Hello everyone, In this article, I will try to give information about checking when the database was last backed up in SQL Server. In SQL Server, in some cases, you may want to check when the database was last backed up. You can easily do this using the code below....
Hello everyone, In this article, I will provide information about listing 365 days in SQL Server. In SQL Server you may want to list 365 days in some cases. You can easily do this using the code below. WITH mycte AS ( SELECT CAST(‘2021-01-01’ AS DATETIME) DateValue UNION ALL SELECT...