Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,096 through 16,110 (of 59,101 total)

RE: CPU Spikes Caused by Periodic Scheduled Jobs

Spreading out jobs to avoid spikes is a good idea BUT... the real fact is that even after all you did, you're still taking spikes to 40% of ALL 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)

December 20, 2016 at 9:07 pm

#1919074
RE: SQL Reproting Failed to query

Since you can't provide us with the queries to even try to help, then there's only one option. Instead of going through all of this yourself, get a hold...
--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)

December 20, 2016 at 8:52 pm

#1919073
RE: IF Exist Delete file and copy a Template File VB.NET Script Task

Welsh Corgi (12/20/2016)
Command Task?
No... sorry. I meant EXEC Task but, like it says on one of the other two posts on this subject, a File System Task is probably...
--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)

December 20, 2016 at 2:14 pm

#1919033
RE: IF Exist Delete file and copy a Template File VB.NET Script Task

Welsh Corgi (12/20/2016)
I moved the post to http://www.sqlservercentral.com/Forums/Topic1844606-364-1.aspx
You really need to not do that anymore. This is the 3rd post on the same subject. Most of the heavy...
--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)

December 20, 2016 at 1:52 pm

#1919024
RE: IF Exist Delete file and copy a Template File VB.NET Script Task

Welsh Corgi (12/20/2016)
Jeff,
I only got the delete part complete:
Public Sub Main()
Dim FileToDelete As String
FileToDelete...
--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)

December 20, 2016 at 1:49 pm

#1919023
RE: Date dimension showing times

richardmgreen1 (12/20/2016)
Hi Jeff
Unless the computed columns in the table are defined as "PERSISTED", then this table is as bad or worse than using a view to create the same thing.
None...
--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)

December 20, 2016 at 1:43 pm

#1919021
RE: IF Exist Delete file and copy a Template File VB.NET Script Task

Welsh Corgi (12/20/2016)
Please disregard this post.
If you found an answer to your own question, it would be really cool if you posted your solution because it may help others in...
--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)

December 20, 2016 at 1:12 pm

#1919013
RE: Performance Finger pointing: suggestions on next steps.

If the same SSIS package runs fine everyone except on one server, it's likely a hardware problem or a hardware setting problem. The first thing I'd check for 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)

December 20, 2016 at 1:09 pm

#1919012
RE: Date dimension showing times

Unless the computed columns in the table are defined as "PERSISTED", then this table is as bad or worse than using a view to create the same thing.
I'll also state...
--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)

December 20, 2016 at 9:22 am

#1918953
RE: Why Shouldn't I use Linked server?

Eric M Russell (12/20/2016)
If your application needs to join Customers with PurchaseOrders, and your Customer table on ServerA, and your PurchaseOrder table on ServerB, then that architectural decision itself has...
--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)

December 20, 2016 at 7:57 am

#1918925
RE: Why Shouldn't I use Linked server?

I just went through something like this yesterday. It looked like we needed to make local copies of some of the databases (replication, some other method, whatever) 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)

December 20, 2016 at 6:57 am

#1918899
RE: Are the posted questions getting worse?

jasona.work (12/19/2016)
BLOB EATER (12/19/2016)
GilaMonster (12/19/2016)
BLOB EATER (12/19/2016)
GilaMonster (12/19/2016)
Grant Fritchey (12/19/2016)
BLOB EATER (12/19/2016)
I am 90% sure that I will be going to sqlbits in April, anyone else know if they will...
--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)

December 19, 2016 at 11:41 pm

#1918804
RE: Help with XML Splitter De-entitization, please.

Thanks, Mikael. I appreciate the great information and the caveat alert on CDATA.
Even after two decades in this community, I continue to be amazed at the ancillary information that...
--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)

December 19, 2016 at 8:08 am

#1918684
RE: The Toolchain for the Job?

chrisn-585491 (12/19/2016)
I currently have some batch jobs being called by Task Scheduler doing some simple ETL processes.
Why?
Because it's the easiest to deploy and maintain for the non-programmers in my...
--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)

December 19, 2016 at 8:01 am

#1918681
RE: The Toolchain for the Job?

Phil Factor (12/19/2016)
Somewhere, there is a large corporation that curses and swears at a system I put in place twenty years ago that did an ETL job. It is still...
--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)

December 19, 2016 at 8:00 am

#1918680

Viewing 15 posts - 16,096 through 16,110 (of 59,101 total)