Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,236 through 8,250 (of 59,091 total)

Reply To: How to speed up the query speed between different server tables

We combine OPENQUERY against a LinkedServer and it does appear to help performance quite a bit (especially when pointing at AS400s or IBM PowerSystems). I have no measured stats on...
--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)

December 3, 2019 at 5:13 pm

#3703901
Reply To: Last Login Date and Time

Admingod wrote:
So periodically save the contents of sys.dm_exec_sessions to a table would be a good option?
I agree with John and will restate it... sys.dm_exec_sessions isn't the best idea by 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)

December 3, 2019 at 4:27 pm

#3703880
Reply To: It's More Than What You Know

Shoot... I'm just happy to be on someone's list. 😀 😀 😀
I meet Steve and Grant before they knew how to spell RedGate. I don't remember exactly but it was...
--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)

December 3, 2019 at 4:22 pm

#3703876
Reply To: migrate package siis from 2008 to 2107

abdalah.mehdoini wrote:
good evening
I need to migrate packages ssis 2008 to 2017
I am looking for a method to export my packages that are on the 2008 server
on the net I find...
--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)

December 3, 2019 at 4:16 pm

#3703874
Reply To: Execution time before and after index creation for query with params

ebooklub wrote:
Query store capture long running query for last 1 hr period in following format
(@P1 bigint, @P2 bigint, @P3 bigint, ...@P120 )select Order_Id from Orders where item_Id in (@P1, @P2,...
--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)

December 3, 2019 at 4:10 pm

#3703871
Reply To: Using Storage DeDupe for AlwaysOn Availability Groups

Thanks for the feedback. IIRC correctly, PureStorage also makes it pretty easy to add on later.
As a bit of a sidebar and especially with SSDs, I tend to "over-provision". 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)

December 3, 2019 at 3:57 pm

#3703870
Reply To: Identity column as Primary Key - good or bad?

Mr. Brian Gale wrote:
Are you going to have more than 2 million records in the table? If so, probably want that to be a bigint.
Heh... I know you meant BILLION...
--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)

December 3, 2019 at 3:53 pm

#3703868
Reply To: PASS Local Group/Virtual Group/SQL Saturday organizers corner

Steve Rezhener wrote:
Event marketing and promotion
Reusable 2020 SQL Saturday in Los Angeles Event flyer (printer-friendly) in a Word format
Great and thoughtful idea, Steve, but I'm not sure what you mean by...
--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)

December 3, 2019 at 7:11 am

#3703699
Reply To: Problem with calculating an approximate space required for online index rebuild

What was the average percent of page fullness both before and after you started? I can show you how to make better estimates with that information and with knowing what...
--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)

December 3, 2019 at 7:04 am

#3703698
Reply To: sqlcmd - Unable to pass in exact file path as an input variable to :out

I've always been frustrated by things like that. It's a complete tease that MS built into the system. My answer has always been to use xp_CmdShell for such things... 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)

December 3, 2019 at 6:54 am

#3703697
Reply To: Using Storage DeDupe for AlwaysOn Availability Groups

My recommendation is just buy some more SSD. Maybe even buy some less expensive spinning rust where you can move some filegroups to for things like audit tables and the...
--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)

December 3, 2019 at 6:49 am

#3703696
Reply To: Whose account the job runs under?

sqlfriend wrote:
Thanks, figured out the access issue
Can you kindly tell us what you figured out? It'll help other folks (and me 😉 ). Thanks.
--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)

December 3, 2019 at 6:45 am

#3703695
Reply To: It's More Than What You Know

ktflash wrote:
"Do not be afraid to ask questions"
I think this also applies to: Do not be afraid to post your anwers and solutions here on the forum.
Even if it 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)

December 3, 2019 at 6:36 am

#3703693
Reply To: Backups Best Practice for SQL Server IaaS

PhilipC wrote:
I've found that Full Backups are taken through a snapshot of the VM itself within Azure and in return it breaks the log chain. That was what started my...
--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)

December 3, 2019 at 6:04 am

#3703687
Reply To: Getting the Options

Steve Jones - SSC Editor wrote:
I've used it to troubleshoot, wondering if two connections had different settings. Getting a raw number and comparing them worked for me. I haven't really used this to decode...
--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)

December 3, 2019 at 5:51 am

#3703683

Viewing 15 posts - 8,236 through 8,250 (of 59,091 total)