Viewing 15 posts - 691 through 705 (of 1,353 total)
Also, are there any benefit to having multiple OLTP Database Log files
I'm also interested to hear this, but we have had a lot of success with a multiple file TempDB....
February 2, 2015 at 8:42 am
The expressions are not the same.
I agree, but no one has addressed that. The CASE statement says if null do x if not do y. The other says...
February 2, 2015 at 7:45 am
In a POS system, someting like a terminal_id (origination) + timestamp could be a natural key
I don't want to get in a back and forth about what a natural key...
January 29, 2015 at 9:34 am
In the RDMS realm, it makes more sense for a number of reasons to use a business assigned origin code and timestamp combined to form a natural key.
[Emphasis mine]
However...
January 29, 2015 at 8:27 am
This kind of sub-query is called a derived table. With the addition of CTEs to TSQL I don't know that they have much use anymore.
January 26, 2015 at 8:12 am
Given a single row that contains StartDate and EndDate columns as DATETIME2 columns, write the code to calculate the duration between those two columns and display it in the HHHHHHHH:MI:SS.mil...
January 26, 2015 at 7:17 am
Sequence - this is no different logically than an int or identity, the difference is in how it is generated.
It may not be different logically, but if it's important to...
January 23, 2015 at 11:20 am
That's a bit of a stretch. *IF* it really does stand for "Identity *Document*", then, yes, it should be ID. That's again why I strongly prefer underscores, so the word...
January 23, 2015 at 9:35 am
Why selectively capitalize just one abbreviation? Why the inconsistency?
If it involves this thing we call language, absolute consistency is elusive. As consistent as possible remains a worthy goal.
January 23, 2015 at 9:14 am
I'm still cleaning up "sp_" junk and "tbl_" notations that have become views (and vice versa) and a myriad of column names that no longer make sense that others have...
January 21, 2015 at 8:53 am
Perhaps Military ID means 'Military Identity Document' rather than 'Military Identifier', in which case the usage is perfectly sound.
Yes, I guess that makes sense. In any case, as a...
January 21, 2015 at 7:54 am
... and ID is not? What is it then?
'Id' is an abbreviation of a single word and is therefore valid, at least in standard written English.
When abbreviating 'Company', would you...
January 21, 2015 at 7:34 am
I would take issue with ID by itself, on every table
Agreed. Maybe I should have made that clear in my post.
January 21, 2015 at 7:19 am
I use ID. It's an abbreviation that otherwise doesn't form a word.
January 21, 2015 at 7:13 am
Viewing 15 posts - 691 through 705 (of 1,353 total)