Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,4364,4374,4384,4394,440»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, June 24, 2014 10:56 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:28 PM
Points: 4,611, Visits: 4,067
Lynn Pettis (6/24/2014)
< rant >

Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current date and getdate() + 10 doesn't work.

< /rant >
Refer them to your common date routines. I refer others to it.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1585591
Posted Tuesday, June 24, 2014 11:00 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:23 PM
Points: 20,860, Visits: 32,883
Ed Wagner (6/24/2014)
Lynn Pettis (6/24/2014)
< rant >

Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current date and getdate() + 10 doesn't work.

< /rant >
Refer them to your common date routines. I refer others to it.


And I really appreciate the referrals (now if I could just get back to writing on my blog!) but this question was really just how do I add 10 years to today. I posted the appropriate dateadd function but that was it.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1585593
Posted Tuesday, June 24, 2014 11:01 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:23 PM
Points: 20,860, Visits: 32,883
Lynn Pettis (6/24/2014)
Ed Wagner (6/24/2014)
Lynn Pettis (6/24/2014)
< rant >

Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current date and getdate() + 10 doesn't work.

< /rant >
Refer them to your common date routines. I refer others to it.


And I really appreciate the referrals (now if I could just get back to writing on my blog!) but this question was really just how do I add 10 years to today. I posted the appropriate dateadd function but that was it.


Insult to injury, the OP has been a member of ssc for 6 years.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1585594
Posted Tuesday, June 24, 2014 11:03 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 10:09 AM
Points: 363, Visits: 1,091
Just tell them to add 10 to today 365 times.
Post #1585596
Posted Tuesday, June 24, 2014 11:06 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:28 PM
Points: 4,611, Visits: 4,067
djj (6/24/2014)
Just tell them to add 10 to today 365 times.
Don't you mean 365.25 times? Or would that be add 365.25 to today 10 times? It all depends on the year of today...no wait...that means a date function is required. Never mind.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1585599
Posted Tuesday, June 24, 2014 11:17 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:28 PM
Points: 4,611, Visits: 4,067
Lynn Pettis (6/24/2014)
Lynn Pettis (6/24/2014)
Ed Wagner (6/24/2014)
Lynn Pettis (6/24/2014)
< rant >

Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current date and getdate() + 10 doesn't work.

< /rant >
Refer them to your common date routines. I refer others to it.


And I really appreciate the referrals (now if I could just get back to writing on my blog!) but this question was really just how do I add 10 years to today. I posted the appropriate dateadd function but that was it.


Insult to injury, the OP has been a member of ssc for 6 years.
Sorry, Lynn. I just had to weigh in on that thread. I like how a the OP marked a post with a followup question as the answer.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1585607
Posted Tuesday, June 24, 2014 11:24 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:27 PM
Points: 868, Visits: 7,505
Lynn Pettis (6/24/2014)
Lynn Pettis (6/24/2014)
Ed Wagner (6/24/2014)
Lynn Pettis (6/24/2014)
< rant >

Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current date and getdate() + 10 doesn't work.

< /rant >
Refer them to your common date routines. I refer others to it.


And I really appreciate the referrals (now if I could just get back to writing on my blog!) but this question was really just how do I add 10 years to today. I posted the appropriate dateadd function but that was it.


Insult to injury, the OP has been a member of ssc for 6 years.


The correct syntax is: getdate() + 10 years. Duh!

If you need it to run really fast, it is getdate() + 10 years, please.


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1585610
Posted Tuesday, June 24, 2014 11:26 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:28 PM
Points: 4,611, Visits: 4,067
Stefan Krzywicki (6/24/2014)
Lynn Pettis (6/24/2014)
Lynn Pettis (6/24/2014)
Ed Wagner (6/24/2014)
Lynn Pettis (6/24/2014)
< rant >

Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current date and getdate() + 10 doesn't work.

< /rant >
Refer them to your common date routines. I refer others to it.


And I really appreciate the referrals (now if I could just get back to writing on my blog!) but this question was really just how do I add 10 years to today. I posted the appropriate dateadd function but that was it.


Insult to injury, the OP has been a member of ssc for 6 years.


The correct syntax is: getdate() + 10 years. Duh!

If you need it to run really fast, it is getdate() + 10 years, please.

That's what my problem was! Here I was using getdate() + 10 years NOW

Edit: I forgot: getdate() + 10 years NOW WITH (NOLOCK)



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1585611
Posted Tuesday, June 24, 2014 11:46 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 18,064, Visits: 16,099
Lynn Pettis (6/24/2014)
< rant >

Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current date and getdate() + 10 doesn't work.

< /rant >


Why doesn't it work?




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1585617
Posted Tuesday, June 24, 2014 1:06 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
Luis Cazares (6/24/2014)
Congratulations Koen. You're certainly one of the top posters on Bi.
On a completely different subject, I'm taking 20467BC course this week and found some surprises like using while loops to create sample data, recommendations to use partitioning for performance and nolock hints on every view in the data warehouse to prevent concurrency issues.
Are they serious? Should I unlearn something?


Partitions do improve insert performance. Might help for very large fact tables.
And you also have the partition eliminiation when querying, but I haven't noticed that much performance improvement.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1585640
« Prev Topic | Next Topic »

Add to briefcase «««4,4364,4374,4384,4394,440»»»

Permissions Expand / Collapse