Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,986 through 27,000 (of 59,101 total)

RE: The Cascading (CROSS) APPLY

ChrisM@Work (4/16/2013)
Tim Walker. (4/16/2013)
Interesting, entertaining and educational with worked examples and performance statistics make this a great read.
The fact that it is also genuinely very useful and will help 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)

April 16, 2013 at 3:36 pm

#1607064
RE: Help with complicated running balance

I'm thinking that we should simplify the requirements a bit. From what I see, it boils down to two things.
1. Do a normal running total first.
2. Update...
--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)

April 16, 2013 at 6:52 am

#1606791
RE: The Cascading (CROSS) APPLY

Awesome job, Chris. Well done!
--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)

April 16, 2013 at 6:32 am

#1606783
RE: No performance gain on queries on different servers with considerable hardware change

I've been through this a couple of times now and I agree with Gail. It boils down to which car will run better with sugar in it's gas tank...
--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)

April 15, 2013 at 10:01 pm

#1606676
RE: Can someone help with a TSQL date sorting issue?

The first suggestion I would make is that, in the future, you help us help you. Please see the first link in my signature line for a short article...
--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)

April 15, 2013 at 9:50 pm

#1606675
RE: Help with complicated running balance

gcresse (4/15/2013)
I've included some comments on how that number is calculated.
Where? There's a whole lot of attachments.
--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)

April 15, 2013 at 9:22 pm

#1606673
RE: Memory usage not matching up with that shown in DMV's

This will sound stupid-simple but have you tried just looking at TaskMgr on the box? It provides a pretty good 60,000 foot view of such things.
--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)

April 15, 2013 at 6:48 pm

#1606668
RE: Combine data from 2 tables and insert in another table

kapil_kk (4/15/2013)
You can accomplish this task using MERGE
Let me ask you a thoughtful question... do you know how to get to the Moon? It's "easy". "You can...
--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)

April 15, 2013 at 6:36 pm

#1606667
RE: Large dataset in one table or several small tables

I think one table will be fine with some caveates. You have the 5 columns that identify an "entity". You also say that "entity" can have more than...
--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)

April 15, 2013 at 6:27 pm

#1606666
RE: Turn off Predictive Typing

Henrico Bekker (11/12/2010)
Well, every one is entitled to their opinions, but I have to disagree.
IntelliSense is a great feature and cuts dev time in half over a long period 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)

April 15, 2013 at 5:51 pm

#1606664
RE: sql:space at the end of string

Folks, please consider avoiding all forms of RBAR for this simple problem. Also consider avoiding a MAX datatype unless you absolutely need it.
To avoid the RBAR, the following...
--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)

April 15, 2013 at 5:30 pm

#1606662
RE: sql:space at the end of string

Pankaj067 (4/15/2013)
Hello,
There is an alternative solution to your problem what you can do is, you can add an additional entries for extra spaces
for eg:
Let say your input is @str =...
--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)

April 15, 2013 at 5:15 pm

#1606661
RE: Open EDI file in SQL Server

Heh... the neat thing about EDI is that it has so very many standards. 😀
--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)

April 15, 2013 at 5:06 pm

#1606658
RE: Using pivot in sql

~~Am I the only one that doesn't think a Pivot is necessary here?~~
Never mind. The lack of indentation got 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)

April 15, 2013 at 5:01 pm

#1606656
RE: Having Trouble with first SQL 2012 Database

dob111283 (4/15/2013)
bump
At this point, my recommendation is to press the {f1} key and begin reading Books Online for answers to some of these questions. It will not only help...
--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)

April 15, 2013 at 4:49 pm

#1606654

Viewing 15 posts - 26,986 through 27,000 (of 59,101 total)