Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,201 through 13,215 (of 59,101 total)

RE: SQL to Excel : Using a SQL Table with Report Columns

subramaniam.chandrasekar - Wednesday, January 10, 2018 3:02 AM
Charles_P - Tuesday, January 9, 2018 10:01 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)

January 10, 2018 at 5:41 am

#1975253
RE: does backup and restore use tempdb?

Lynn Pettis - Tuesday, January 9, 2018 5:35 PM
Jeff Moden - Tuesday, January 9, 2018 4:56 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 10, 2018 at 5:37 am

#1975252
RE: SELECT all negative values, that have a positive value

jonathan.crawford - Tuesday, January 9, 2018 7:39 PM
This is why I hate quantum computing
But it's essential to the proper operation of DBCC...
--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 9, 2018 at 9:44 pm

#1975215
RE: SELECT all negative values, that have a positive value

adiedler - Tuesday, January 9, 2018 10:38 AM
J Livingston SQL - Tuesday, January 9, 2018 10:19 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)

January 9, 2018 at 5:17 pm

#1975199
RE: Top Skills in 2018 for Data Professionals

Grant Fritchey - Monday, January 8, 2018 5:23 PM
Finger pointing?
Kind of but they're all using the wrong finger. 😉 Heh... bloody non-quals....
--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 9, 2018 at 5:12 pm

#1975198
RE: does backup and restore use tempdb?

Siten0308 - Tuesday, January 9, 2018 8:47 AM
cool big thanks, this helps a lot, now to tell a So called Senior DBA...
--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 9, 2018 at 4:56 pm

#1975195
RE: Are the posted questions getting worse?

Thom A - Friday, January 5, 2018 9:41 AM
Lynn Pettis - Friday, January 5, 2018 7:56 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)

January 9, 2018 at 12:00 pm

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

ffarouqi - Tuesday, January 9, 2018 10:58 AM
Nadrek - Saturday, January 6, 2018 2:52 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 9, 2018 at 11:55 am

#1975143
RE: IN-Memory tables

Grant Fritchey - Monday, January 8, 2018 5:20 PM
Jeff Moden - Monday, January 8, 2018 5:10 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 8, 2018 at 8:18 pm

#1975014
RE: IN-Memory tables

Just out of curiosity, how many of you good folks have actually used it? Not being contrary or challenging here. It seems that there are a lot of people that...
--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 8, 2018 at 5:10 pm

#1975004
RE: It's the Engineers

robert.sterbal 56890 - Monday, January 8, 2018 8:53 AM
Do you have a link to their architecture? They have a need for ACID...
--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 8, 2018 at 10:57 am

#1974941
RE: It's the Engineers

robert.sterbal 56890 - Monday, January 8, 2018 8:43 AM
When you start talking about over a 100,000 nodes to handle data you probably...
--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 8, 2018 at 8:49 am

#1974910
RE: Metldown and Spectre

Super Cat - Monday, January 8, 2018 4:40 AM
Thanks. Read it recently.
MS has not really released anything concrete and concise especially around...
--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 8, 2018 at 8:35 am

#1974905
RE: T-SQL sorting

sknox - Monday, January 8, 2018 6:30 AM
Can anyone come up with a situation where using ordinal position in the sort...
--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 8, 2018 at 8:32 am

#1974903
RE: Data transfer

subramaniam.chandrasekar - Monday, January 8, 2018 2:46 AM
Admingod - Friday, January 5, 2018 2:10 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 8, 2018 at 8:16 am

#1974896

Viewing 15 posts - 13,201 through 13,215 (of 59,101 total)