This challenge is related a scheduling problem in the home health care industry. The task is to look into the schedules of nurses and identify any overlapping schedules.
2010-04-05
2,580 reads
The concluding part of the Oracle / SQL Server comparison looks at error logging, security, installation and finally querying the databases.
2010-04-02
3,828 reads
A deep dive into the implementation of indexes in SQL Server 2008 R2. This is information that you must know in order to tune your queries for optimum performance. Partial scans of indexes are now possible!
2010-04-01
8,196 reads
Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it.
2010-04-01
2,611 reads
2010-04-01
3,279 reads
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-31
1,271 reads
Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.
2010-03-31
2,478 reads
Replication is a great technology for moving data from one server to another, and it has a great many configuration options. David Poole brings us a technique for scaling out with multiple distribution databases.
2010-03-30
11,211 reads
Part III of the Oracle / SQL Server comparison looks at the configuration options for each database, their storage options as well as the startup and shutdown procedures.
2010-03-30
4,344 reads
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
2010-03-30
3,661 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers