While analyzing performance of queries we may need to find out the amount of time taken by SQL queries. In order to find the exact amount of time taken by queries, we should clear the SQL Server buffers that cache the data and store procedure execution plans . The following two commands clear SQL Server …
All of us would be aware of RULES in SQL Server. A RULE is very similar to a check constraint; however there are few differences between them. Most of the articles in web would have covered how to create a rule, bind a rule to table columns, and unbind the rule and dropping it. But …
How To Check If A Rule Is Bound To A Column In SQL Server 2000 And SQL Server 2005 Read More »
