Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,241 through 21,255 (of 59,072 total)

RE: Using powershell in tsql scripts

I believe you've been bitten by the dynamic SQL. To prove what I'm thinking the problem is, change all of your path, filename, and other variables that have anything...
--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)

March 16, 2015 at 4:59 pm

#1784375
RE: Trigger for updates on a row using previous record value?

CELKO (3/16/2015)
Do you know of any SQL engine that has a function that will convert that ISO format directly to a "week start date"?
DB2, Ingres, Postgres 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)

March 16, 2015 at 4:50 pm

#1784373
RE: Trigger for updates on a row using previous record value?

CELKO (3/15/2015)
It is not denormalized; it is another temporal scale exactly like the Common Era Calendar is a scale. This is like saying a measurement in meters instead of...
--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)

March 16, 2015 at 7:53 am

#1784254
RE: Using powershell in tsql scripts

kevaburg (3/16/2015)
roger.price-1150775 (3/16/2015)
Not seen SQL call Powershell but seen lots of powershell scripts calling SQL.
Why are you renaming the files ?
If it's to ensure a file is only processed once...
--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)

March 16, 2015 at 7:45 am

#1784249
RE: Serious Index fragmentation questions

Understood. Any kind of a table can have those things. What I'm trying to find out is what is the "business reason" for the table. In other...
--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)

March 15, 2015 at 2:30 pm

#1784130
RE: Help New Query Needed

It doesn't matter much because of the high speed machines available but the WHERE NOT EXISTS will be a bit more efficient than the LEFT JOIN with the NULL detection.
I'd...
--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)

March 15, 2015 at 2:24 pm

#1784128
RE: Using powershell in tsql scripts

I'm not sure why anyone would think that file handling with PowerShell is any better than it is with DOS, but that's another subject.
To the best of my knowledge, there...
--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)

March 15, 2015 at 2:19 pm

#1784125
RE: Question: Teasing apart a bit-field and storing the results in table rows

As you know, the "&" is a bit mask for a bit-wise AND. If we take the simple problem of the number number "15" for the Config Value 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)

March 15, 2015 at 12:31 pm

#1784120
RE: Try It

vliet (3/15/2015)
Trying to solve problems with the knowledge at hand undoubtedly has some benefits. At least one person on your site will have hands-on experience with it because he or...
--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)

March 15, 2015 at 11:51 am

#1784119
RE: SQL choosing to use the worst possible index

It almost sounds like a "simple" case of "bad" parameter sniffing.
--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)

March 15, 2015 at 11:33 am

#1784117
RE: delete data from partitions - faster approach

Switching that partition out like you did should be instantaneous because it only changes the meta data if you built the target table on the same file group (not even...
--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)

March 15, 2015 at 11:29 am

#1784116
RE: Convert RGB color to HEX Color using SQL

thomashohner (3/15/2015)
That Bit Bash is sweet! Wow, so cool. I'm not sure why this is exciting but it is. 😀
Heh... I can't speak for anyone else but I like this...
--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)

March 15, 2015 at 11:19 am

#1784115
RE: Convert RGB color to HEX Color using SQL

Eirikur Eiriksson (3/15/2015)
Quick note on the sys.fn_varbintohexstr function, DON'T use it, use CONVERT instead. A little while back I was working with a large set of MD5 checksums and 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)

March 15, 2015 at 11:15 am

#1784114
RE: Convert RGB color to HEX Color using SQL

Eirikur Eiriksson (3/15/2015)
Brilliant as always Jeff!
Having had the first portion of my industrial strength espresso this morning it dawned on me that simple bit-bashing would do the job
😎
Reversing the byte...
--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)

March 15, 2015 at 11:12 am

#1784113
RE: Today's Random Word!

eccentricDBA (3/13/2015)
Ed Wagner (3/13/2015)
crookj (3/13/2015)
Revenant (3/13/2015)
Ed Wagner (3/13/2015)
djj (3/13/2015)
crookj (3/13/2015)
Ed Wagner (3/13/2015)
djj (3/13/2015)
Ed Wagner (3/13/2015)
jasona.work (3/13/2015)
Stuart Davies (3/13/2015)
SQLRNNR (3/12/2015)
drone
Bee
Happy
Peaceful
Flower Power
1960s
Hippy
Dippy
Dopey
Grumpy
Stinky (one of the 7 other dwarves by Craig Shaw Gardner)
Limburger
Cheesy
Heh......
--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)

March 14, 2015 at 8:31 pm

#1784081

Viewing 15 posts - 21,241 through 21,255 (of 59,072 total)