Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,661 through 48,675 (of 59,102 total)

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
RE: Skip n rows while importing from Excel Sheet...

suresh (8/19/2008)
I am trying to load the same sample file, it is showing the Error message:
Syntax Error From Class..
Regards,
suresh
I've never seen such an error in SQL Server, so it...
--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:32 pm

#860982
RE: BEGIN and END in stored procedure

Michael Meierruth (8/20/2008)
Michael Meierruth (8/20/2008)
Jeff Moden (2/25/2008)
...Might be an ANSI standard but I always follow MIL-TP-41H, instead... 😉
I have forgiven myself for not knowing the meaning of that abbreviation. But...
--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:03 pm

#860978
RE: How to export sql server data into multiple excel sheets ?

In that case, the path to the spreadsheet should probably be a UNC that the SQL server can see... the reference to C: is for the server and won't work...
--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 6:48 pm

#860974
RE: Hidden RBAR: Triangular Joins

Thanks again, Arniban. 🙂
--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 6:29 pm

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

Anirban Paul (8/20/2008)
Another Jewel in your crown Jeff. Great article. Wonderful...:)
Thanks, Anirban. I appreciate it... 🙂
--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 6:27 pm

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

rog pike (8/20/2008)
There's nothing like seeing the latest go around of PMS (pivot madness syndrome). And it seems time after time, year after year, release after release there's a contest...
--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 6:25 pm

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

Chris Morris (8/20/2008)
Jeff Moden (8/19/2008)
Chris Morris (8/19/2008)
Really nice to read, Jeff, and absolutely spot on.
I've had to do pivots in the last couple of weeks, with an unknown number of...
--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 6:19 pm

#860962
RE: Linked Server Pros/Cons over Seperate DB's

True enough... but if you have enough to physically seperate the data, you won't usually have any RI requirements between the two servers...
--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 19, 2008 at 10:01 pm

#860386

Viewing 15 posts - 48,661 through 48,675 (of 59,102 total)