Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,066 through 16,080 (of 59,067 total)

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
RE: SQL Reproting Failed to query

aokol (12/18/2016)
Or should we leave it like that and focus more on the query for the reports?
Performance, or a lack of it, is in the code. I'd concentrate 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)

December 18, 2016 at 10:08 pm

#1918610
RE: query to find out duplicate records in different databases

mcfarlandparkway (12/16/2016)
Hello,
I have a table,where it sits in 7 different databases. it has 7 different country information.
I want 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)

December 18, 2016 at 10:01 pm

#1918609
RE: Deleting files from backup drive

SQL-DBA-01 (12/16/2016)
Hi
I am calling this below command from .cmd batch file as I have no SQL Agent (express edition). But getting the below error while I try to run 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 18, 2016 at 9:57 pm

#1918607
RE: looking for a query to split string and save each portion to variables

halifaxdal (12/15/2016)
Thank you Steve,
Your solution is nice however will sometimes not applicable to some cases, like mine: I am not allowed to create stored procedures or functions on 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 18, 2016 at 6:00 pm

#1918603

Viewing 15 posts - 16,066 through 16,080 (of 59,067 total)