Tags » Dba

Sorting behavior

One of the best parts of my job is explaining database concepts to non-database folks: developers, managers, CEOs, my wife, etc. One lesson I’ve had to explain numerous times is that SQL Server doesn’t guarantee that data will come back in any given order unless you explicitly tell it to return data in a given order. 1,308 more words


Oh it's on!

They said it could never be done! Was it possible to get over twenty of the country’s top wargaming personalities to compete under the same roof? 249 more words

More minds meet at Sangam 2015...

Diary on Sangam’15
21st, 22nd Nov 2015 at Hyderabad International Convention Centre, HITEC City, Hyderabad, India

In the recently concluded two day Oracle conference – … 491 more words


Calculating Table Partition Sizes in Advance

Continuing on with my Partitioning post series, this is part 7.

The partitioning includes several major components of work (and can be linked below); 1,764 more words

SQL Server

Death by Awkward Misplaced Phrases

Just when I think I was starting to outgrow the awkward, that maybe I had moved onto a new, more sophisticated chapter of my life, I am reminded that I am still just a weird 12 year old in a 22 year old’s body. 324 more words


Sql Server : Does recompiling a procedure stop the current executions?

Quick one today:

Interesting topic today: Does recompiling procedure stop current executions of the procedure?

Of late, in our lab, we’ve been needing to run several performance tests (volume testing) to measure performance metrics under different load and traffic patterns. 233 more words


Better.....Faster....SQL Server Backups

Ever since I phased out the legacy backup system in one of my recent projects with a centralized SQL Server backup solution, I have been asked by many people regarding the results that I got from the transition. 838 more words