Viewing 15 posts - 26,746 through 26,760 (of 59,102 total)
Thanks, Graham, especially for the test harness. I'll check it out.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2013 at 8:04 am
My apologies for the long overdue response. I lost track of this thread.
The type of "proxy" that I was talking about isn't like the fact that multiple people login...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2013 at 7:57 am
sku370870 (5/31/2013)
Jeff Moden (5/31/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2013 at 7:21 am
dg81328 (5/31/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2013 at 6:49 am
I guess I'm paranoid about any leading index column that has very low selectivity. As most folks know, while they can really help with SELECTs, they're absolutely horrible for...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2013 at 6:16 am
Grant Fritchey (5/31/2013)
Jack Corbett (5/31/2013)
Jack Corbett (5/31/2013)
1. I can't stand ORM tools and the queries they create
2. I...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2013 at 4:22 pm
SQL_Enthusiast (5/31/2013)
The file name is like this: NAME1_NAME2_NAME3_NAME4_NAME5_YYYYMMDD_YYYYMMDDHRMMSS.YYYYMMDDHRMMSS -- Yes,...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2013 at 4:01 pm
There are NO tools that I know of that do database "documentation" correctly unless you've taken the time to document the database correctly (extended properties) to begin with. I...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2013 at 3:33 pm
Sigerson (5/31/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2013 at 3:08 pm
There might be some confusion of terms here. Are you saying that if a give IntermediaryID (I'm assuming that's the top level of the hierarchy here) has no children,...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2013 at 8:05 am
manoj.ramaiah (5/30/2013)
I have a table called Intermediary, which have some columns like
CREATE TABLE Intermediary
(
IntermediaryPK INT ,
IntermediaryID NVARCHAR(20),
IntermediaryName NVARCHAR(200),
IntermediaryTypeID NVARCHAR(1),
ParentIntermediaryID NVARCHAR(20),
IntermediaryTypePK TINYINT,
LevelID TINYINT,
ParentIntermediaryPK INT,
GrandParentIntermediaryPK INT,
GrandParentIntermediaryID NVARCHAR(20)
)
The...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2013 at 7:29 am
I guess the next question would be, why did you put leaders and followers in separate tables? It's a lot easier to manage such things if they're all in...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2013 at 7:18 am
Tyekhan (5/30/2013)
Jeff Moden (5/30/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 30, 2013 at 10:44 am
So, any feedback on my previous comment of...
Like I said, if the "Num" column is the wrong thing to consider to be unique, then we'll have to change a couple...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 30, 2013 at 7:33 am
rburko (5/29/2013)
A process inserts a parent row, then takes the identity value and puts it as the first 4 characters as part of a...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 30, 2013 at 6:58 am
Viewing 15 posts - 26,746 through 26,760 (of 59,102 total)