Jeff Moden

Forum Replies Created

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

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
Reply To: Audit Log.

Regardless of which method you plan on, if you intend to audit every data change even in "just" user databases, you should immediately at least double the disk space 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 2, 2019 at 3:05 pm

#3703455
Reply To: Setup Alert New Job created

I'd create a morning report for all jobs. It's not difficult to do and will teach you a lot about the tables in MSDB. I render the report in T-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 2, 2019 at 3:00 pm

#3703453
Reply To: Getting the Options

Now, all those in the room that have actually used this function in production, please raise your hand! 😀
--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 2:58 pm

#3703450
Reply To: Remove old Error Logs

BEFORE YOU DELETE ANYTHING, MAKE SURE THAT YOUR BACKUPS ARE WORKING CORRECTLY AND THAT YOU CAN RESTORE TO A POINT IN TIME!!!!!
--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 2:53 pm

#3703449
Reply To: High CPU

Ah. Got it.
--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 2:21 pm

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

Grant Fritchey wrote:
Whether running in a VM on Azure, AWS, or locally, a VM is just a VM. You're responsible for your database backups the same way across all of 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)

December 2, 2019 at 2:03 pm

#3703430
Reply To: Last Login Date and Time

John Mitchell-245523 wrote:
Jeff Moden wrote:
I'd also get out of the habit of having discrete logins even if they're Active Directory logins. Use Active Directory Groups instead. Of course, the exception (there's almost...
--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 1:58 pm

#3703423

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