Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,476 through 23,490 (of 59,099 total)

RE: Help with the count function

SQLTestUser (6/5/2014)
Sweeeeeeeeeetttttt
The question is, do you understand the concept of "SARGability" the Luis explained? I ask because it's probably the single greatest obstacle to high performance code there 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)

June 5, 2014 at 7:34 pm

#1719510
RE: Need to Create Partition to an existing Table

rangu (6/5/2014)
I have an existing table with 34M records and is expected to grow further.
we have decided to partition the table.
we are planning to create a partition base on a...
--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 5, 2014 at 6:00 pm

#1719505
RE: uses of string splitters

Luis Cazares (6/4/2014)
sqldriver (6/4/2014)
I didn't see this code in the initial capitalization thread. It's what I've been using happily for a couple years. Not sure how it compares to 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)

June 4, 2014 at 3:54 pm

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

Koen Verbeeck (6/4/2014)
SQLRNNR (6/4/2014)
Evil Kraig F (6/3/2014)
SSIS: Crappy naming methods for your data sources. You're connecting this thing to a database and you're going to push it through environments....
--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 4, 2014 at 3:37 pm

#1719049
RE: CLR procedure not working

So where does the .txt file get written to, does that spot (folder) still exist on the new server and, if it does, can the new server still see 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)

June 4, 2014 at 3:19 pm

#1719040
RE: bcp syntax

You have single quotes around variables names. The RED plus signs are the give-away. You also had a scad of double quotes in the wrong places and 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 3, 2014 at 8:40 pm

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

patrickmcginnis59 10839 (6/3/2014)
Jeff Moden (6/3/2014)
My greatest pet peeve of all is what some people claim to be "best practices".
"Best practices" is pretty much a key phrase that helps gather recommendations...
--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 3, 2014 at 4:12 pm

#1718714
RE: Comparing performance of two versions of a query

Just a caution... if the view code uses scalar or multi-statement table value function, you really shouldn't be using SET STATISTICS as a measuring tool because it skews the results......
--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 3, 2014 at 1:52 pm

#1718679
RE: Error converting data type varchar to datetime.

ScottPletcher (6/3/2014)
sirishgreen (6/3/2014)
I thought I had cracked this issue but now....
and DE_Date between
'20140906' and '20140906'
This is being read as The 9th of June by SQL server.
After 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)

June 3, 2014 at 1:14 pm

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

My greatest pet peeve of all is what some people claim to be "best practices".
--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 3, 2014 at 1:09 pm

#1718648
RE: Sp & parameters

ramana3327 (5/31/2014)
First time it took 2000msec and later it took 5000msec.
If you want help with that, I recommend that you post the code and the execution plan.
--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 3, 2014 at 12:38 pm

#1718641
RE: Extracting data with headers using PowerShell

andycadley (6/3/2014)
Jeff Moden (6/3/2014)
I'm thinking that would make the process batch-job resistant.
How so? You can still specify the parameters on the command line, you can even specify them positionally 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)

June 3, 2014 at 12:29 pm

#1718635
RE: uses of string splitters

KoldCoffee (6/3/2014)
OK I'll take a look.
(on 'seriously', it was said with a wounded tone).:crying:
Ah... got it.
If you look at the WHERE clause, "N" will only be those values 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)

June 3, 2014 at 12:27 pm

#1718634
RE: Backup script from 2K not creating files on 2K8

Does the following path and batch file actually exist on the new machine?
'C:\Progra~1\BatchF~1\SQLBac~1\ZIP.BAT
--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 3, 2014 at 7:52 am

#1718541
RE: Extracting data with headers using PowerShell

@louis Li,
I realize that $dt is a loop variable but what did you intend that "dt" stand for? I'd also like to know why the use of $1? ...
--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 3, 2014 at 7:33 am

#1718536

Viewing 15 posts - 23,476 through 23,490 (of 59,099 total)