Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,006 through 10,020 (of 59,093 total)

RE: Index fragmentation not cutting down to 0

Heh... I know this is an old post but I've found out through experimentation since Nov 2017 that if you're using REORGANIZE for large tables, then you have much bigger...
--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 19, 2019 at 5:40 pm

#2019457
RE: Date functions..

I know this is an old post but it reminds me of why I hate the tests that people are prone to writing. I actually had to stop and think...
--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 19, 2019 at 5:24 pm

#2019456
RE: Understanding the datetime2 data type and precision

Those aren't errors. Hover the mouse pointer of one of those Red dots and see.
--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 19, 2019 at 4:57 pm

#2019455
RE: Out of memory error while scripting structure and data

Sue_H - Friday, January 18, 2019 7:26 PM
Jeff Moden - Friday, January 18, 2019 5:47 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 19, 2019 at 4:11 pm

#2019454
RE: Remove DATE ONLY from datetime column

Lempster - Saturday, January 19, 2019 1:43 AM
Lynn Pettis - Friday, January 18, 2019 9:38 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 19, 2019 at 3:02 pm

#2019453
RE: Out of memory error while scripting structure and data

cmartel 20772 - Friday, January 18, 2019 3:05 PM
I am using the Tasks -> Generate Scripts utility to generate a complete (data...
--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 18, 2019 at 5:47 pm

#2019436
RE: Match vertical records to next greater date to find datediff

jcelko212 32090 - Friday, January 18, 2019 3:16 PM
brandon 94807 - Wednesday, January 16, 2019 2:58 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 18, 2019 at 5:43 pm

#2019435
RE: Remove DATE ONLY from datetime column

Sean Lange - Friday, January 18, 2019 1:34 PM
Lynn Pettis - Friday, January 18, 2019 11:24 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 18, 2019 at 5:41 pm

#2019434
RE: Number of employees active per date

@astrid 69000 ,
Do you have answers to my questions? 😉
--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 18, 2019 at 4:20 pm

#2019433
RE: Number of employees active per date

jcelko212 32090 - Friday, January 18, 2019 2:48 PM
astrid 69000 - Thursday, January 17, 2019 1:20 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 18, 2019 at 4:17 pm

#2019432
RE: Dynamic pivot tables

ipawelkon - Friday, January 18, 2019 11:25 AM
Hi,
I want to eliminate all nulls average by week and display like this. I know...
--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 18, 2019 at 3:19 pm

#2019426
RE: User Defined Function for following scnario

vs.satheesh - Thursday, January 17, 2019 5:46 AM
Dear All,
In my scenario, i need to generate string like
AAA,AAB,AAC.........ZZZ
My input parameter is just 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)

January 18, 2019 at 3:16 pm

#2019424
RE: Number of employees active per date

drew.allen - Friday, January 18, 2019 10:12 AM
Alan.B - Thursday, January 17, 2019 3: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 18, 2019 at 3:13 pm

#2019423
RE: SQL Query Help - PIVOT or CROSS APPLY?

amy26 - Friday, January 18, 2019 7:23 AM
Ok thank you, its not just me that's hella confused by the request. The comments...
--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 18, 2019 at 8:05 am

#2019369
RE: Are the posted questions getting worse?

frederico_fonseca - Thursday, January 17, 2019 4:10 PM
Grant Fritchey - Thursday, January 17, 2019 12:48 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 17, 2019 at 10:40 pm

#2019329

Viewing 15 posts - 10,006 through 10,020 (of 59,093 total)