Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,926 through 41,940 (of 59,102 total)

RE: Gotcha with dates

Matt Whitfield (9/15/2009)
My guess (place your bets now people) is that in your UDF you are calling DateTime.Parse(). If that's the case, use DateTime.ParseExact(). Pass in null for the IFormatProvider.
I've...
--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:50 pm

#1055330
RE: CPU utilization going 100% while running a select query.

KKK-862329 (9/12/2009)
Hi,
The table has total nine Indexes. May be I have given the total indexes size. The other thing I observed from the query execution plan that the 92% cost...
--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:43 pm

#1055328
RE: Can't Import Data Fast Enough - Optimize or rethink the design?

winterminute (9/15/2009)
There are 18 columns. The 8 indexs corespond to a potential WHERE clause. I seem to recal reading that any column that could be used in a...
--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:40 pm

#1055327
RE: Are the posted questions getting worse?

Grant Fritchey (9/17/2009)
lmu92 (9/17/2009)
Now that's obviously an OP "who knows how to behave".... Calling Jeff a .... (my fingers actually refuse to retype the word and cut and paste...
--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:28 pm

#1055324
RE: Pulling Filename from Windows directory into table

fm447k (8/10/2009)
How do I email the list of filenames from the table? I'm using SQL 2005 and have configured Database Mail.
Apologies here because I don't know. They have Lotus...
--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:11 pm

#1055321
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

Viewing 15 posts - 41,926 through 41,940 (of 59,102 total)