Running on SQL Server 2008 (so views support parameters I believe). Looking for the best way to manage giving out controlled and restricted access to our data based on logins. Basic example. A table ...
When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if indexed ...
Why are there INFOMATION_SCHEMA and catalog views in SQL Server that do very similar things? For example, to retrieve a list of tables in a database, I can do it via sys.tables or ...
A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine’s system databases. Tim Chapman discusses these system databases. A fundamental skill for DBAs is to have ...
Regardless of the size of your organization, there's always a wide variety of items to keep track of in database systems like SQL Server -- user logins, data access, security protections and more.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results