Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,531 through 7,545 (of 59,098 total)

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
Reply To: Get the correct output

To Steve's good point...
From the posted input and the posted required output, it looks like there should only be a return if a given AlertID only has AlertTypeID's of both...
--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:19 pm

#3735667
Reply To: Question on BCP and Azure

I don't use Azure and I've not used VB in a million years. However, the following link seems to have a fair bit of info that you might find applicable...
--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 3:00 pm

#3735608
Reply To: SQL Is Always Going to be Popular

Oh... no question about trying something new being a good thing. That's actually how I got so involved with electronics, computers, and ultimately SQL Server (and many other programs including...
--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 1:37 pm

#3735598
Reply To: SQL Is Always Going to be Popular

I don't know... if you consider that 100 hours is probably outside of your normal work hours and you spend 2 hours of the 100 every day on weekdays, that...
--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 18, 2020 at 11:38 pm

#3735468

Viewing 15 posts - 7,531 through 7,545 (of 59,098 total)