Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,231 through 13,245 (of 59,101 total)

RE: What is your typical day like?

RandomStream - Friday, January 5, 2018 12:00 PM
I'm in an environment where the core of the business relies on leased software solutions....
--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, 2018 at 2:09 pm

#1974770
RE: Ola's maintenance solution taking too long on VLDB's

Grant Fritchey - Friday, January 5, 2018 6:03 AM
RandomStream - Thursday, January 4, 2018 4:41 PM
--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, 2018 at 8:50 am

#1974710
RE: Metldown and Spectre

Super Cat - Friday, January 5, 2018 6:53 AM
Please keep me informed.
Read the main article that came out on this site this...
--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, 2018 at 8:13 am

#1974702
RE: Ola's maintenance solution taking too long on VLDB's

RandomStream - Thursday, January 4, 2018 5:11 PM
Jeff Moden - Thursday, January 4, 2018 4:50 PM
--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, 2018 at 5:37 pm

#1974597
RE: Backing up multiple SQL instance and databases using 3rd party software - Any recommendations

Perry Whittle - Wednesday, December 13, 2017 9:36 AM
Steve Jones - SSC Editor - Wednesday, November 22,...
--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, 2018 at 4:53 pm

#1974587
RE: Ola's maintenance solution taking too long on VLDB's

RandomStream - Thursday, January 4, 2018 4:41 PM
I experimented with Ola's idea form quite some time and eventually rolled my own solution...
--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, 2018 at 4:51 pm

#1974586
RE: Problem with Tuning of Delete Statement

Hamid-Sadeghian - Thursday, January 4, 2018 1:51 AM
I cannot change the query because this is send from ARCGIS application.
There's a pretty good...
--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, 2018 at 4:34 pm

#1974581
RE: 'Kernel memory leaking' Intel processor design flaw

ZZartin - Thursday, January 4, 2018 8:37 AM
So are major companies really going to be okay just eating a potential 30+% CPU...
--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, 2018 at 9:04 am

#1974492
RE: An Introduction to PowerShell for a DBA

Caruncles - Thursday, January 4, 2018 8:35 AM
the example given would be run from ad hoc queries in SSMS. Similar imports, which...
--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, 2018 at 8:54 am

#1974488
RE: Execute .sql script within a stored procedure without using xp_cmdshell

juniorDBA13 - Wednesday, December 20, 2017 6:42 AM
Hi,
I want to execute a .sql script within a stored procedure but I want 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, 2018 at 8:34 am

#1974482
RE: Execute .sql script within a stored procedure without using xp_cmdshell

Thom A - Thursday, January 4, 2018 3:54 AM
What is the .sql file doing? Why are you wanting to execute SQL from...
--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, 2018 at 8:31 am

#1974480
RE: can't install SQL SERVER 2008 SP3/SP4 on WINDOWS server 2016

Hmmmm... please tell me you're not using the Developer Edition on a production box.
--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, 2018 at 8:30 am

#1974479
RE: How to get up to 5 hierarchy levels of data from original (parent) to derived (children) product table.

itortu - Friday, December 29, 2017 3:57 PM
I have a table with 3 columns:

Id (identity),Sku_Parent (varchar(10)),Sku_Child (varchar(10))
I would like...
--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, 2018 at 8:19 am

#1974476
RE: 'Kernel memory leaking' Intel processor design flaw

I'm not sure why people think this is mainly for "cloud-based" computers. It affects anything with the susceptible CPUs.
--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, 2018 at 8:17 am

#1974475
RE: Filter By AND e not for OR/AND

I don't know squat about SSAS. Can it actually use a T-SQL query where you need it? If it can, I have a high performance method for doing this. It...
--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, 2018 at 7:53 am

#1974463

Viewing 15 posts - 13,231 through 13,245 (of 59,101 total)