Viewing 15 posts - 20,491 through 20,505 (of 26,490 total)
Click here for more info on the money data type.
June 10, 2009 at 9:25 am
Dean Jones (6/10/2009)
I currently have a dilemma, its to do with a table and also its current schema. At the moment, it has a nonclustered unique index on the...
June 10, 2009 at 9:16 am
Native compressed backups are only supported with SQL Server 2008 Enterprise Edition. From what I understand, SQL Server 2008 Standard Edition will restore a compressed backup taken on a...
June 10, 2009 at 9:08 am
MarkusB (6/10/2009)
Grant Fritchey (6/10/2009)
MarkusB (6/10/2009)
Any psychics around who can help this onehttp://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx
I can't read minds, but I can see the future...
I see... I see... a dba-wanna-be on the street, looking...
June 10, 2009 at 7:26 am
San (6/9/2009)
UPDATE T1
SET T1.ColC = T1.ColA - T1.ColB,
T1.ColA = T2.ColC
FROM Tab1 AS T1
JOIN Tab1 AS T2
ON...
June 10, 2009 at 7:19 am
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
Viewing 15 posts - 20,491 through 20,505 (of 26,490 total)