Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,001 through 24,015 (of 59,099 total)

RE: Get the hierarchy orders(top to bottom) of the table

yuvipoy (4/2/2014)
Just want the parent table name ,key name, child table name ,child key in the order
parent name,key name, child name ,child key
p1 k1 p2 k2
p2 k2 p3...
--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 2, 2014 at 2:55 pm

#1702640
RE: Ideal table for Memory Optimization ?

Koen Verbeeck (4/2/2014)
GilaMonster (4/1/2014)
In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is the lock-less, latch-less optimistic concurrency. It'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)

April 2, 2014 at 2:48 pm

#1702638
RE: Automate Sliding Window Partition Maintenance: Part III

Thanks, Hugh. I appreciate the feedback.
--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 2, 2014 at 2:38 pm

#1702635
RE: Stairway to Advanced T-SQL Level 5: Storing Data in Temporary Tables

dataman777 (3/19/2014)
What is the difference and implications of utilizing #TempTableName and @TempTableName ?
See the following:
http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
--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 2, 2014 at 2:04 pm

#1702624
RE: Flexible Recursive Level Splitting - One column per level

I see that no one has jumped in on this even though you've provided readily consumable test data.
First, my response will act as a "bump" and, second, if no one...
--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 2, 2014 at 12:39 pm

#1702598
RE: Help need in Avoiding Loop

born2achieve (4/2/2014)
Hi Jeff,
Yes you correct. i always start to write algorithm before i write logic.
Here is my algo,
1. Get the records from users_transaction table group by user id where status...
--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 2, 2014 at 7:37 am

#1702462
RE: SQL Server 2014 Developer Edition - availability for download ?

Heh... waiting for SP1. 😉
--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 2, 2014 at 12:03 am

#1702325
RE: Get the hierarchy orders(top to bottom) of the table

Ok... so what's the structure of the tables for the emp->mgr relationship?
Shifting gears, because of all the tables you have involved, you really need to read and...
--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 1, 2014 at 11:51 pm

#1702324
RE: SQL Transpose / Pivot - Help

AarionSSQL (4/1/2014)
PS: The attachment has a screenshot of the tables described below which is easier to read
Hi All,
I am stuck on finding a solution to transpose source data from 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)

April 1, 2014 at 11:41 pm

#1702323
RE: Automate Sliding Window Partition Maintenance: Part III

I wouldn't have used PoSH for any of this but this is a nice series you've put together. Thanks for taking the time.
Shifting gears a bit, the title 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)

April 1, 2014 at 11:23 pm

#1702321
RE: Are the posted questions getting worse?

TomThomson (4/1/2014)
GilaMonster (4/1/2014)
I haven't. Had a online friend years ago (when newsgroups were still a thing) who acted like Haskell was the second coming. Put me off a bit.
F# 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)

April 1, 2014 at 11:09 pm

#1702320
RE: sp_send_dbmail has formatting off on datetime when directing output to csv file

Does it have to be an attached file or can it just be a nicely formatted email message that someone could copy and paste into Excel?
--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 1, 2014 at 10:58 pm

#1702318
RE: Help need in Avoiding Loop

Let's turn this into a thinking lesson on "Divide'n'Conquer" methods. To do that, you have to think in columns instead of rows and you have to think about accomplishing...
--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 1, 2014 at 7:50 pm

#1702303
RE: Ideal table for Memory Optimization ?

GilaMonster (4/1/2014)
In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is the lock-less, latch-less optimistic concurrency. It's 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)

April 1, 2014 at 6:32 pm

#1702296
RE: Nesting xml

Eirikur Eiriksson (4/1/2014)
Please post proper DDL and enough data, the problem is straight forward from there.
If you're going to tell people that, then you need to tell them what "proper...
--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 1, 2014 at 4:29 pm

#1702280

Viewing 15 posts - 24,001 through 24,015 (of 59,099 total)