A Handy function

If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...

How to Fix Latch Problems when Working with Ascending Keys in SQL Server

Traditionally, we want our Clustered Index to have the following attributes:
Narrow: So that our clustered index and the non-clustered indexes that point...

Kill–use this weapon carefully in SQL SERVER . TIP #90

When we heard “Kill” then first impression of this word is very bad. We always scare with this word.
In...

Presenting for Omaha SQL Server Users Group Wednesday

I am pleased to be presenting a highly interactive session tomorrow evening that is a full end-to-end setup and management...

Simple-Talk Article

In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated...

Speaking on Streamlining SQL Server Implementations Across Organization - Silicon Valley!!

Speaking on Streamlining SQL Server Implementations Across Organization - Silicon Valley!!

Speaking on Streamlining SQL Server Implementations Across Organization - Silicon Valley!!

Speaking on Streamlining SQL Server Implementations Across Organization - Silicon Valley!!

Speaking on Streamlining SQL Server Implementations Across Organization – Silicon Valley!!

In this session Prakash will walk through the process implemented to alleviates many of the pain points for deploying, managing,...