Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,586 through 27,600 (of 59,101 total)

RE: Antipathy for Entity Attribute Value data models

David.Poole (2/1/2013)
@jeff, it sounds as if you should write a counterpoint article for EAV.
I kind of did already.
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/Crosstab/65048/
Admittedly, they're at the 100 level but they provide a decent start to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 1, 2013 at 6:42 pm

#1583622
RE: Datetime compare with specific time

Kasinathan (2/1/2013)
Hi i need to calculate the TAT in my application.
Heh... I hate to ask. What's a "TAT"?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 1, 2013 at 6:35 pm

#1583620
RE: I need to read the xml which is passed as an variable in stored procedure ?how to achieve that ?

@maida_rh,
I have to ask. If you're using SQL Server 2008, why do you insist on using OPENXML?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 1, 2013 at 6:29 pm

#1583619
RE: Duplicate Names, but Not Duplicate IDs

30 rows on a table variable isn't enough for a performance test but I do like your second solution, Lynn.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 1, 2013 at 6:02 pm

#1583616
RE: Lost desktop pc

Lynn Pettis (1/31/2013)
And no, it didn't go missing. It just died with a loud pop. Could be the power supply, the system is 8 years old.
Question for those...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 31, 2013 at 11:32 pm

#1583269
RE: Are the posted questions getting worse?

jasona.work (1/31/2013)
Jeff Moden (1/30/2013)Detroit? Do you attend the local PASS meetings? Do I know you and am just missing the connection?
I've not (yet) attended any of the local...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 31, 2013 at 11:27 pm

#1583268
RE: 10 physical disks available - best configuration for data/log/backup?

What about TempDB, an archive, and a spare? 10 Drives doesn't seem to be enough even if TempDB is on DAS (which would mess with clustering if you went...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 31, 2013 at 7:40 pm

#1583251
RE: Antipathy for Entity Attribute Value data models

David.Poole (1/31/2013)
@jeff What sort of size, scale and traffic are you putting through your EAV models?
Some of the tables got quite large (several million rows). The post just...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 31, 2013 at 5:27 pm

#1583236
RE: Antipathy for Entity Attribute Value data models

BillyJack (1/31/2013)
Jeff Moden (1/30/2013)
It is a bit wicked, though. How are you handling similar but different attribute names for the same thing? For example, in address related data,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 31, 2013 at 12:08 pm

#1583131
RE: Are the posted questions getting worse?

jasona.work (1/30/2013)
Chad Crawford (1/30/2013)
I have to share my excitement. I taught a class here at work to help employees prepare for the Microsoft 70-461 test. So far...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 30, 2013 at 4:22 pm

#1582730
RE: URGENT T- SQL QUESTION. NEED HELP.

Mr. Kapsicum (1/30/2013)
Mr.Jason;
SELECT * FROM TBLCOLOR
WHERE COALESCE (COLOR, '') = COALESCE (@COLOR, COLOR, '');
in this query coalesce(@color,color,'')
the field color is always not null then how can we compare ''.?
and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 30, 2013 at 8:29 am

#1582627
RE: Looking for an aggregate function but can't get it quite right.

Actually, for the data given, the correct answer is 29 because of project 4.
SELECT Total = SUM(d.Qty)
FROM (
...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 30, 2013 at 8:24 am

#1582621
RE: My SQL Server Database is Corrupt - Now What?!

I'm one of "those" people that kept saying that there were a million articles on how to determine if corruption had occurred and very few on what to do about...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 30, 2013 at 7:47 am

#1582608
RE: Antipathy for Entity Attribute Value data models

lnardozi 61862 (1/29/2013)
Now I'm really curious. What does changing a table structure have to do with SQL programming skills?
--Jeff Moden
I'm sure you've seen this hundreds of times before - you're...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 30, 2013 at 7:06 am

#1582596
RE: Antipathy for Entity Attribute Value data models

BillyJack (1/29/2013)
Jeff Moden (1/28/2013)
Heh... wait a minute now. Are you saying that you work in an environment where developers can make physical table changes directly in the production environment...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 30, 2013 at 6:44 am

#1582588

Viewing 15 posts - 27,586 through 27,600 (of 59,101 total)