Free Subscription
Visual Learning
SQL Release Updates
Jobs
Next Generation Database
Big Data Tool
DWH Design Tips
Author Archives: Ayyappan Thangaraj
Override server-wide query governor cost limit in the current session – SET QUERY_GOVERNOR_COST_LIMIT – SQL Server
Query governor cost is used to set the maximum time period for queries to execute in SQL Server. This limit varies between different SQL queries and it decided by query execution plan with hardware configuration. This cost value usually refers … Continue reading
Posted in SQL Server
Tagged #SQLSERVER, @adolfayyappan, QUERY_GOVERNOR_COST_LIMIT, set, set statement, sp_configure, SQL Server, SQLRider, sqlserverrider
Leave a comment
Parsing SQL statements – SET PARSEONLY – SQL Server
SET PARSEONLY: This set statement configure the current session to parsing only mode. So, it parses all the sql statements given by the user. But, If there is an error in the syntax of the statements, it will throw an … Continue reading
Posted in SQL Server
Tagged #SQLSERVER, @adolfayyappan, set, SET PARSEONLY, SQL Server, sql server rider, SQLRider, sqlserverrider
Leave a comment
Preventing numeric rounding data loss – SET Numeric_RoundAbort – SQL Server
NUMERIC_ROUNDABORT : This set statement configure error event for the current session to avoid numeric value rounding data loss. If we set numeric_roundabort to on then SQL server session returns an error message after a loss of precision occurs and if … Continue reading
Posted in SQL Server
Tagged #SQLSERVER, @adolfayyappan, NUMERIC_ROUNDABORT, set statements, SQLRider, sqlserverrider
Leave a comment
Compile SQL satements without execution – Set Statements – SQL Server
SET NOEXEC: This set statement configure the current SQL session to compile only mode. It helps developers to validate the syntax of the query and transact-sql by compiling the code and it will not execute. Usage SET NOEXEC ON or … Continue reading
Posted in SQL Server
Tagged #SQLSERVER, @adolfayyappan, set, SET NOEXEC, SQL Server, SQLRider, sqlserverrider
1 Comment
Stop showing row count information for the current session – SET Statements – SQL Server
SET NOCOUNT: This set statement tells SQL Server to show or hide the number of row affected by the transact SQL or stored procedure or any other statement that returns rows affected by the last executed SQL statement. But, It … Continue reading
Posted in SQL Server
Tagged #SQLSERVER, @@RowCount, NOCOUNT, set, set statements, SQL Server, sql server rider, SQLRider
Leave a comment
