Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,996 through 8,010 (of 59,098 total)

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
Reply To: TempDB won't shrink
LearningDBA wrote:
I mean I just didn't run just DBCC shrinkfile. This is the complete command I ran for all 8 files but still no luck.
```
USE [tempdb]
GO
DBCC SHRINKFILE...
```
--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 2, 2020 at 7:11 pm

#3711945
Reply To: Error converting data type varchar to numeric.

Explicitly convert the SKU to something like a VARCHAR(10) using CAST or CONVERT.
--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 2, 2020 at 6:49 pm

#3711936
Reply To: Delaying the code

Right there with you on the "test the heck out of anything".
To be absolutely honest, I have no idea how you even came across this especially since it's not 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 2, 2020 at 6:37 pm

#3711933
Reply To: Exporting Data with PowerShell

Steve Jones - SSC Editor wrote:
Feel free to add that. dbatools is an open project.
Heh... or just do it 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)

January 2, 2020 at 6:00 pm

#3711905

Viewing 15 posts - 7,996 through 8,010 (of 59,098 total)