Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,916 through 21,930 (of 59,072 total)

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

I can't speak for Kevin but I roll my own, as well. Two different types but both use carefully created, hardcoded triggers. Notice that I didn't say "hand...
--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 9:06 pm

#1769380
RE: Database Restore Hangs

Just remember that Instant File Initialization doesn't do squat for log files.
--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 8:55 pm

#1769379
RE: Tempdb Shrink takes long time.

TheSQLGuru (1/11/2015)
Why in the world are you worried about 10GB on a 170GB file?!? Leave it and move on - I GUARANTEE you that you have MANY more 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)

January 11, 2015 at 8:53 pm

#1769378
RE: SAN Response Times

Lowell (1/11/2015)
don't be ridiculous. you can run it on production. it's doing what your server is already doing; in this case it creates a four gig file and tests how...
--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:39 pm

#1769371
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

Viewing 15 posts - 21,916 through 21,930 (of 59,072 total)