2013-03-25
2,104 reads
2013-03-25
2,104 reads
Make the ad-hoc analysis of identifying potentially double-counted or sign-reversed Accounting transactions simple and painless.
2013-01-07
4,339 reads
A suggested design for creating flight schedules makes querying easy. Includes basic airport and airlines data. Get started now with this tricky query problem.
2012-12-11
15,185 reads
2012-10-02
2,646 reads
So you want to group your data for charting in Excel? Here's how, the easy way!
2012-07-31
5,370 reads
2012-07-30
2,896 reads
Some FUNCTIONs to help generate non-uniform random numbers from uniform random numbers including Normal, Multinomial, etc.
2012-07-03
10,726 reads
An n-Tuple is a combination of values from rows of a table in pairs (2-Tuple) or triplets (3-Tuple), etc.
2012-05-17
12,776 reads
When rounded detail quantities are created by an allocation, often the total must foot back exactly to the allocated amount.
2012-03-19
5,857 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers