Schemas

External Article

Granting limited permissions to create views in another schema in SQL Server - Part 2

  • Article

In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.

2009-08-17

3,444 reads

External Article

Using schema binding to improve SQL Server UDF performance

  • Article

SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.

2009-03-09

4,200 reads

Blogs

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By

 Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Slip Streaming Installs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Slip Streaming Installs

Stairway to Azure SQL Hyperscale Level 4: Log Service and Transaction Management

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers