MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will try to give information about the version information and cumulative update status in SQL Server. In SQL Server, in some cases, you may want to know the version information and batch cumulative status. You can easily do this using the codes below. SELECT...
Hello everyone, In this article, I will try to give information about finding CPU count and CPU core count in SQL Server. In SQL Server you may want to find CPU Count and CPU Core count with TSQL codes in some cases. You can easily do this using the codes...
Hello everyone, In this article, I will give information about listing the failed jobs in SQL Server. In some cases, we may want to list the jobs that are not running successfully in SQL Server. You can easily do this with the help of the code below. SELECT @@SERVERNAME ServerName,...
Hello everyone, In this article, I will give information about listing all the indexes in the database in SQL Server. In SQL Server, in some cases, we may want all index values in the database to be listed. You can easily do this with the help of the code below....
Hello everyone, In this article, I will provide information about pulling a filename from a file path in SQL Server. In SQL Server, in some cases, we may want to extract the file name from the file path information. You can easily do this with the help of the code...
Hello everyone, In this article, I will provide information about the function that clears the trailing part in an article in SQL Server. In SQL Server, in some cases, we may want to clear the trailing part of an article. You can easily do this with the help of the...
Hello everyone, In this article, I will provide information about checking the status of SQL Server services in SQL Server. In SQL Server, in some cases, we may want to check the status of SQL Server services, whether they are running or not. You can easily do this with the...
Hello everyone, In this article, I will give information about the function that controls weekdays in SQL Server. In SQL Server we may want to check the weekdays in some cases. You can easily do this with the help of the function below. CREATE FUNCTION CheckYourWeekdays ( @Date DATE )...