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: Today @ 1:12 PM
Points: 4,348, Visits: 3,402
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: Today @ 1:46 PM
Points: 23,403, Visits: 32,259
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: Today @ 1:46 PM
Points: 23,403, Visits: 32,259
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


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 269, Visits: 860
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: Today @ 1:12 PM
Points: 4,348, Visits: 3,402
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: Today @ 1:12 PM
Points: 4,348, Visits: 3,402
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:25 PM
Points: 2,784, Visits: 7,297
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: Today @ 1:12 PM
Points: 4,348, Visits: 3,402
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


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 10:58 PM
Points: 21,755, Visits: 15,461
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1585617
Posted Tuesday, June 24, 2014 1:06 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:29 AM
Points: 13,741, Visits: 10,716
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