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

Standard SQL Server Error log procedure

we spend lot of time trying to look at log files when we run any particular SQl files have a standard frame work to collect these errors and store in table, amkes the application management simple at same time provides some insights into exceptions over the time… 369 more words

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 …
  • 266 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