Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,641 through 11,655 (of 59,095 total)

RE: Finding a String Anywhere in Another String

Eirikur Eiriksson - Sunday, August 5, 2018 8:48 AM
Jeff Moden - Sunday, August 5, 2018 8:11 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)

August 5, 2018 at 11:31 am

#2000342
RE: Cursor object running when @@FETCHSTATUS 0

Eirikur Eiriksson - Sunday, August 5, 2018 9:11 AM
Jeff Moden - Sunday, August 5, 2018 8:22 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)

August 5, 2018 at 10:37 am

#2000338
RE: Why QUOTENAME is important

Great article on QUOTENAME, Thom, especially with the considerations given for SQL Injection, which is still rampant in the industry.
Andy also brings up a great point. A lot...
--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)

August 5, 2018 at 8:53 am

#2000329
RE: Cursor object running when @@FETCHSTATUS 0

p.s. Andy posted while I was typing... that's the basic idea of what I'm talking about.
--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)

August 5, 2018 at 8:22 am

#2000326
RE: Cursor object running when @@FETCHSTATUS 0

Arsh - Sunday, August 5, 2018 3:16 AM
Dear All,
I've attached the SP in this file for reference in case the code...
--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)

August 5, 2018 at 8:19 am

#2000325
RE: Finding a String Anywhere in Another String

Eirikur Eiriksson - Sunday, August 5, 2018 7:12 AM
Jeff Moden - Sunday, August 5, 2018 5:39 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)

August 5, 2018 at 8:11 am

#2000324
RE: Finding a String Anywhere in Another String

Eirikur Eiriksson - Sunday, August 5, 2018 3:40 AM
The Azure S tier instances are very low spec and are no match 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)

August 5, 2018 at 5:39 am

#2000317
RE: Unused space; shrink or not shrink

rpeters76 - Thursday, August 2, 2018 11:54 PM
Thank you all!!
With the log file, I don't have an issue because we use 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)

August 4, 2018 at 2:05 pm

#2000286
RE: hashbytes

First things first... stop using MD5. Seriously... stop using it NOW and pretend it never existed. Its old, it's slow, it's fairly easy for hackers to break especially if they're...
--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)

August 4, 2018 at 1:53 pm

#2000285
RE: Bulk loads versus Bulk inserts (Oracle DB as data source)

Which one is faster??? Test it and find out because the answer is and always will be, "It Depends". 😉
--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)

August 4, 2018 at 12:07 pm

#2000280
RE: Is SQL Server Mature?

99zardoz - Friday, August 3, 2018 10:11 AM
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)

August 4, 2018 at 12:02 pm

#2000279
RE: parsing log data

My answer would be to simply pork chop the people that are creating such inconsistent data and doubling the size of the log files with totally unnecessary labels. Things like...
--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)

August 4, 2018 at 11:55 am

#2000277
RE: Are the posted questions getting worse?

Heh.... Except for T-SQL (which has a dash in it), I try to avoid all the 4 letter words in SQL Server, especially SSIS and SSRS.
--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)

August 4, 2018 at 11:38 am

#2000276
RE: Finding a String Anywhere in Another String

Janeta Parakosova - Thursday, August 2, 2018 1:34 PM
Hi Jeff,
I used GUIDs to generate random strings with LEFT(NEWID(), 20) for the article....
--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)

August 4, 2018 at 11:06 am

#2000273
RE: Need help to extract unstructured excel data to sql server

Eirikur Eiriksson - Saturday, August 4, 2018 10:01 AM
Jeff Moden - Saturday, August 4, 2018 9:57 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)

August 4, 2018 at 10:36 am

#2000272

Viewing 15 posts - 11,641 through 11,655 (of 59,095 total)