Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,881 through 20,895 (of 59,072 total)

RE: Datediff

djj (4/30/2015)
Also is there an index on Time_Created?
Also, what is the datatype of the Time_Created column? Could be some nasty ol' implicit conversions working here.
I also agree with Luis.......
--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 10:57 am

#1794794
RE: Reducing Index Fragmentaion during Inserts

kevaburg (4/27/2015)
Hi all!
Many, many thanks for the tips. I have decided to use a combination of the advice given here.
I will add an identity column in the table 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)

April 30, 2015 at 9:00 am

#1794725
RE: Exercise to practise SQL

pawankkmr 41145 (4/30/2015)
Check out puzzles @
http://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
That's pretty cool. One recommendation would be that if anyone wants to use XML to do a split, you might not want to work...
--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 8:56 am

#1794722
RE: Running Balance Updation

I was at work until 2AM this morning but I did manage to work on your project a bit. I never provide answers to such important data without a...
--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 8:47 am

#1794716
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

Viewing 15 posts - 20,881 through 20,895 (of 59,072 total)