Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,501 through 7,515 (of 59,072 total)

Reply To: Sql to oracle replication

Jeffrey Williams wrote:
Jeff Moden wrote:
Do a BCP out to a file and have Oracle import it (I can't remember the name of the built in tool on the Oracle side). The last...
--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)

March 21, 2020 at 9:25 pm

#3736057
Reply To: Room booking system - calculating room occupancy

I recommend that you onvert that spreadsheet to actual INSERTs to a table to help us help you. Please see the first link in my signature line below for details.

--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)

March 21, 2020 at 9:22 pm

#3736056
Reply To: SQl Stored Procedure - View Tuning

pdsqsql wrote:
Thank you Frederico.
Completely agreed with that view will be the issue as joining multiple tables and using some function which slows down the process.
But didn't not much fully understood...
--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)

March 21, 2020 at 9:08 pm

#3736052
Reply To: SQl Stored Procedure - View Tuning

frederico_fonseca wrote:
downloading the plan from the link does have all the info as far as I can see, including predicates.
That would explain it... I didn't download the plan.
--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)

March 21, 2020 at 8:00 pm

#3736050
Reply To: SQl Stored Procedure - View Tuning

We need the actual execution plan and the original code that you published on Brent's site, as well, please.

--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)

March 21, 2020 at 4:42 pm

#3736036
Reply To: Sql to oracle replication

Do a BCP out to a file and have Oracle import it (I can't remember the name of the built in tool on the Oracle side). The last time 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)

March 21, 2020 at 3:54 pm

#3736028
Reply To: SQl Stored Procedure - View Tuning

p.s. Since we're actually trying to help you tune the view, it would be helpful if you actually posted the code for the view, as well.
--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)

March 21, 2020 at 3:45 pm

#3736027
Reply To: SQl Stored Procedure - View Tuning

pdsqsql wrote:
Jeff,
Thank you for your response and suggesting about other details, i am totally agreed with you.
i have link for the plan, please see the following link if you don't...
--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)

March 21, 2020 at 3:43 pm

#3736026
Reply To: how to increase batch size to 100000

That was going to be my suggestion if the OP ever came back on this thread except I wouldn't limit the batches. First, BCP automatically limits itself to 1,000 rows...
--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)

March 21, 2020 at 3:25 am

#3735983
Reply To: how to increase batch size to 100000

What did you end up doing for this? Inquiring minds want to know. 😀
--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)

March 20, 2020 at 11:05 pm

#3735971
Reply To: SQl Stored Procedure - View Tuning

If you want help with such a performance issue, please see the 2nd link in my signature line below for how to present it in the best way possible to...
--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)

March 20, 2020 at 7:47 pm

#3735943
Reply To: Need some help getting info of people logged in, but from the POV of NON-Sysadm

Seems like a lot of work. Why not just use WITH EXECUTE AS OWNER at the beginning of the proc?
--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)

March 20, 2020 at 7:45 pm

#3735942
Reply To: How to check if a particular table is being used right now?

Finding the last access date and time doesn't tell you if it's currently being accessed. Why not just check sp_lock results for objects that have locks on them?
--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)

March 20, 2020 at 6:33 pm

#3735926
Reply To: Get the correct output

Steve Collins wrote:
...there's no point in looking back or carrying relics forward imo.
Dude! I'm right here! 😀
--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)

March 20, 2020 at 6:15 pm

#3735922
Reply To: Table Partition in Sql server with compression

From the sounds of it, you're a bit new to partitioning and all of the benefits and seriously negative caveats it can throw you.
Let's start at the beginning... Why do...
--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)

March 19, 2020 at 6:23 pm

#3735669

Viewing 15 posts - 7,501 through 7,515 (of 59,072 total)