Jeff Moden

Forum Replies Created

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

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
RE: Should I use Insert Trigger or not?

My recommendation is that you be really careful in your trigger design. As Kevin pointed out, the trigger won't be a performance problem if you write good code and that's...
--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 11:19 am

#1965364
RE: Unstructured Data

With the idea of coming up with a "better term" for such data, I've always kept it simple... "Other Junk". When I need to be more politically correct, I call...
--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 9:30 am

#1965342
RE: Update 600,000 rows in table

Ambatinr - Tuesday, October 3, 2017 12:36 PM
HiI need to update 600,000 rows in the table column with files from the...
--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 9:23 am

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

lars.hesselberg 49028 - Tuesday, October 24, 2017 8:30 AM
Hi Jeff,
However, you still have the issue of a Cartesian join between the...
--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:53 am

#1965325
RE: Join on a Substring

sgmunson - Thursday, October 26, 2017 8:39 AM
jjf410 - Wednesday, October 25, 2017 12: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)

October 26, 2017 at 8:48 am

#1965323
RE: Making Indexes Invisble to the Optimiser

kevaburg - Thursday, October 26, 2017 5:33 AM
"Help stop dis-information and misinformation. Stop promulgating such anecdotal recommendations."
Hi Jeff....I read through my...
--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:44 am

#1965319

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