Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,616 through 9,630 (of 59,099 total)

RE: Minimal Logging

I'm doing another test... there might be a bit of a nuance with DBCC SHRINKFILE that I previously missed.
--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 23, 2019 at 9:07 am

#2025289
RE: Minimal Logging

Ok, Thomas... it's official. You're not actually losing your mind. 😀 Minimal logging on the second insert does NOT work as advertised either on 2008 ( Dev Edition) or 2016...
--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 22, 2019 at 10:47 pm

#2025286
RE: T-SQL Query To Find Memory Usage Per Resource Pool Per Database

Wouldn't sys.dm_resource_governor_resource_pools be what you're looking for?
--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 22, 2019 at 5:43 pm

#2025285
RE: Permissions

The answer is at the following link...
http://bfy.tw/Msfe
--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 22, 2019 at 3:27 pm

#2025283
RE: Who Are Your Authenticated Users?

p.s. And thank you for the article... articles like this are incredibly value. Thanks for what you do, Steve.
--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 22, 2019 at 6:49 am

#2025195
RE: Who Are Your Authenticated Users?

it certainly IS important that the scope of a security setting be known. Especially for the cloud, I'd assume nothing and make damned sure that I understood the scope (there...
--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 22, 2019 at 6:48 am

#2025193
RE: Allocate Meetings to Employees (randomly generated) with daily maximum hours set at 5

And... it would help tremendously if the sample data were "readily consumable". Please see the article at the first link in my signature line below for way way to provide...
--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, 2019 at 8:21 am

#2025110
RE: Allocate Meetings to Employees (randomly generated) with daily maximum hours set at 5

jonathan.crawford - Tuesday, March 19, 2019 8:46 AM
Jeff Moden - Tuesday, March 19, 2019 8:42 AM
--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, 2019 at 6:52 am

#2025097
RE: sql job taking more time

HandyD - Monday, March 11, 2019 5:55 PM
Jeff Moden - Monday, March 11, 2019 6:39 AM
--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, 2019 at 6:36 am

#2025095
RE: Using recursive CTE

Sachy123 - Thursday, March 21, 2019 4:53 AM
drew.allen - Friday, March 15, 2019 12:26 PM
--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, 2019 at 6:24 am

#2025093
RE: SQL Server slow but CPU,Memory and Network fine

kapfundestanley - Thursday, March 21, 2019 5:35 AM
Team please looking for assistance on SQL Server 2016,CPU,Memory and Network are fine but application...
--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, 2019 at 6:18 am

#2025092
RE: The transaction log for database is full due to 'ACTIVE_TRANSACTION'

Orni - Wednesday, March 13, 2019 11:53 AM
Hi all,
I am an accidental DBA that has been assigned to monitor and optimize 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)

March 20, 2019 at 6:16 pm

#2025077
RE: Backup Restorations

But it's not everything after the DIF. That's what transaction log files are used for... to decrease the RPO.
--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, 2019 at 9:22 am

#2025028
RE: Minimal Logging

Ah... my apologies. I didn't read one of your previous posts completely to find out that you are, indeed, doing your secondary inserts in an "Append Only" fashion. That post...
--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, 2019 at 9:04 am

#2025024
RE: trimming SSNs

RonKyle - Wednesday, March 20, 2019 6:45 AM
I read something that asymmetric encryption was resource intensive and that the recommended solution 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)

March 20, 2019 at 7:01 am

#2025009

Viewing 15 posts - 9,616 through 9,630 (of 59,099 total)