Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,601 through 9,615 (of 59,091 total)

RE: Find missing numbers in sequence 1 thru 5

So create a small table (or use VALUES as a temporary table constructor) with the numbers 1-5 in it and do an outer join to it with the table you're...
--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 24, 2019 at 3:42 pm

#2025311
RE: Query Tuning Assistant: A Tool for Upgrades

The "old" Upgrade Adviser was nice... the new one (I can't remember it's name because they changed it and won't be using it again) isn't because you're going to...
--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 4:25 pm

#2025302
RE: Guide to Quickly Creating an Azure Data Lake Storage

From the article:
If you do not have an Azure Account, there is a good news. Microsoft let's you create your own Azure free account with 12 months of...
--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 4:14 pm

#2025301
RE: Guide to Quickly Creating an Azure Data Lake Storage

Jo Pattyn - Tuesday, March 19, 2019 2:47 AM
Why did you pick data lake storage gen 1 instead of gen 2?
OK... where...
--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 4:04 pm

#2025300
RE: Cleaning up tempdb

This is one of those questions where "It Depends" comes into play... please see the following article where the supposedly correct answer didn't work...
https://www.sqlskills.com/blogs/erin/remove-files-from-tempdb/
--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 3:32 pm

#2025299
RE: Minimal Logging

ti 93734 - Saturday, March 23, 2019 11:06 AM
Hm. I just noted a small difference in the text between the 2088 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)

March 23, 2019 at 12:22 pm

#2025294
RE: Minimal Logging

Nope... Didn't miss a thing. I'm posting my test because 1) I made a claim against the MS documentation and 2) I want other people to have proof and 3)...
--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 10:49 am

#2025292
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

Viewing 15 posts - 9,601 through 9,615 (of 59,091 total)