Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,251 through 8,265 (of 59,098 total)

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
Reply To: day shift job

Tell people where you work that you've been there for 8 years and that you'd like to shift to the day shift. The answer is no unless you ask. If...
--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:38 pm

#3703476
Reply To: SQL to SQLite

You do understand that you're making a major paradigm shift in code, right? SQL <> SQL between different RDBMS engines.
--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:31 pm

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

A lot of people will disagree with me on many fronts but I always keep an active SSMS session running in an RDP session on my production servers. It has...
--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:29 pm

#3703463
Reply To: Audit Log.

Andrey wrote:
it's worth to check the content of default trace which is enabled by default on all editions of SQL server 2005+
https://www.mssqltips.com/sqlservertip/1739/using-the-default-trace-in-sql-server/
"It Depends". On my main production server, 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 2, 2019 at 3:24 pm

#3703459

Viewing 15 posts - 8,251 through 8,265 (of 59,098 total)