Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,601 through 18,615 (of 59,098 total)

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
RE: Tempdb on RamDisks or SSDs - two-node cluster?

Indianrock (1/16/2016)
Clarification: the current system has been C# .NET ORM for years -- so it was changes to code, not a move to ORM. I suspect development 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 16, 2016 at 2:42 pm

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

Orlando Colamatteo (1/16/2016)
Jeff Moden (1/15/2016)
murtzd (12/17/2015)
Hi all,
I'm experiencing a very frustrating issue. I am using the guide below to read a cell value in Excel into a SSIS variable;
http://www.techbrothersit.com/2013/11/ssis-read-excel-cell-value-in-ssis.html
It works...
--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 1:09 pm

#1852395
RE: Tempdb on RamDisks or SSDs - two-node cluster?

Indianrock (1/16/2016)
Thanks for the feedback. Changes to the ORM-generated sql would no doubt make big difference, as would creating a data warehouse so "report-type" queries aren't run against 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)

January 16, 2016 at 12:41 pm

#1852391
RE: Tempdb on RamDisks or SSDs - two-node cluster?

I can't help but think that adding more memory to the system and putting the log files on non-volatile SSDs would be a larger benefit, overall. Also, you might...
--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 9:37 am

#1852382

Viewing 15 posts - 18,601 through 18,615 (of 59,098 total)