Forum Replies Created
Viewing 15 posts - 25,441 through 25,455 (of 59,099 total)
-
RE: Sql Server data replication
SPAM reported.
--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) -
RE: Table patitioning / partition switching
SPAM reported.
--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) -
RE: Wrong statistics and IO with CASE
tony28 (11/8/2013)
Hello,it is possible that if I use column = CASE when etc.. will use wrong statistics and lot of logical reads ? I see first, because first time 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) -
RE: Effectiveness
Steve Jones - SSC Editor (11/9/2013)
Jeff Moden (11/8/2013)
But "good enough" frequently means that something simply works for 5 or 10 rows and they ship it and that ain't "right". ;-)...
--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) -
RE: What Do You Want to Learn?
arnipetursson (11/8/2013)
A talk about how to determine the right tool for the job.Very cool. I'll start with a bit of a play on words. "Just because you CAN...
--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) -
RE: Effectiveness
Gary Varga (11/9/2013)
Jeff Moden (11/9/2013)
Gary Varga (11/8/2013)
Jeff Moden (11/7/2013)
..."Doing it right the first time" shouldn't be just a motto. It should be the best of all practices.Absolutely, but 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) -
RE: Effectiveness
Gary Varga (11/8/2013)
Jeff Moden (11/7/2013)
..."Doing it right the first time" shouldn't be just a motto. It should be the best of all practices.Absolutely, but in the context of 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) -
RE: T-SQL Performance tuning on Aggregates
d_uvarajan (11/9/2013)
Attached the execution plan. Please refer "Query 54" in the plan.
If you could not ableto view it, please let me know the steps to upload the same. (I clicked...
--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) -
RE: Scalar UDF different performance on different server
Bhuvnesh (11/8/2013)
TheSQLGuru (11/8/2013)
the engine LIES to SSMS when UDFs are in play.please elaborate. Or ANy article reference.
Here's the proverbial tip of the iceberg on that subject...
http://www.sqlservercentral.com/articles/T-SQL/91724/
--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) -
RE: Script to Delete Reports Older than a Certain Number of Days
hisakimatama (11/9/2013)
Huh, so doing that via command-line syntax is possible! Guess I slipped up on that one :-P. I seem to recall trying to do something similar via...--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) -
RE: Effectiveness
BWAAA-HAAAA!!!! I just saw one of the recent posts on the "Today's Random Word" thread. The word that was posted was "erroneous". Thanks to this thread, 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) -
RE: Today's Random Word!
SQLRNNR (11/7/2013)
erroneous"Good Enough" to ship. (but not in my shop)
--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) -
RE: Effectiveness
Steve Jones - SSC Editor (11/8/2013)
Jeff Moden (11/7/2013)
"Doing it right the first time" shouldn't be just a motto. It should be the best of all practices.
What's "right"?
What is...
--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) -
RE: Testing for legitimate Time data type
RedBirdOBX (11/8/2013)
This one is giving me a lot of grief!!Check this out:
SELECT
CASE
WHEN ISDATE([InspectionTime]) = 1 THEN
CONVERT(TIME, [InspectionTime], 114)
ELSE
[InspectionTime]
END
FROM Inspection38
"InspectionTime" is a field that will contain some bad data...
--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) -
RE: Script to Delete Reports Older than a Certain Number of Days
hisakimatama (11/8/2013)
Using xp_cmdshell may work, but it doesn't have the flexibility of Powershell....{snip}...
if you need file-extension filtering, I may be able to alter it as needed.
BWAAA-HAAA!!!! Too funny. ...
--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)
Viewing 15 posts - 25,441 through 25,455 (of 59,099 total)