A well-earned break from the database
Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.
2017-11-27
57 reads
Holidays
The Bones of SQL - The Holiday Table
This second part to a previous article on Calendar table generation shows how to create a holiday table containing both fixed-date and variable-date holidays.
2018-12-25 (first published: 2016-09-19)
6,562 reads
RE: Case in Where with Null
- Remi what you are saying is not totally wrong, actually I consider it a good aproach but, I have done some tests of my own and your solution also cannot take advantange of the indexes.- Your solution is faster when it has a value different from null but if you use "null" the performace of […]
2005-03-02
RE: Temporary Network
Just install SQL on one of the servers, people can connect via IP or the NetBIOS name.
2004-11-19
RE: How to store phone number
We debated long and hard, but went with integer for NANP (North American Numbering Plan) numbers, and varchar for other numbers. Given the different numbering system and standards around the world, the international numbers are a mess (it's all but impossible to validate the data), while the NANP numbers are reasonably clean. P
2004-11-10
Collation Problems with BCP 8.0
Hi all, I am currently having a problem with creating a proper Bulk Insert BCP format file. Here is all of the info I have done so far:Database Name: MBLOGS_DEV ---- Table Name: AuditJournalFields: (Name, DataType, Length)1. AuditID - Numeric - 9 (Auto-Number)2. AccntNo - Numeric - 9 3. EditDate - DateTime - 84. EditTime - VarChar […]
2004-11-08
26 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers