Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,646 through 48,660 (of 59,095 total)

RE: Covering index is too long, but needed ... what to do?

So... after you added the index, did you get index seeks or just scans? Also, never trust the execution plan by itself... did you turn statistics on or run...
--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)

August 23, 2008 at 1:51 pm

#862262
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Thanks, Jack...
That's really the rub of it all when you're trying to print somerthing... fixed amount of real estate limited by the fat that the print still has to be...
--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)

August 23, 2008 at 1:42 pm

#862261
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Thanks, Jeff...
--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)

August 23, 2008 at 11:34 am

#862256
RE: Performance Tuning: Concatenation Functions and Some Tuning Myths

Tom Brown (8/21/2008)
Jeff
Its brilliant. But how on earth can anyone be expected to figure out the STUFF(... WHERE ... FOR XML PATH('') Syntax - especially when there is no...
--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)

August 23, 2008 at 10:51 am

#862248
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

rog pike (8/22/2008)
Jeff writes
>Ok... show us the code that you would do it in RAC with.
Here yago.
Minimal Rac execute using standard defaults.
Nicely done... thanks.
--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)

August 23, 2008 at 10:30 am

#862244
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

DAvid (8/20/2008)
Wanted to see what the difference aggregating by scalar functions was to see how it would perform based on a native datetime so I ran
PRINT '===============...
--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)

August 23, 2008 at 10:29 am

#862243
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Matt Frowe (8/21/2008)
Hi,
Just wanted to say thanks for the great article - I myself was actually one of the noobies who posted in the forums about this sort of thing....
--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)

August 23, 2008 at 10:27 am

#862242
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

dphillips (8/20/2008)
When one wants no NULLs in the output, is it not faster to put that in the base FROM "derived table", view, or query... the same as mentioned when...
--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)

August 23, 2008 at 10:23 am

#862241
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

dphillips (8/22/2008)
I wanted to retract with Jeff Moden before posting this publicly, but his mailbox here is full.
You can always send me an email. My PM on SSC is...
--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)

August 23, 2008 at 9:51 am

#862238
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

dphillips (8/20/2008)
When one wants no NULLs in the output, is it not faster to put that in the base FROM "derived table", view, or query... the same as mentioned when...
--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)

August 21, 2008 at 12:15 am

#861036
RE: BEGIN and END in stored procedure

Sergiy (8/20/2008)
Tomm, I believe this version of the code
create procedure procname
as
BEGIN
statement 1
statement 2
...
statement n
END
grant execute to procname to role1
grant execute to procname to role2
go
would change nothing and users would still...
--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)

August 20, 2008 at 8:23 pm

#860989
RE: BEGIN and END in stored procedure

Tomm Carr (8/20/2008)
But this would:
create procedure procname
as BEGIN
statement 1
statement 2
...
statement n
END
grant execute to procname...
--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)

August 20, 2008 at 8:22 pm

#860987
RE: MAX() Function Call from Application

Indexed view materializes the SUM just as if it were in a table... except you don't have to worry about whether it's up to date or not. Just having...
--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)

August 20, 2008 at 7:54 pm

#860985
RE: Debugger For SQL

Carl Federl (8/20/2008)
In reply to Jeff Moden's question: Under the "union all" solution, there are no "parameter", just SQL Statements that are sent to the server in the normal manner...
--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)

August 20, 2008 at 7:42 pm

#860984
RE: The Basics of Sizing a SQL Server Database

Wayne West (8/20/2008)
Alin Winters (8/20/2008)
Also, you should consider running a 64 bit installation, so you need x64 capable CPU's, 64 bit OS, and 64 bit SQL.
Check out this article by...
--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)

August 20, 2008 at 7:38 pm

#860983

Viewing 15 posts - 48,646 through 48,660 (of 59,095 total)