Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,946 through 21,960 (of 59,098 total)

RE: "poor man's replication" ETL process design

Ah... understood on the OR.
I'm thinking that a UNIQUE NIX on the ID and Hash (and that combination should be unique because the ID is unique) might be worth trying.
--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)

January 11, 2015 at 7:28 pm

#1769369
RE: .bak file does not show in Restore window

Gosh, I dunno, Grant. If the backups are taken correctly, I've found the GUI actually does a pretty good job about figuring out which DIF/TRNs go with the latest...
--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)

January 11, 2015 at 7:25 pm

#1769368
RE: query

Mark Cowne (1/11/2015)
Bit late to the party but you can convert this to a nested set representation using the code below
See Jeff Moden articles here[/url] for info on nested sets
Kind...
--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)

January 11, 2015 at 7:08 pm

#1769366
RE: Help me to tune this query in a better way

Eirikur Eiriksson (1/11/2015)
Jeff Moden (1/11/2015)
prabhu.st (1/11/2015)
as of now the query is taking 19 seconds to bring the result set with pagination for 300454 records.
Are you saying that (and 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)

January 11, 2015 at 6:59 pm

#1769365
RE: Using TableDiff on specific tables in different databases.

Why not just setup Replication?
--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)

January 11, 2015 at 6:53 pm

#1769364
RE: Max value subquery?

rickyschroder (1/11/2015)
...I think here is what I have, omitted GROUP BY AND ORDER BY account_id ASC
That's where I was going with this and why I asked about the Account_ID. ...
--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)

January 11, 2015 at 6:48 pm

#1769363
RE: Is there a way to throttle or limit the amount of sql requests either by IP address or username?

Or just make them run better. 😉 Then there won't be a problem that you have to throttle or manage.
--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)

January 11, 2015 at 6:42 pm

#1769362
RE: "poor man's replication" ETL process design

bantrim (1/11/2015)
Jeff Moden (1/11/2015)
It may be that having the clustered index on the hash would work faster on the lookups, especially if it were a unique index that was guaranteed...
--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)

January 11, 2015 at 6:39 pm

#1769361
RE: Max value subquery?

Are you saying that you only want the data from the row that has the MAX Carat_ID for account_id = 464?
--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)

January 11, 2015 at 6:00 pm

#1769357
RE: Assistance with an IF THEN in SQL Sever 2008 R2?

@chef423,
How do you want to handle 58475 when the following happens?
i_transaction_id c_amount dt_when i_ticket_id...
--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)

January 11, 2015 at 5:37 pm

#1769356
RE: Assistance with an IF THEN in SQL Sever 2008 R2?

Eirikur Eiriksson (1/11/2015)
chef423 (1/11/2015)
hmmm, that's why I put the output of the above code in the thread...
No worries...Ill figure it out on my own then.
If you don't understand the original...
--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)

January 11, 2015 at 5:29 pm

#1769355
RE: update/insert

marybeth1975 (1/11/2015)
I have the following:
iddue_dateupdate_datemonth
2004/14/20192/4/20142
2006/16/20204/6/20144
2008/18/20216/8/20146
3006/13/20143/3/20143
3009/19/20146/9/20146
30012/22/20149/12/20149
How do yo update the due date for each month?
iddue_dateupdate_datemonth
2004/14/20192/4/20142
2004/14/2019 3
2006/16/20204/6/20144
2006/16/2020 5
2008/18/20216/8/20146
2008/18/2021...
--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)

January 11, 2015 at 4:13 pm

#1769351
RE: How can I write a query make the selection

anu.anu4u (1/11/2015)
Thanks for the code but I didnt understand the code ... and also there is also a condition - select only salespersonId =1 (salespersonId is another field which i...
--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)

January 11, 2015 at 12:24 pm

#1769324
RE: Is there a way to throttle or limit the amount of sql requests either by IP address or username?

ghurty (1/11/2015)
Is there a way to throttle or limit the amount of sql requests either by IP address or username?
Thank you
I have found that such throttling is to control resource...
--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)

January 11, 2015 at 12:14 pm

#1769323
RE: DTS export Excel 2003 to Excel 2007

Something else is going on there. I'm using EXCEL 2010 and the "$" still works just fine.
--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)

January 11, 2015 at 12:08 pm

#1769321

Viewing 15 posts - 21,946 through 21,960 (of 59,098 total)