The SOME, ANY and ALL are logical operators that compare against a scalar value. This article is a simple overview of how they work.
Sample Data
[crayon-662b1de1614c6039098968/]
The SOME, ANY and ALL are logical operators that compare against a scalar value. This article is a simple overview of how they work.
[crayon-662b1de1614c6039098968/]
Sometimes SQL developers want to put some logic into their T-Sql code to check the SQL Server failover cluster configuration mode . The SERVERPROPERTY() built in metadata system function can be used to identify the failover cluster configuration. SERVERPROPERTY() function with...
Read MoreSometimes SQL developers want to put logic into their T-Sql code to check the SQL Server authentication mode. The SERVERPROPERTY() built in metadata system function can be used to identify the SQL Server authentication mode. SERVERPROPERTY() function with IsIntegratedSecurityOnly Property will return...
Read MoreThe most commonly used server configuration options are available through SQL Server Management Studio. But all the server configuration options including advanced configuration options are accessible only through sp_configure system stored procedure...
Read MoreBasic emails can be sent using below user-defined stored procedure. Before you use this stored procedure you have to create a profile and account using the Configure Database Mail Wizard which can be accessed from the Configure Database Mail menu...
Read MoreDBCC SHRINKDATABASE command shrink all data and log files for a specific database. The TRUNCATEONLY option doesn't do any compacting and just releases any free portion of the file to the OS. It doesn't do the compacting because that's what...
Read MoreBelow code will shrink 80% free space and remains 20% free for database files. DBCC SHRINKDATABASE command shrink all data and log files for a specific database. To shrink one data or log file at a time for a specific...
Read MoreWhen you performing a huge DELETE operation with or without where clauses, transaction log might take over SQL server hard disk and it might takes long time to complete. But delete in chunks: 50,000 or 100,000 rows at a time...
Read More