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

Sql server datacollector issue specified @collector_type_uid is not valid in this data warehouse

Executing the query “{call .(?, ?, ?, ?, ?, ?…” failed with the following error: “The specified @collector_type_uid (14AF3C12-38E6-4155-BD29-F33E7966BA23) is not valid in this data warehouse.”. 160 more words

Database Design - SQL Server 2008, 2008R2 & 2012

Data Cube: A Relational Aggregation Operator : Microsoft research paper

Very nice article on group by clause , how it works and what are its limitations and how can we overcome with a CUBE operator… 167 more words

Database Design - SQL Server 2008, 2008R2 & 2012

How to summarize your data using ROLLUP and CUBE in TSQL

We all know when reporiting any financial or sales information adding sub totals and grand totals to report makes it more effective but most offten develop0rs dont realize TSQL provides a effective way in doing this is using rollup and cube operators in group by clause. 177 more words

Database Design - SQL Server 2008, 2008R2 & 2012