SQL Server Education (by the geeks, for the geeks)
Hi Friends, After my performance tuning workshop for a leading bank in Gurgaon in July, it was time to train their other DBA team in Chennai. This SQL Server training assignment …
SQL Server: Completed- SQL Performance Tuning workshop in Chennai August 2011 Read MoreHi Friends, In my previous 2 posts in this series, I demonstrated how you can explore the Shape files & how you can import shape files in SQL Server databases. You …
SQL Server – Learning Spatial Stuff: Map Layer wizard in SQL Server Reporting Services 2008 R2 Read MoreHi Friends, In one of my recent assignments, one participant asked if there is any way in SQL Server to warm up the cache of with some heavily used tables to …
SQL Server DBCC PINTABLE does nothing anymore Read MoreHi Friends, In my last blog post, I explained what shape files are and demonstrated how you can explore them. You can read the post here; Continuing with my spatial series, …
SQL Server – Learning Spatial stuff – Importing shapefiles in SQL Server database Read MoreHi Friends, After my last BI training in Gurgaon, it was time for tuning performance in SQL Server. I delivered a 4 day workshop for a leading Bank & Financial Services …
SQL Server: Completed- SQL Performance Tuning workshop in Gurgaon July 2011 Read MoreHi Friends, In one of my recent trainings, I was demonstrating the map control of Reporting Services R2 to a set of audience who were new to spatial data. I spent …
SQL Server – Learning Spatial stuff – Understanding and exploring Shapefiles using Map Browser Read MoreHi Friends, CROSSJOIN is a very powerful function in MDX, returning you the cross product of one more sets. Let us see some examples: Example 1: Returns on the cross join …
SQL Server Script: CROSSJOIN in MDX – Analysis Services Read MoreDear Friends, When I completed my training assignment in last week of June in Gurgaon, I had committed that we shall be organizing a rocking SQL Server event in Gurgaon – …
SQL Server Day event in Gurgaon on 30 July 2011 rocked us all !!! Read MoreHi Friends, Here is a query and I want to create the right indexes for it. Let us do things step by step: (I am using AdventureWorks2008 for this) SELECT SOH.CustomerID, …
SQL Server: Indexing for Aggregates in SQL Server Read MoreHi Friends, Inspired by Rahul’s post, here are 2 more scripts that can help in detecting CPU pressure select top 50 sum(qs.total_worker_time) as total_cpu_time, sum(qs.execution_count) as total_execution_count, count(*) as number_of_statements, qs.plan_handle …
CPU bottleneck in SQL Server Read More