A report might contain multiple data series on a chart, which can have considerably varying scales but common category groups. In such cases where this a big difference in scales, the data series with the lower scale can become obscured. In this tip we will take a look at how to solve this problem using Chart Areas.
With the resignation of Steve Jobs from Apple this week, Steve Jones looks back at his memories of the tech icon.
Nothing new for many developers, but I still like the way you can maintain the stack throughout the call chain.
Should we have specialists or generalists working as developers in our companies? A guest editorial today from Mike Angelastro asks the question.
The sequential nature of early data storage devices such as punched card and magnetic tape once forced programmers to devise algorithms that made the best of sequential access. These ways of doing data-processing have become so entrenched that they are still used in modern relational database systems. There is now a better way, as Joe Celko explains.
Today we have a guest editorial from Andy Warren. Andy asks if you prefer to have a strong manager or weak one, and why.
In this tip you will learn how to design aggregations for a partition and optimize it for performance.
Solution
Today Steve Jones talks about some of the issues with keeping data around a long time and a new archival medium.
A look at how the OVER clause is changing in SQL 11, based on the CTP 3 released to the public.
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers