Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,221 through 8,235 (of 59,072 total)

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
Reply To: SQL to SQLite

gideon.e wrote:
Thank you Jeff. Yes I am painfully aware that the code is different. It took me a very long time to figure out the SQL query and am really...
--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:49 am

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

PhilipC wrote:
Thanks Grant/Jeff, that is exactly my methodology as well that I just wanted to confirm.
What do you both do surrounding the VM backup, because if you have the "SQL...
--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:41 am

#3703678
Reply To: Is a durable key always necessary in a dim?

And surrogate keys can and usually are durable keys.
--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 2, 2019 at 3:46 pm

#3703483
Reply To: Why do I need DAC if I am able to connect to the server via sqlcmd?

Lowell wrote:
that would only work on a very small environment right? I've got 64 prod servers and nearly 200 total including non-prod, and the number of times in 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)

December 2, 2019 at 3:43 pm

#3703479

Viewing 15 posts - 8,221 through 8,235 (of 59,072 total)