Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Modifying execution context in SQL Server 2005
- Tim Chapman outlines how you can use the EXECUTE AS clause to change execution context in SQL Server 2005. He then shows how you can use this clause to impersonate the owner of a table in a schema. Execution context is the identity for which SQL Server permits actions...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, Advertising & Promotion, Databases, Enterprise software, Execution context, permission, execution context, SQL Server Newsletter, Login, Procedure, Statement, EXECUTE, BaseUser, TableOwner, User-schema Separation, Marketing, Software, Data Management
- Technical articles 2007-02-12
Additional Resources
- Use hardware to partition tables horizontally in SQL
- You may not have to partition tables horizontally very often, but when the need arises, you'll need hardware resources to make it work. Get more details on horizontal partitioning. When a table grows to millions or even billions of rows, performance can be a serious problem. The...
- Tags: SQL, Servers, Databases, Arthur Fuller, Processors, hardware, server, SQL Server Newsletter, TechRepublic Inc., Table, SELECT, Enterprise Software, Software, Data Management
- Technical articles 2005-07-25
- << Previous
- page 1 of 1
- Next >>