Viewing 15 posts - 20,491 through 20,505 (of 26,484 total)
And hopefully someone who reads this forum will realize the mistake and that you didn't indulge in continuing the twisting of the mistake. Plus, if they look at what...
June 9, 2009 at 3:27 pm
Karthik,
At this point I'd suggest stopping. Unless you are involved in theoretical research, you really don't need to figure out how to solve Big O mathematical formulas, just understand...
June 9, 2009 at 3:18 pm
RBarryYoung (6/9/2009)
jcrawf02 (6/9/2009)
RBarryYoung (6/9/2009)
We goggle all of our applicants and check out all of the URLs on their resume's.
S'pose that's better than 'ogle-ing' them. Do they have trouble seeing the...
June 9, 2009 at 3:03 pm
Favor please.
Post the table DDL and some sample data for the tables along with the expected results. I was looking at your query and I think it may be...
June 9, 2009 at 3:00 pm
djjwu (6/9/2009)
Yes. Performance and IO is the big concern if you have very active db. I think Gail already asked u the question on how much data you could...
June 9, 2009 at 2:49 pm
I'm guessing it is an INT field based on what I have read so far.
June 9, 2009 at 2:47 pm
Lynn Pettis (6/9/2009)
Could just be me, but I still think our PhD Candidate doesn't have a clue.
AND!! Based on many of the PhD's I have met (this doesn't apply to...
June 9, 2009 at 2:01 pm
Or this would work:
select
reverse(left(reverse(physical_name), charindex('\', reverse(physical_name)) - 1)),
*
from
sys.master_files
June 9, 2009 at 1:57 pm
Could just be me, but I still think our PhD Candidate doesn't have a clue.
June 9, 2009 at 1:49 pm
You could use the high-performance (asynchronous) mode. This would ensure that all transactions are committed locally.
You still have the possibility of some lost transaction with your current t-log process...
June 9, 2009 at 1:48 pm
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
Viewing 15 posts - 20,491 through 20,505 (of 26,484 total)