Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,936 through 13,950 (of 59,101 total)

RE: Send mail from stored procedure

mjohnson 71479 - Thursday, October 26, 2017 3:36 PM
I just needed to think outside of the T-SQL box and use a non-ANSI...
--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)

October 26, 2017 at 8:22 pm

#1965444
RE: Concatenate two columns which have a space between them

NorthernSoul - Monday, October 16, 2017 8:34 AM
adan950 - Monday, October 16, 2017 8:16 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)

October 26, 2017 at 8:11 pm

#1965443
RE: SQL versus program

patrickmcginnis59 10839 - Monday, October 23, 2017 6:47 AM
Jeff Moden - Saturday, October 21, 2017 6:06 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)

October 26, 2017 at 8:08 pm

#1965442
RE: StartDate and EndDate in same column

Redmond01 - Thursday, October 26, 2017 6:15 PM
Well basically my Rundate column is in ascending order and I have to setstart and...
--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)

October 26, 2017 at 7:59 pm

#1965441
RE: Transport error encountered when SOME queries run with batch terminator. Behaviour changes depending on text of query. WEIRD!

Don Halloran - Thursday, October 26, 2017 2:57 PM
No crazy database settings Jeff. I have a strong suspicion that this is not...
--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)

October 26, 2017 at 7:30 pm

#1965440
RE: Reproduce-able : Could not continue scan with NOLOCK due to data movement.

The real solution is to not use WITH(NOLOCK). 😉
--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)

October 26, 2017 at 5:36 pm

#1965427
RE: How to only select 11pm to 7am in DateTime (many months of data) DDM&DDL included :)

drew.allen - Wednesday, October 25, 2017 10:11 AM
Lynn Pettis - Tuesday, October 24, 2017 7:29 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)

October 26, 2017 at 5:32 pm

#1965426
RE: Should I use Insert Trigger or not?

GroverVivek - Thursday, October 26, 2017 9:49 AM
Steve Jones - SSC Editor - Thursday, October 26, 2017...
--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)

October 26, 2017 at 5:24 pm

#1965425
RE: Trying to speed up this 'GetWorkingDays' function.

below86 - Thursday, October 26, 2017 3:25 PM
I just realized I forgot to strip the time off of beg_dt and end_dt, so...
--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)

October 26, 2017 at 5:19 pm

#1965422
RE: how to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts

SQLPirate - Thursday, October 26, 2017 4:05 PM
Just schema?
You can extract a dacpac of your database without much powershell code or 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)

October 26, 2017 at 5:14 pm

#1965421
RE: Need you help on to find wait type

There's a 99% chance that it's the "bad code present" wait type. 😉
--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)

October 26, 2017 at 2:12 pm

#1965388
RE: new features in dev

Arjun SreeVastsva - Wednesday, October 25, 2017 8:04 PM
what are new features in sql server 2017 related dev
Gosh... just Google 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)

October 26, 2017 at 2:10 pm

#1965387
RE: Extreme slowness

Steve Jones - SSC Editor - Thursday, October 26, 2017 9:20 AM
FWIW, we brought a second web server online today. Let me...
--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)

October 26, 2017 at 2:09 pm

#1965385
RE: Transport error encountered when SOME queries run with batch terminator. Behaviour changes depending on text of query. WEIRD!

Which SP and CU is your 2012 server at? I ask because there were a shedload of problems before SP3 and even that didn't fix the problems they had and...
--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)

October 26, 2017 at 2:02 pm

#1965384
RE: how to validate my string in sql

Luis Cazares - Thursday, October 26, 2017 9:03 AM
kramaswamy - Thursday, October 26, 2017 8:43 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)

October 26, 2017 at 12:03 pm

#1965367

Viewing 15 posts - 13,936 through 13,950 (of 59,101 total)