Often the way we display our data differs from how we store it. Sales are a good example; in your table each row contains a sale. 1,093 more words
Tags » T-SQL
I have a data set that describe Sales data of all categories. Now I need to build a query to compare Sales of a given year with previous year for each category. 487 more words
It’s a confusing question / title / headline. Let’s see if I can clarify what I’m after.
For each scheduled backup job, which databases were backed up? 2,045 more words
When it comes to complex queries which contains multiple sub queries, the performance of the query tends to decrease. Apart from performance, the readability of the code also plays a huge role, specially when you have to trace back in order to refer to a certain condition or function. 335 more words