Viewing 15 posts - 4,201 through 4,215 (of 6,035 total)
Hey, it's 2015; the developer should code the application first, and then with a few clicks of the mouse they can auto-generate all the database junk in the background for...
January 26, 2015 at 11:26 am
So, deploying a new procedure, table, or column days or weeks before the associated application change is deployed? Yes, that happens all the time in my universe where the database...
January 26, 2015 at 9:00 am
Jeff Moden (1/24/2015)
Eric M Russell (1/24/2015)
I am thankful for introduction of the short Date and have made heavy use of it last few years.
Yes. I agree with that 100%....
January 26, 2015 at 8:44 am
sm_iransoftware (1/22/2015)
Feedbacks was very nice and wide
I should have read more carefully down the Answers
(specially about Hadoop and HiveSQL)
-----------------------------------------------------------
And now more details about your questions and ideas :
1- We...
January 26, 2015 at 7:59 am
I am thankful for introduction of the short Date and have made heavy use of it last few years.
January 24, 2015 at 9:33 am
Charles Kincaid (1/23/2015)
January 24, 2015 at 9:24 am
If you want to "Get IT Out of the Data Center", then send an email to the DBA team informing them that there are Chick-Fil-A breakfast biscuits and StarBuck coffee...
January 23, 2015 at 4:56 pm
ScottPletcher (1/23/2015)
TomThomson (1/23/2015)
Sean Lange (1/23/2015)
Eric M Russell (1/23/2015)
Date/Time: datetime, offset, varchar?There is only one option here. Datetime.
I suppose if your dBMS is anccient enough that's excusable. But it...
January 23, 2015 at 1:16 pm
A single SQL Server Enterprise instance running on a moderately powered server can house multiple OLTP applications for even large organizations. I've seen cases where organizations are using multiple instances...
January 23, 2015 at 10:36 am
Now on to data types.
Currency: should it be decimal, numeric, money, int?
Date/Time: datetime, offset, varchar?
Names and descriptions: varchar or nvarchar?
Unique Identifiers: int, guid, timestamp, rowid, identity, sequence? :rolleyes:
January 23, 2015 at 10:06 am
I can live with mixed naming conventions, or even no convention, so long as the name given for each column makes sense and is consistent within the scope of that...
January 23, 2015 at 9:04 am
GoofyGuy (1/22/2015)
In many businesses and governmental organisations, IT is the only part of the organisation which can provide enterprise- wide knowledge of...
January 22, 2015 at 9:21 am
I can see now this thread is going to get a lot of comment. This is one niche application where I'd suggest Hadoop and HiveSQL.
As far as doing this...
January 22, 2015 at 8:02 am
Comparing the IT department to a utility company may not be accurate for most organizations, but at least it's not as demeaning as comparing IT to a sausage factory. ...
January 22, 2015 at 7:20 am
ramana3327 (1/21/2015)
Need to change some columns datatype from nvarchar to varchar.Just need to drop the indexes that are on that column.
Do we get any problems from changing nvarchar to varchar
Yes,...
January 21, 2015 at 3:22 pm
Viewing 15 posts - 4,201 through 4,215 (of 6,035 total)