Sometimes, you need to define window frame within the table on the basis of certain criteria, to pick up some specific data. Today, I was developing one report for my customer and the requirement was very simple, to find the people with minimum wage in each department. 268 more words
Tags » SQL Server
I’ve been building out some new servers with Windows Server 2012 R2 to start working on a new Microsoft SQL Server Reference Architecture on Pure Storage and after installing SQL Server 2012 and migrating the databases over to a Pure volume I figured I would run the SQL Server 2012 Best Practices Analyzer to get a report. 150 more words
It has been couple weeks since my last post and as we’re going through the end of the year frenzy at the office, I find myself having little energy or time left after work to finish up my posts (I do have a couple of other posts waiting to be finished). 987 more words
Last week there was an article on SQL Server Central about moving large tables across filegroups. This was something that I have had to do a few times over the past few years, however the data warehouse in particular was on Enterprise, so it used page compression and partitioning. 1,400 more words
This post is part of the SQL Community Project #DBAJumpStart by John Sansom.
“If you could give a DBA just one piece of advice, what would it be?” 923 more words