Viewing 15 posts - 20,506 through 20,520 (of 26,490 total)
Ken (6/9/2009)
Unfortunately Start and Close are in YYYYMMDD format.Which is why I convert them to a string to strip out what I need.
Guess what, I am pretty sure that valid...
June 9, 2009 at 1:42 pm
What are the data types for vtbl_Job_Descript_Master.START and vtbl_Job_Descript_Master.CLOSED?
If START is a datetime, a simple solution would be YEAR(dateadd(mm, -3, vtbl_Job_Descript_Master.START))
June 9, 2009 at 1:22 pm
usman.tanveer (6/9/2009)
djjwu (6/9/2009)
I personally think 1m tlog backup is too much. 🙂
For any particular reason (performance, IO, space etc) or just the best practice?
Agreed that it's too much but then...
June 9, 2009 at 1:07 pm
Lynn Pettis (6/9/2009)
He is obviously new to SQL Server and really needs to start doing some research instead of asking such broad based questions like this one.
But then again, I...
June 9, 2009 at 11:17 am
GSquared (6/9/2009)
Lynn Pettis (6/9/2009)
June 9, 2009 at 11:14 am
He is obviously new to SQL Server and really needs to start doing some research instead of asking such broad based questions like this one.
June 9, 2009 at 11:12 am
Krasavita (6/9/2009)
I need to know if SQL Server can communicate with other applications.Thank you
And in what manner are you talking about? That too is a big topic. It...
June 9, 2009 at 11:11 am
Just seems a bit out of my usual SSC character. I'm usually the one trying to everything I can to help people and then I lmgtfy twice in one...
June 9, 2009 at 11:07 am
I think that really comes down to a personal choice. When I registered on SSC, I just decided it was easier to use my name. Plus, I couldn't...
June 9, 2009 at 10:57 am
Care to elaborate? Your question was pretty vague and SQL Server 2005 is a mighty big topic.
June 9, 2009 at 10:46 am
Jeff Moden (6/9/2009)
Lynn Pettis (6/9/2009)
Okay, I must be in pissy mood today and I have NO idea why. I just lmgtfy twice in the same thread...
Which tread? I...
June 9, 2009 at 10:44 am
Is the day portion always 2 characters, in other words you don't have 1109 (mdyy)?
June 9, 2009 at 10:25 am
Cross posting won't help you get greater responses. It will just fragment the responses you get.
June 9, 2009 at 10:03 am
Additional thought. If you were able to automate such a delete/update routine, what if a delete were done by mistake? How would you recover the accidently deleted/updated data...
June 9, 2009 at 9:54 am
Not possible, and doesn't make sense to do it in my opinion. You'd have to restore the every backup to determine if the data existed, then delete it, then...
June 9, 2009 at 9:48 am
Viewing 15 posts - 20,506 through 20,520 (of 26,490 total)