Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,896 through 41,910 (of 59,067 total)

RE: Pulling Filename from Windows directory into table

Could you post or attach rows 250 to 260 so I can see what you mean and try to duplicate the problem?
--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)

September 17, 2009 at 7:01 pm

#1055320
RE: Please review BCNF (Put things where it belongs)

Ian Scarlett (9/17/2009)
Jeff Moden (9/16/2009)
That's the whole idea behind using the surrogate key instead of a natural key which may be duplicated. The users wouldn't see it but the...
--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)

September 17, 2009 at 6:42 pm

#1055319
RE: Please review BCNF (Put things where it belongs)

Edwin-376531 (9/17/2009)
Hi Jeff,
The business rules did not allow two mobile phones in my case.
Thanks for your hints.
-Edwin
Ok and understood. So how about this? It's a bad practice 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)

September 17, 2009 at 6:20 pm

#1055318
RE: How To Efficiently Index Using a VARCHAR Column?

crainlee2 (9/17/2009)
Lynn,
I just tested Jeff's starter kit code, too. It ran in 3 seconds.
I did some testing of SELECT statements, with and without a non-clustered index on the UniqueVarChar...
--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)

September 17, 2009 at 6:12 pm

#1055315
RE: How To Efficiently Index Using a VARCHAR Column?

To the rest of you folks, I just want to say "Thanks" for backing me up. I've been under the weather and in bed for the last 18 hours...
--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)

September 17, 2009 at 6:07 pm

#1055313
RE: How To Efficiently Index Using a VARCHAR Column?

crainlee2 (9/17/2009)
Jeff, J-F, Ian, Matt,
I sincerely apologize. I'm not liable for anything I think, say, or do until after my 3rd cup of coffee in the morning. When I read...
--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)

September 17, 2009 at 5:50 pm

#1055311
RE: Please review BCNF (Put things where it belongs)

Edwin,
What happens if a person has more than one mobile phone? The way you're tables are constructed, you're pretty much screwed. The phone numbers need to be in...
--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)

September 16, 2009 at 8:38 pm

#1054794
RE: Please review BCNF (Put things where it belongs)

Ian Scarlett (9/16/2009)
What if I was to add 2 entries to your operators table, both with the name "Joe Bloggs" (but different OperatorIDs), how would your users be able 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)

September 16, 2009 at 8:35 pm

#1054792
RE: Mass transactional replication performance PLUS over a VPN

Shark Energy (9/16/2009)
It'd be quicker to BCP out the tables and copy the files over and BCP in! Surely thats not right.
Heh... Ironic isn't it? Replication uses BCP so...
--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)

September 16, 2009 at 8:29 pm

#1054791
RE: Dealing with massive amounts of data over VPN

Heh... you post after hours on the original and then post before hours on this one and wonder why there's not much traffic? Be patient my friend... 😉
Folks, the...
--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)

September 16, 2009 at 8:22 pm

#1054790
RE: Changes to data during a sproc run

I still recommend you lookup and study OUTPUT in Books Online, but here's a working example...
--===== Create and populate a 1,000,000 row test table.
-- Column...
--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)

September 16, 2009 at 8:14 pm

#1054788
RE: Changes to data during a sproc run

bill36email (9/16/2009)
That's exactly what I was doing 🙂 but I thought there had to be another way. Do you think that the Snapshot solution would incur too much of an...
--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)

September 16, 2009 at 8:00 pm

#1054786
RE: Coalesce returning 1 value only

Matt is certainly on the right track... but you don't need a CASE statement...
select A.grading, ISNULL(NULLIF(count(B.IDno),0),COUNT(B.IDno)) as myCount
From A
left join B on A.fkIDno = B.IDno and A.grading = 1
left join...
--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)

September 16, 2009 at 7:53 pm

#1054785
RE: How To Efficiently Index Using a VARCHAR Column?

crainlee2 (9/16/2009)
If you were faced with my situation, what would be the best course of action(s)?
Test and find out for sure... here's a starter kit...
SELECT TOP 1000000
...
--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)

September 16, 2009 at 7:45 pm

#1054784
RE: WORD UP!

I'm still trying to fix this. My Google search may have found something to fix it but we'll see. Here's the "fix" article I found and have instantiated...
http://support.microsoft.com/kb/928091
Once...
--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)

September 16, 2009 at 6:56 pm

#1054779

Viewing 15 posts - 41,896 through 41,910 (of 59,067 total)