Tags » Database Design - SQL Server 2008, 2008R2 & 2012

How to FIX: Manage Orphaned users in SQL SERVER with a simple script

Using below scripts

  • Fixes all orphaned users in the current database if a login exists
  • If a login does not exist in thesql server instance …
  • 271 more words
Database Design - SQL Server 2008, 2008R2 & 2012

How to fix: Access to the remote server is denied because the current security context is not trusted SQL Server

You are seeing this error because you are trying to impersonate or  switching the execution context using EXECUTE AS clause and Executing a RPC on a linked server… 84 more words

Database Design - SQL Server 2008, 2008R2 & 2012

One of the best SQL Server Index Internals: A Deep Dive

its from Tim Chapman, one of the best index internal presentation

I will try to highlight the things he talk through this presentation

Indexes

  • Clustered vs Non clustered and filtered indexes…
  • 75 more words
Database Design - SQL Server 2008, 2008R2 & 2012