Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,341 through 14,355 (of 59,097 total)

RE: Suspect production database

coolchaitu - Tuesday, September 12, 2017 8:56 AM
Jeff Moden - Tuesday, September 12, 2017 8:47 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)

September 12, 2017 at 9:20 am

#1959141
RE: Suspect production database

coolchaitu - Tuesday, September 12, 2017 1:21 AM
GilaMonster - Tuesday, September 12, 2017 1:17 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)

September 12, 2017 at 8:47 am

#1959128
RE: Problem Debugging Script Task

All those using 2012... what SP/CU are you using? 2012 had some nasty regression problems until after 2012 sp3 CU 6 (which isn't the latest now). Upgrade to the latest...
--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)

September 12, 2017 at 8:46 am

#1959127
RE: Microsoft SQL Server Utilities and Tools

Heh... the list of "smells" reminds me of when Robocop had a hundred rules injected into his memory and could no longer function correctly. If you have enough "smells", no...
--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)

September 12, 2017 at 8:28 am

#1959113
RE: Running total with reset condition

Steve Jones - SSC Editor - Tuesday, September 12, 2017 8:05 AM
LOL, nice, Jeff. I was hoping to avoid some variable in...
--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)

September 12, 2017 at 8:23 am

#1959111
RE: Running total with reset condition

Here's a version that works in all versions of SQL Server from 2005 and up. And, yes... it calculates the GroupID in a fashion that Steve identified above.
First,...
--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)

September 12, 2017 at 6:54 am

#1959084
RE: The struggle to renormalize data

Personally, I think all of the "new" ways of sharing data are just stupid. XML, JSON, EDI, whatever. It's all stupid. If it's not tag bloated hierarchical crap that does...
--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)

September 11, 2017 at 11:04 pm

#1959047
RE: Running total with reset condition

Talvin Singh - Monday, September 11, 2017 11:47 AM
just move onto next row, which would reset and start a new running total.
--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)

September 11, 2017 at 10:42 pm

#1959044
RE: msdb data file shrinkfile - Large Database

sqlguy80 - Monday, September 11, 2017 9:57 AM
Hi Jeff,
Yes I rebuilt all indexes and updated all stats hoping that would help with...
--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)

September 11, 2017 at 9:25 pm

#1959042
RE: Convert this SQL Agent Job Step to Powershell

AlexSQLForums - Friday, September 8, 2017 8:29 PM
Hi Jeff
Using exec xp_cmdshell works but the requirement is to be done in PS.
Why? 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)

September 11, 2017 at 9:19 pm

#1959041
RE: Merge Empty Partitions --Takes long time

frederico_fonseca - Monday, September 11, 2017 5:30 PM
Most likely the merge is doing data movement.
I recall a document that highlighted that issue...
--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)

September 11, 2017 at 9:14 pm

#1959040
RE: msdb data file shrinkfile - Large Database

sqlguy80 - Monday, September 11, 2017 7:12 AM
Imran,
Thank you so much, That worked! Your great.
Any logic behind that? I couldnt find...
--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)

September 11, 2017 at 8:22 am

#1958931
RE: Query Help - Slow Performance

Considering the desired output, the real problem is that bloody student schedule table. It needs to be pre-aggregated to only the information required which will remove thousands and thousands 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)

September 11, 2017 at 7:42 am

#1958923
RE: Hardening windows AD account running sqlserver service and sql agent / and or changing the password

caz100 - Monday, September 11, 2017 2:18 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)

September 11, 2017 at 7:38 am

#1958922
RE: SQL Server Standard Competencies

Grant Fritchey - Friday, September 8, 2017 5:44 AM
I'm actually not a fan of the Microsoft Certifications, however, the skills they test...
--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)

September 10, 2017 at 10:03 pm

#1958894

Viewing 15 posts - 14,341 through 14,355 (of 59,097 total)