Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,741 through 13,755 (of 59,095 total)

RE: Are the posted questions getting worse?

Thom A - Monday, November 13, 2017 5:35 AM
Just because the phone is "smart" doesn't mean the user is. Standard 1st world...
--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)

November 13, 2017 at 5:42 am

#1967754
RE: Microservices in SQL Server

ALZDBA - Monday, November 13, 2017 5:20 AM
As a picture says more than 1000 words: Statler & Waldorf ( and I hope...
--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)

November 13, 2017 at 5:26 am

#1967748
RE: Microservices in SQL Server

Funny... they said the same thing when they came out with support for XML in SQL Server and XML still sucks as does the great divide between front end Developers...
--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)

November 13, 2017 at 4:53 am

#1967739
RE: Core T-SQL

TomThomson - Friday, November 10, 2017 8:30 PM
Jeff Moden - Tuesday, November 7, 2017 7:08 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)

November 12, 2017 at 9:36 pm

#1967707
RE: Query

jagjitsingh - Sunday, November 12, 2017 4:05 AM
Hi
I have 1 Table with field Document Type . I want those records...
--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)

November 12, 2017 at 9:11 pm

#1967706
RE: Using Extended Events to alert on long running queries

Sergiy - Sunday, November 12, 2017 1:19 PM
A query may take long to complete just because a log file being expanded.Or because...
--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)

November 12, 2017 at 7:54 pm

#1967704
RE: Delete syntax not working

Lynn Pettis - Sunday, November 12, 2017 11:13 AM
I am going to have to learn MondoDB and PostgreSQL where I work. ...
--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)

November 12, 2017 at 11:31 am

#1967694
RE: Fill Factor

Just to add to this because it recently came up on another thread... an even more important subject is that of maintaining statistics.
--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)

November 12, 2017 at 10:53 am

#1967691
RE: TransactionLog. VLF Fragmentation.

dmbsseller - Sunday, November 12, 2017 12:45 AM
GilaMonster - Saturday, November 11, 2017 10:54 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)

November 12, 2017 at 10:38 am

#1967690
RE: Tally Tables and Table Variables

Eirikur Eiriksson - Sunday, November 12, 2017 8:21 AM
Lesson for those who got this one wrong, AS in the column definition within...
--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)

November 12, 2017 at 10:27 am

#1967689
RE: Odd behavior with views

I agree with Gail... While I absolutely agree that anecdotal evidence my identify the need, it should not be used to make a decision nor form the basis of some practice. ...
--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)

November 12, 2017 at 10:25 am

#1967688
RE: Delete syntax not working

jcelko212 32090 - Saturday, November 11, 2017 1:29 PM
Jeff Moden - Sunday, November 5, 2017 7:25 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)

November 11, 2017 at 7:59 pm

#1967652
RE: Fill Factor

Arsh - Saturday, November 11, 2017 5:23 AM
For more clarity on this point , when a new row is inserted ,...
--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)

November 11, 2017 at 2:03 pm

#1967648
RE: Fill Factor

Grant Fritchey - Friday, November 10, 2017 12:26 PM
Jeff Moden - Friday, November 10, 2017 12:21 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)

November 10, 2017 at 7:30 pm

#1967622
RE: Should We Move to Azure?

xsevensinzx - Thursday, November 9, 2017 11:11 PM
Jeff Moden - Thursday, November 9, 2017 6:30 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)

November 10, 2017 at 6:47 pm

#1967620

Viewing 15 posts - 13,741 through 13,755 (of 59,095 total)