The KEEP PLAN query hint changes the recompilation thresholds for temporary tables, and makes them identical to those for permanent tables. Therefore, if changes to temporary tables are causing many recompilations, this query hint can be used. Related posts: Using Covering Index Best Practice No.1 Best Practice No.3
Disable xp_cmdshell unless it is absolutely required. No related posts.
I’ll be delivering a Webcast on AlwaysON in the new Lunch Time series. Lunch Time is a new talk series scheduled for every alternate Wednesday exactly during the Lunch Time. And the presenters of this talk series are the Most Valuable Professionals. This would give the audience a good platform to learn from these exceptional [Read More]
Barcamp is not new to Delhi as this city hosted the first Barcamp in Asia seven years ago on 4th March 2006. This iteration of Barcamp Delhi will be 9th in the long series, and we welcome you to participate. Barcamp is a tech oriented unconference which is organized by the attendees for the attendees. [Read More]
Hi there! For the month of April, Delhi User Group brings you a chance to learn enterprise-grade Microsoft technologies like PowerShell and SQL Server. The half-day free event for professionals in Delhi NCR includes a great line-up of industry-recognized speakers. I’ll be speaking on Nuts and Bolts of Security in SQL Server 2012. Registration required [Read More]
In first part we discussed, what is Execution Context, different types of Tokens available and what all information goes into a token? We can explicitly change the execution context of the SQL Server session by attaching the EXECUTE AS Statement; the execution context of SP (stored Procedure), UDF (User Defined Function) or trigger can also [Read More]
Execution context is maintained by the login that is connected or executing the query, then it checks the permissions of the login against the currently requested query whether the login has the required permissions to perform this action or not. In SQLServer we can easily change the execution context to any login by executing the [Read More]
Principals are entities who can request access on SQL Server Resources on different levels, in other words the entities to whom you can grant Right \permission can be referred to as Principals. Every Principal has a Security Identified also known as SID, SID helps you to uniquely identify each principal. We can arrange them in [Read More]