Jeff Moden

Forum Replies Created

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

RE: Prevent Logon Triggers

I agree with Sue. You need to fix the permissions on the users of those machines so that can't do such a thing.
--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 21, 2019 at 11:47 am

#2019547
RE: Date functions..

Lynn Pettis - Sunday, January 20, 2019 1:48 PM
Jeff Moden - Sunday, January 20, 2019 12:17 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 20, 2019 at 3:07 pm

#2019485
RE: Date functions..

Jeffrey Williams 3188 - Sunday, January 20, 2019 10:20 AM
Jeff Moden - Saturday, January 19, 2019 5:24...
--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 20, 2019 at 12:17 pm

#2019482
RE: Remove DATE ONLY from datetime column

Lempster - Sunday, January 20, 2019 2:31 AM
Jeff Moden - Saturday, January 19, 2019 3:02 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 20, 2019 at 8:02 am

#2019473
RE: Performance Issue with Simple Query /Big Tables

polkadot - Friday, January 18, 2019 8:56 PM
Jeff Moden regarding the "NCI_CHUB_S_CONTACT_01"...
--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 20, 2019 at 7:50 am

#2019472
RE: Understanding the datetime2 data type and precision

michael.leach2015 - Saturday, January 19, 2019 5:47 PM
Jeff Moden - Saturday, January 19, 2019 4:57 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 7:00 pm

#2019459
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

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