Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,531 through 10,545 (of 59,102 total)

RE: parse string and check for valid date

Bruin - Friday, November 23, 2018 6:05 AM
I was looking for a generic Insert that would read a csv and dynamically create...
--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 24, 2018 at 10:41 am

#2014424
RE: Inner joins

drew.allen - Friday, November 23, 2018 8:16 AM
Jeff Moden - Wednesday, November 21, 2018 1:03 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 23, 2018 at 12:08 pm

#2014409
RE: Tempdb and prop fill

sqlguy7777 - Thursday, November 22, 2018 6:32 PM
Hi
We have a SQL 2012 server with Tempdb that has 4 data files.
The Tempdb...
--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 22, 2018 at 6:55 pm

#2014370
RE: Getting the main course right

Ah... beware... I just had a trusted friend tell me that he's been testing TRANSLATE and that, unless you use something like binary collation, it's a dog for performance. I...
--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 22, 2018 at 5:33 pm

#2014367
RE: Looking for a great candidate in Virginia Beach - ASAP

I'm curious. What if you can't find someone that's both a good solid Mid-Level DBA and has a Secret Clearance? What if you can only find a good solid Mid-Level...
--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 22, 2018 at 2:37 pm

#2014359
RE: slow query

atulyan.aries - Wednesday, November 7, 2018 2:11 PM
the query has a Where clause that 2 conditions combined via AND. If only 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)

November 22, 2018 at 2:19 pm

#2014358
RE: Slow run time

Admingod - Wednesday, November 7, 2018 10:25 AM
Thanks! However, i don't need help on the execution plan, all i am looking for...
--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 22, 2018 at 2:13 pm

#2014357
RE: SUM Function Group by Status and User displayed on columns

octavioromano - Thursday, November 22, 2018 1:29 PM
Beautiful, works like a charm.
Thanks a lot for your help.
Kind regards,
Octavio
The question now is, if...
--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 22, 2018 at 2:08 pm

#2014356
RE: Basic Question: Do you have to restart the instance if you change database or log file growth

bdkdavid - Wednesday, November 21, 2018 5:37 PM
Hi Jeff and Sue,
Yes the 13 TB file is the mdf file. I just started...
--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 22, 2018 at 1:56 pm

#2014355
RE: Inner joins

drew.allen - Wednesday, November 21, 2018 11:33 AM
Jeff Moden - Wednesday, November 21, 2018 9:06 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 22, 2018 at 1:48 pm

#2014354
RE: parse string and check for valid date

Bruin - Wednesday, November 21, 2018 7:00 AM
Need an example of how to wrap the if statement checking if date exists 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)

November 22, 2018 at 1:41 pm

#2014353
RE: Natural Sort Order

Jason A. Long - Tuesday, November 20, 2018 10:50 PM
Of course, the mere fact that I can't think of a legitimate...
--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 22, 2018 at 1:38 pm

#2014352
RE: Break Problems Down

Frank W Fulton Jr - Tuesday, November 20, 2018 7:24 PM
Back in the Day when we used Punch Cards, Terminals and Teletypes,...
--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 22, 2018 at 1:30 pm

#2014350
RE: Exif data into a database.

ben.brugman - Thursday, November 22, 2018 3:07 AM
Ricky Lively - Wednesday, November 21, 2018 6:14 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 22, 2018 at 1:04 pm

#2014346
RE: Obfuscating character columns

Hmmm... if an individual AgentName appears in all 200 databases in multiple tables and multiple times in those tables, wouldn't you want the obfuscation to be exactly the same for...
--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 21, 2018 at 5:13 pm

#2014305

Viewing 15 posts - 10,531 through 10,545 (of 59,102 total)