Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,981 through 7,995 (of 59,091 total)

Reply To: Setting flexible security for reporting

RichardFRay wrote:
Yo, Jeff --
So, here's a detail...
When I compile my sp's, in 'my database', with EXECUTE AS OWNER it's fine, but now there are problems in the production db. 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)

January 5, 2020 at 7:07 pm

#3712450
Reply To: The Art of Commenting
skeleton567 wrote:
One of the greatest values of commenting is to answer the proverbial 'What was I thinking ?' question.
Heh... spot on. I use comments for the following...
1. To reiterate 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)
January 5, 2020 at 5:46 pm

#3712447
Reply To: MAXDOP vs CPU time and elapsed time

cmartel 20772 wrote:
I recently experimented with MAXDOP using a pretty huge statement. Here is a summary of the results:
MAXDOP = 0. CPU = 36790 ms, elapsed = 12838 ms.
MAXDOP = 1....
--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)

January 4, 2020 at 1:05 am

#3712288
Reply To: Creating a data and log drive per CPU

Edward Shaw wrote:
They claim to have been able to get queries down from hours to seconds by doing this.
I've seen a lot of strange claims and they normally turn out 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)

January 4, 2020 at 12:51 am

#3712284
Reply To: Unable to attach database

Grant Fritchey wrote:
(although I know where you can get even better than native compression <cough> Redgate </cough>)
Sounds like the making of an article, Grant. A comparison using the same database...
--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)

January 4, 2020 at 12:03 am

#3712280
Reply To: FILLFACTOR - Best Practices

p.s. If your indexes are random GUID based, you MUST stop using REORGANIZE on them. REORGANIZE does not work the way most people think it does, especially when it comes...
--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)

January 3, 2020 at 11:39 pm

#3712279
Reply To: FILLFACTOR - Best Practices

pramod_kasi wrote:
I wouldn't change fill factor setting on Instance Level, and its not recommended. It might worsen your performance, so be careful in with this setting.
Now with Fill factor on...
--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)

January 3, 2020 at 11:34 pm

#3712278
Reply To: Query tweak

Chris Harshman wrote:
I think we need clarification on what the desired output of this query is. To me, the whole Quaters table seems unnecessary if all you are returning in your...
--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)

January 3, 2020 at 11:13 pm

#3712277
Reply To: Unable to attach database

oogibah wrote:
Unless you're using TDE then compression prior to 2016 can be bad. ( or so I've read, I don't care to tempt it myself )
Just to give you some...
--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)

January 3, 2020 at 8:31 pm

#3712251
Reply To: Query tweak
VSSGeorge wrote:
Is there any way to tweak the following query? Thanks
```
; WITH CTE AS
(
SELECT DATEPART(QUARTER, GETDATE()) as 'Quarter', DATEPART(YEAR, GETDATE()) as 'Year'
)

select Quarter,Year from CTE where Quarter...
```
--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)
January 3, 2020 at 8:01 pm

#3712223
Reply To: The Time to Patch

Steve Jones - SSC Editor wrote:
Vendors are a huge problem in patching. I'd like to see contracts explicitly state they'll certify within xx months, with xx being < 3.
That's not easy to do. Look...
--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)

January 3, 2020 at 7:44 pm

#3712221
Reply To: T-SQL Query Help

jcelko212 32090 wrote:
I just expect minimal polite behavior from people that post. And I do not suffer, rude, lazy people easily.
To be honest, it's ironic that you would post such a...
--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)

January 3, 2020 at 7:39 pm

#3712220
Reply To: Unable to attach database

Luv SQL wrote:
Yes it's very clear the backup system is flawed but unfortunately our IT is outsourced and that was all I was given and have access to. I've requested a...
--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)

January 3, 2020 at 3:18 pm

#3712153
Reply To: Setting flexible security for reporting

p.s. And, yeah... it even works with refreshable spreadsheets that call stored procedures. As you know, the spreadsheets should absolutely be calling stored procedures so that you're not chasing down...
--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)

January 3, 2020 at 3:36 am

#3712023
Reply To: Setting flexible security for reporting

Thanks, Richard. It's only because I have a long beard and that it took me 30 years of answering questions on forums to get there. 😀
To be honest, I don't...
--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)

January 3, 2020 at 3:32 am

#3712022

Viewing 15 posts - 7,981 through 7,995 (of 59,091 total)