Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,221 through 17,235 (of 59,067 total)

RE: TEMPDB LOG explosive growth

Sounds like they're on the right track. Thank you for the feedback.
--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)

July 18, 2016 at 1:57 pm

#1890712
RE: Script to stop service using XP_CMDSHELL, restore full and differential .bak files in a single script

lsalih (7/18/2016)
Jeff -
I once had a hard time placing the database back to multiuser mode, that is why I am avoiding placing database into single mode or offline during DB...
--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)

July 18, 2016 at 1:55 pm

#1890711
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

CELKO (7/18/2016)
Numbers are numbers and your arguing the interface (infix versus RPN) somehow makes them different.
Quite the contrary. I'm arguing that you should use whatever features are available in...
--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)

July 18, 2016 at 12:55 pm

#1890694
RE: Streaming itvf in CLR to replace special characters

Lynn Pettis (7/18/2016)
Still turns out there may be a limit to the number of replaces you can nest. Originally I was looking at 53 different characters, now it that...
--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)

July 18, 2016 at 12:42 pm

#1890691
RE: Streaming itvf in CLR to replace special characters

Luis Cazares (7/18/2016)
I didn't remember this when you first posted your problem, but have you tried using SQL#? It has Replace functions that might help you.
http://www.sqlsharp.com/
Although claims of performance have...
--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)

July 18, 2016 at 12:41 pm

#1890690
RE: Script to stop service using XP_CMDSHELL, restore full and differential .bak files in a single script

lsalih (7/18/2016)
I guess I was not thinking straight when putting this script together, I now understand how to approach the restore better. Thank you all for your great input. Lava
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)

July 18, 2016 at 12:35 pm

#1890688
RE: What is the best to remove xp_cmdshell calls from t-sql code

You bet. If you get the chance, let us know how it worked out for you one way or another. Thanks!
--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)

July 18, 2016 at 8:11 am

#1890604
RE: TEMPDB LOG explosive growth

JarJar (7/18/2016)
twice in the last week the tempdb LOG has filled it's disk. i've never had an issue with the LOG file for tempdb, it's always been sized quite small...
--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)

July 18, 2016 at 6:36 am

#1890578
RE: Covering indexes in joins

Imke Cronje (7/18/2016)
Don't worry....I already figured it out.
Its a clustered index scan and when I include both indexes in the joins it returns a Seek instead of a Scan.
Now all...
--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)

July 18, 2016 at 6:21 am

#1890574
RE: Skills Upgrading

If it's the Database Developer world you seek, I agree... a lot has changed. But even more has not and your previous skills will serve you well.
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)

July 18, 2016 at 6:17 am

#1890573
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

babap (7/18/2016)
Not sure I buy the metaphor of scientific calculator vs. basic calculator---does not apply.
In most cases, neither does portability. 😉 Not everyone needs applications that will...
--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)

July 18, 2016 at 5:26 am

#1890560
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

Jeff Moden (7/15/2016)
asutorius (7/15/2016)
I was curious how these two concatenate examples compared in speed, I placed the examples in their own tabs in my local Sql Server 2014 and turned...
--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)

July 17, 2016 at 9:24 pm

#1890509
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

CELKO (7/17/2016)
I attended an IBM briefing on analytic functions in version 11 of DB2 last week. Part of the presentation consisted of showing TBC analytic benchmarks, which are some pretty...
--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)

July 17, 2016 at 8:39 pm

#1890507
RE: count(null)

Your turn, please. 😉
Why would you ever need to do a SELECT COUNT(NULL)?
--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)

July 17, 2016 at 1:52 pm

#1890494
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

babap (7/16/2016)
BEWARE...these short cuts are NOT either ISO SQL standard or ANSI SQL.
This is going back in time BEFORE the ISO SQL standard was created.
Shortcuts create long term pains!!!
Keep in...
--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)

July 17, 2016 at 12:05 pm

#1890491

Viewing 15 posts - 17,221 through 17,235 (of 59,067 total)