Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,966 through 7,980 (of 59,072 total)

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
Reply To: Finding Motivation to Learn

Doctor Who 2 wrote:
Almost a year ago Microsoft mothballed their Microsoft Virtual Academy. .
Man, that was a bloody shame. They actually had some good stuff on there and I can't find hide...
--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 1:22 am

#3712017
Reply To: The Time to Patch

Considering the absolute idiocy that occurred in SQL Server 2012 until the finally fixed {almost} everything they broke in the SPs and CUs prior to SP3 and the SSIS nightmares...
--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 1:10 am

#3712015
Reply To: Setting flexible security for reporting
1. Create the procedures that support the reporting with EXECUTE AS OWNER. (This can easily be added existing procs)
2. Create a new role in the reporting database called db_Execute.
3. Grant...
--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 12:44 am

#3712011
Reply To: T-SQL Query Help

Thanks, Joe. I appreciate the feedback. I guess my next question would be rhetorical but I'm thinking it... When was the last time you actually had to port a 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 3, 2020 at 12:21 am

#3712004

Viewing 15 posts - 7,966 through 7,980 (of 59,072 total)