Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,586 through 18,600 (of 59,072 total)

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

Indianrock (1/15/2016)
We're looking at one of those for tempdb. I believe tempdb is good with 8 30GB data files ( all same size with same autogrowth ). Each...
--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 7:42 am

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

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 very well for 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)

January 15, 2016 at 8:28 pm

#1852355
RE: Fast CSV Reader

Orlando Colamatteo (1/15/2016)
The fact that the author is not citing RFC4180 is troubling. This is exactly where many implementations start out on a bad foot, namely they are making up...
--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 15, 2016 at 12:31 pm

#1852321
RE: DBCC DBREINDEX - Everynight?

Jeff Moden (1/15/2016)
Johnny B (1/15/2016)
We are running DBCC DBREINDEX on every table every night. This is for a long term archive which is updated every 15 minutes then purged nightly....
--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 15, 2016 at 11:28 am

#1852310
RE: Joining Tables with Right Function

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 syntax...
--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 15, 2016 at 11:25 am

#1852308
RE: Joining Tables with Right Function

VegasL (1/15/2016)
Hello,
I want to join #tbl1 with #tbl2, where the values in #tbl2 should match #tbl1. The problem is in #tbl1 I have fixed amount of characters value to...
--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 15, 2016 at 10:09 am

#1852292
RE: Getting column change history...

PiMané (1/15/2016)
I changed the final CTE query to:
SELECT t0.* FROM data t0
LEFT JOIN data t1 ON t0.row - 1 = t1.row
WHERE t0.price <> t1.price OR t1.price IS NULL
ORDER BY t0.historyDate
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 15, 2016 at 10:05 am

#1852291
RE: DBCC DBREINDEX - Everynight?

Johnny B (1/15/2016)
We are running DBCC DBREINDEX on every table every night. This is for a long term archive which is updated every 15 minutes then purged nightly. After being...
--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 15, 2016 at 10:03 am

#1852290
RE: Bulk Insert a SQL Statement?

imba (1/14/2016)
I have a data output that looks like this:
code="sql"]SELECT A+|+B+|+C[/code]
Output is A|B|C similar to a text file.
Is there anyway that I can insert A, B, C into a 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)

January 15, 2016 at 8:40 am

#1852273
RE: Security Convenience

Heh... the title of this article should be titled "Security vs Convenience" because the current title is actually a bit of an oxymoron.
What I mean by that is that Active...
--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 15, 2016 at 8:31 am

#1852269
RE: Partition woes

In that case, I'd first make a backup of the database, switch out the large partition, and hammer one partition of data back into place at a time using CREATE...
--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 15, 2016 at 8:06 am

#1852265

Viewing 15 posts - 18,586 through 18,600 (of 59,072 total)