Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,271 through 21,285 (of 59,098 total)

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
RE: Serious Index fragmentation questions

What's in this table? Is it by any chance something like a log, audit, or invoice detail table?
--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:17 pm

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

ricardo_chicas (3/14/2015)
Hello All
I have a box with SQL Server 2008 R2, at the latest SP and CU, 16 cores and 196gb of ram (I also tested it at a copy...
--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 7:13 pm

#1784076
RE: Copy varchar(max) fields slow

Thanks, Terry. Sounds like you've done it right on the archive side.
On the DELETEs, remember that they affect ALL indexes and ALL FKs pointing at the table. If...
--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 6:55 pm

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

Just for grins, here are the results from the same test harness with only 500,000 rows. The times here will likely be shorter than for your production run because...
--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 6:47 pm

#1784074

Viewing 15 posts - 21,271 through 21,285 (of 59,098 total)