Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,401 through 23,415 (of 59,099 total)

RE: Just curious, what are your SQL pet peeves ?

below86 (6/18/2014)
andrew gothard (6/18/2014)
below86 (6/16/2014)
andrew gothard (6/15/2014)
Koen Verbeeck (6/14/2014)
Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do that in your Order...
--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)

June 18, 2014 at 7:29 am

#1722785
RE: Counting the characters in a string before a space

cbrammer1219 (6/15/2014)
Here's the file being processed.
It's really tough to hit a rolling donut. Where'd the file go?
--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)

June 17, 2014 at 9:28 pm

#1722567
RE: Script to track row changes of multiple tables

Maybe something like this:
Create and preset a variable at the beginning of the code...
DECLARE @TableChanged TINYINT;
Then add something like the following after each Insert, Update, or Delete of the tables.
SELECT...
--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)

June 17, 2014 at 9:22 pm

#1722566
RE: String occurrence count with Cross apply

clayman (6/17/2014)
Thank you for your quick response. Table @t may store up to 25,000 rows (I used table variable just for demonstration purposes) and yes it is a varchar(max).
Yes,...
--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)

June 17, 2014 at 9:10 pm

#1722565
RE: Drop table rollback

sugnu iu (6/17/2014)
one of my users performed a DROP TABLE on a table with 96 million rows.
The logical question now would be...
Why do you have users that have such high...
--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)

June 17, 2014 at 10:19 am

#1722395
RE: The Last Line of Defense

GilaMonster (6/17/2014)
Simple, I make very, very sure that I'm not indispensable.
I make sure that others can do the majority of what I do, doesn't have to be as...
--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)

June 17, 2014 at 10:13 am

#1722393
RE: How to join to a comma delimited list

rightontarget (6/16/2014)
Thank you.
I also found this:
http://stackoverflow.com/questions/13873701/convert-comma-separated-column-value-to-rows
That uses both an XML conversion and concatenation. That also makes it comparatively slow. Here's a comparison chart for 1,000 CSVs. ...
--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)

June 16, 2014 at 8:26 pm

#1722120
RE: Split csv records to seperate columns

ykonline (6/13/2014)
As per requirement we are not supposed to use UDF
I suspect the people that made that requirement don't know that UDFs have 3 forms, one of which (the iTVF...
--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)

June 16, 2014 at 5:15 pm

#1722116
RE: TempDB Log file usage constantly rising and file keeps growing.

I don't have a link to the article on the self-explosive growth but, IIRC, 1 GB initial size and 128MB growth was the recipe for the fault... especially thee 128MB...
--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)

June 16, 2014 at 8:53 am

#1721981
RE: Adding YYYYMMDD and HHMMSS to get mm/dd/yyyy HH:MM:SS

Have you got a link that you could PM me? I need to take a look at it to see what you're 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)

June 16, 2014 at 8:46 am

#1721978
RE: Strange backups in sql server logs

stmarti (6/6/2014)
This is a nice bonus of sbs, I have no problem with it. What is strange I see no option at all to control this behavior, and not found...
--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)

June 16, 2014 at 8:10 am

#1721962
RE: Policies/Procedures on preventing after hours calls

I wouldn't adivse them of anything. They should be following a written procedure that helps them make better decisions. Ask to see the written procedure so that you...
--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)

June 16, 2014 at 7:54 am

#1721954
RE: TempDB Log file usage constantly rising and file keeps growing.

There used to be a problem associated with which settings where used for initial size and growth. I also understand that they had a couple of problems with "regression...
--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)

June 16, 2014 at 7:47 am

#1721952
RE: Backup database to disk ''NUL''

tlbeta (6/16/2014)
Beatrix Kiddo (6/16/2014)
Why have you bumped a 9 year old thread?
Oh, sorry, not realized this is a very old thread. I googled this by chance. When I read through...
--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)

June 16, 2014 at 7:29 am

#1721943
RE: Adding YYYYMMDD and HHMMSS to get mm/dd/yyyy HH:MM:SS

Eirikur Eiriksson (6/15/2014)
And of course I have been careful not to do funny stuff with datetime since someone told me off a while back 😀
Gosh, I hope that wasn't 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)

June 15, 2014 at 2:40 pm

#1721812

Viewing 15 posts - 23,401 through 23,415 (of 59,099 total)