Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,801 through 46,815 (of 59,101 total)

RE: Poor Performance : Select count(*) takes 30 Mins ? Why ?

Sorry... I missed the fact that you were doing a count on the table... not returning rows... Got a PK or any decent indexes on the table?
--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)

December 4, 2008 at 7:15 pm

#908038
RE: performance while importing data

I never import directly into the final target table... I always use a staging table. That way, I can do validity checks before the new data actually get's added.
If...
--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)

December 4, 2008 at 7:12 pm

#908037
RE: SQL Query not returning records for today

SELECT RIGHT(GETDATE(),7)
--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)

December 4, 2008 at 7:07 pm

#908036
RE: Poor Performance : Select count(*) takes 30 Mins ? Why ?

No chance of using indexes... it's gonna return the whole table. How many rows are in the table? Also, are you sure it's a table and not 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)

December 4, 2008 at 6:45 pm

#908034
RE: Daily/Weekly reports for developers and app owners...

I tried sending server health reports to developers, once. The response was, "I already get enough email... would you stop sending these to me?" 😉
--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)

December 4, 2008 at 6:00 pm

#908031
RE: Convert Rows to columns so...

fausto usme (12/4/2008)
>>What about column names? With an indeterminate number of rooms, figuring out what to name the columns dynamically becomes an issue.
Exactly, the rooms in this hospital are...
--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)

December 4, 2008 at 5:54 pm

#908030
RE: Convert Rows to columns so...

Heh... No matter where it's done, I'll still like to know why the BA thinks that listing an unknown number hospital rooms horizontally is the right thing to do on...
--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)

December 4, 2008 at 5:43 pm

#908029
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

mtassin (12/4/2008)
However, the Cross-tab tool in it allows for incredibly flexible cross-tabs and is as easy as using Excel's Pivot table stuff.
Does that mean you're using the cross-tab tool 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)

December 4, 2008 at 3:53 pm

#907987
RE: Convert Rows to columns so...

The question is still important because it will determine how the columns in the table are named and a couple of other things like whether to use A VARCHAR(8000) or...
--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)

December 4, 2008 at 6:57 am

#907548
RE: Recommended path for advanced training?

Oksana March (12/4/2008)
Dear Jeff Moden,
Please reveal the secret to me! What is the RBAR/Cursor question??? 🙂
When is it ok to use it... correct answer is NOT "When you think there's...
--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)

December 4, 2008 at 6:27 am

#907510
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

IntellectYog (12/3/2008)
Jeff Moden (12/2/2008)
Comments posted to this topic are about the item
Hello Jeff,
Thansk for a nice articles on Cross-Tab.
I have one report format which is related to Dynamic...
--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)

December 3, 2008 at 11:02 pm

#907367
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

ZA_Crafty (12/3/2008)
Well Indexes I still do in the procedures. Mostly our procs are just glorified selects, and we let sql decide which indexes to use, but on a few reports...
--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)

December 3, 2008 at 10:55 pm

#907363
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

As usual, one'n'all, I'm humbled by your great feedback and suggestions. The exchange of ideas in these article discussions is the thing I look forward to the most.
With 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)

December 3, 2008 at 10:22 pm

#907345
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

ZA_Crafty (12/3/2008)
Great Article.
Mostly we youngsters like to do the cross tabs in crystal. Yep, Crystal can be a pain with all it's bugs and "funny'isms", but a crosstab like...
--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)

December 3, 2008 at 10:13 pm

#907343
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Nicole Bowman (12/3/2008)
Jeff, thanks for another great article. Your articles are easy to understand and fun to read. I too would like an article on Analysis Services. I haven't used...
--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)

December 3, 2008 at 9:53 pm

#907337

Viewing 15 posts - 46,801 through 46,815 (of 59,101 total)