Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,506 through 50,520 (of 59,091 total)

RE: Slow server in general

Returning stuff to the screen is the worst way to test this. The video systems on each may be a lot different, etc, etc. Find a better way...
--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)

May 16, 2008 at 7:42 pm

#816811
RE: Querying Same Number of Rows in 2 tables

There's no index on col1 or col2 yet you're aggregating and grouping on those.
Doing a copy into a heap and then putting an appropriate index on it would really make...
--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)

May 16, 2008 at 7:34 pm

#816810
RE: I am trying to convert rows to columns... not having much luck

Welcome aboard! Since you're new, lemme tell you that you'll get much better answers much more quickly if you do what suggested in the URL in my signature, 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)

May 16, 2008 at 7:28 pm

#816809
RE: upper and lower case pattern detection?

RyanRandall (5/16/2008)
*Note that [ABCDEFGHIJKLMNOPQRSTUVWXYZ] <> [A-Z] since [A-Z] = [AbBcCdD...zZ], confusingly!
Very nice job... You just didn't use the correct Collation, Ryan... 🙂
declare @t table (name varchar(20))
insert @t
...
--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)

May 16, 2008 at 6:47 pm

#816803
RE: A Worthwhile Goal

What's more important: quality or consistency?
The two are not mutually exclusive, nor does one spawn the other. And, if you want it done right, you won't let any time...
--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)

May 16, 2008 at 6:34 pm

#816801
RE: Data Conversion question - bad data points

wayne.mcdaniel (5/16/2008)
The cursor is for the demo, but its in the live conversion...I'm sure someone can give me the flaming kill the cursor lecture, and they're possibly right, but for...
--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)

May 16, 2008 at 6:02 pm

#816796
RE: How to random dates

Au4848 (5/16/2008)
jeff thanks alot how to use this one in striaght update
SELECT SomeDate AS StartDate,
SomeDate+1 AS EndDate
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)

May 16, 2008 at 5:50 pm

#816795
RE: Using SQL CLR to execute web services

Thomas SNyder (5/16/2008)
Just tried a 1GB file and took 1m 23sec to work,
Just curious... How many rows and columns, Tom?
--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)

May 16, 2008 at 5:44 pm

#816794
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Michael,
It'll take me a bit to digest the "Map", but very nice on the documentation! Nice to see something so well documented!
--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)

May 16, 2008 at 5:40 pm

#816792
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Ian Crandell (5/16/2008)
No, problem. I don't know why Jeff wasn't able to get it, unless they could sense who he is and realized he is so good that he...
--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)

May 16, 2008 at 5:38 pm

#816791
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Ian Crandell (5/16/2008)
Jeff Moden (5/15/2008)
Looks interesting... can't download the code, though, because I'm not a member and they want too much info for my liking.
Jeff, I was able to download...
--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)

May 16, 2008 at 5:13 pm

#816781
RE: Bulk Insert to a temorary table

jcrawf02 (5/16/2008)
Jeff, BOL says this -
Permissions
Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
If I can't convince almighty DBA to make me either, I'm...
--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)

May 16, 2008 at 5:11 pm

#816777
RE: getdate() accuracy

JacekO (5/16/2008)
PS.
Jeff,
It is Jacek not Jack. 😉
Dang... I'm so sorry... I'm usually the one who get's ticked when someone mispells "Jeff" (believe it or not, it happens). Old...
--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)

May 16, 2008 at 8:04 am

#816507
RE: Bulk Insert to a temorary table

Yes, I believe 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)

May 16, 2008 at 8:00 am

#816502
RE: Calling CLR procedures from user defined functions

ghelyar (5/16/2008)
I have a library for my application's use in ASP.net (C#) for 2 versions. The library can handle the rather complex conversion already and I would rather use that...
--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)

May 16, 2008 at 7:47 am

#816485

Viewing 15 posts - 50,506 through 50,520 (of 59,091 total)