Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,571 through 18,585 (of 59,072 total)

RE: Joining Tables with Right Function

ChrisM@Work (1/18/2016)
Jeff Moden (1/18/2016)
ChrisM@Work (1/18/2016)
Jeff Moden (1/18/2016)[hrCan we agree on "SARGable in one direction only" as it's often sufficient to permit tweaking a decent plan?
With the battles I'm currently facing...
--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)

January 18, 2016 at 9:55 am

#1852537
RE: Joining Tables with Right Function

ChrisM@Work (1/18/2016)
Jeff Moden (1/18/2016)[hrCan we agree on "SARGable in one direction only" as it's often sufficient to permit tweaking a decent plan?
With the battles I'm currently facing at work on...
--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)

January 18, 2016 at 7:32 am

#1852512
RE: Having fun with PARSENAME (SQL Spackle)

Eirikur Eiriksson (1/18/2016)
Network endian-ness is predominantly big-endian and the method NetworkToHostOrder will swap the byte order to small-endian. This tells me that you are storing the IPs as big-endian bigint...
--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)

January 18, 2016 at 7:15 am

#1852510
RE: Having fun with PARSENAME (SQL Spackle)

thierry.vandurme (1/18/2016)
I think these helper functions are now deprecated and you need to add a directive to the code to ignore the warnings about that.
Thanks, Thierry.
Heh... deprecation. It's...
--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)

January 18, 2016 at 7:10 am

#1852509
RE: Turn Out the Lights

I think it ironic that the same people that are concerned with the "cost savings" of allowing CPUs to "turn down" are frequently the same people that say disk space...
--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)

January 18, 2016 at 6:15 am

#1852492
RE: Joining Tables with Right Function

ChrisM@Work (1/18/2016)
VegasL (1/15/2016)
Thanks Luis, the last one appears straightforward, concatenation with fixed characters. However when I try on actual table without the # temp tables, i get incorrect...
--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)

January 18, 2016 at 5:37 am

#1852482
RE: Having fun with PARSENAME (SQL Spackle)

It sounds like your BIGINT idea was a great success and it doesn't sound like you ran into any form of endian problems because of it. Thanks again for...
--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)

January 18, 2016 at 5:26 am

#1852479
RE: Having fun with PARSENAME (SQL Spackle)

Eirikur Eiriksson (1/17/2016)
Jeff Moden (1/17/2016)
Eirikur Eiriksson (1/17/2016)
thierry.vandurme (1/15/2016)
Nice article. May come in use one day so glad you shared that.
Btw, I use bigint to store IP4 addresses (less space 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)

January 17, 2016 at 1:38 pm

#1852428
RE: "SQL Agent - Alert Engine"

Mr_Q (1/17/2016)
Hi,
In SQL Server 2005 Standard Edition SP 1, i made a selection from sys.sysprocesses. One of processes is called "SQL Agent - Alert Engine". I need to know 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)

January 17, 2016 at 1:06 pm

#1852427
RE: Constant Recycling of Main SQL Error Logs

It sounds to me like someone is trying to cover their tracks or is playing around with some method to keep the logs "manageable".
I don't know if log recycling 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)

January 17, 2016 at 12:40 pm

#1852425
RE: Having fun with PARSENAME (SQL Spackle)

Eirikur Eiriksson (1/17/2016)
thierry.vandurme (1/15/2016)
Nice article. May come in use one day so glad you shared that.
Btw, I use bigint to store IP4 addresses (less space and able to use ORDER...
--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)

January 17, 2016 at 12:26 pm

#1852423
RE: Joining Tables with Right Function

Ed Wagner (1/15/2016)
Did you read what Jeff posted? Using a function on a join predicate is going to result in a scan, which is very inefficient. The function...
--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)

January 17, 2016 at 11:05 am

#1852420
RE: Retrieve specific cell value from Excel into SSIS variable

No pun intended but EXCELlent work, Orlando. 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)

January 17, 2016 at 10:57 am

#1852419
RE: Having fun with PARSENAME (SQL Spackle)

thierry.vandurme (1/17/2016)
Hi Jeff,
as always appreciate your responses & tips. I was being a bit short-sighted in that the app we use doesn't need the functionality to pick a specific part...
--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)

January 17, 2016 at 9:27 am

#1852417
RE: Muting the Immutable

From the Article:
However, this doesn't suit some build systems, such as SSDT. It makes the mistake of believing that a build should contain only DDL.
Heh... the faster we go,...
--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)

January 16, 2016 at 5:08 pm

#1852406

Viewing 15 posts - 18,571 through 18,585 (of 59,072 total)