Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,911 through 20,925 (of 59,098 total)

RE: Exclude Columns When Using Bulk Insert

anju04n6 (4/29/2015)
Help needed please
I am trying to run below query fro bulk insert
SELECT MATNR,CASE WHEN ERSDA='00000000' THEN NULL ELSE CONVERT(datetime, ERSDA, 102) END AS ERSDA,ERNAM, CASE WHEN ...
--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)

April 30, 2015 at 12:45 am

#1794572
RE: Is It Time to Upgrade?

To be honest, with what happened with 2005 when it first came out and to 2012 over it's life until Sp2-Cu5 and what recently happened with 2014 Sp1, I couldn't...
--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)

April 29, 2015 at 11:05 pm

#1794561
RE: Transaction log is not shrink although there is scheduled transaction log backup

Set your transaction log backups to backup once every 30 minutes 24 hours a day. Nights are actually where this is needed the most because of things like index...
--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)

April 29, 2015 at 10:23 am

#1794394
RE: Get Fiscal Week Number

mm7861 (4/29/2015)
Apologies for being vague!
The only issue I'm having with that datediff code is that I need the fiscal date to change every year. The calendar table will have 100...
--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)

April 29, 2015 at 8:22 am

#1794306
RE: How to use a year and month fields to get a range of records

san1901 (4/29/2015)
All are excellent solutions. But the easiest one is to concatenate the two columns into a date field and do the math from there. Since the day is not...
--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)

April 29, 2015 at 7:37 am

#1794281
RE: Running Balance Updation

My apologies. I've been working on two major projects at work and this slipped through the cracks. I'll try to get to this after work tonight.
--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)

April 29, 2015 at 7:08 am

#1794272
RE: Check for New Or Updated Records using SSIS

I'm pretty sure that you'd have to do that on the Oracle side of the house to be effective. Otherwise, you end up with a join across virtually 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)

April 29, 2015 at 12:40 am

#1794188
RE: Excel Source Opening a rowset for "sheet1$" Failed

tfendt (4/28/2015)
I am running in to an issue with the Excel Source in SSIS.
I am using the new 2012 Integration Services Catalog with Project deployment. I can run the package...
--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)

April 29, 2015 at 12:34 am

#1794187
RE: How to use a year and month fields to get a range of records

san1901 (4/28/2015)
Hello Everyone,
I have a table that contain (besides other columns) 2 fields Year (2014, 2015, etc.) and Month ( 1, 2, 10, etc.) I want to be able 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)

April 29, 2015 at 12:25 am

#1794185
RE: Transaction log is not shrink although there is scheduled transaction log backup

Axell (4/27/2015)
SQL Version: Microsoft SQL Server 2012 with SP1
Recovery Model: Full
I had configured Maintenance Plans for my database but the transaction log keep grow till maximum size of the hard...
--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)

April 29, 2015 at 12:05 am

#1794182
RE: Shrink System databases

WhiteLotus (4/28/2015)
Hi All,
I have some questions :
1.Is it OK to shrink Master, model ? the transaction log for those databases are full .
2.Is it OK to set the Recovery...
--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)

April 29, 2015 at 12:01 am

#1794180
RE: Is it worth to pursue a C# cert for a SQL Dev focused career path?

Actually, the latest "fad" is extreme PowerShell knowledge. Throw in some AD and WMI knowledge on top of that an you'll be unstoppable.
BI is in demand, as well, but...
--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)

April 28, 2015 at 10:06 pm

#1794172
RE: Include row values as columns in select query

Thanks for the kudo, Steve.
Here's the link.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

April 28, 2015 at 3:12 pm

#1794123
RE: Your Role Is Changing

Eric M Russell (4/27/2015)
OK, I'm sorry for the remark about some users wanting access to the 'SA' account just to feel important.
I wouldn't be. I'm glad that someone 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)

April 28, 2015 at 8:55 am

#1793964
RE: SQL optimization

Luis Cazares (4/27/2015)
As that's a local temp table, couldn't you avoid inserting those rows in the first place? You would save time inserting and deleting.
+1000
--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)

April 28, 2015 at 8:36 am

#1793956

Viewing 15 posts - 20,911 through 20,925 (of 59,098 total)