Viewing 15 posts - 9,346 through 9,360 (of 9,641 total)
I have a degree in Physical Education, found out I can't stand children and ended up working with Developmentally Disabled adults for 4 years. My best friend from high...
October 19, 2007 at 7:25 am
Actually either indexes or indices can be used as the plural of index. I tend to use indices because no one else does.
Have you compared the...
October 18, 2007 at 2:36 pm
This is interesting as I just a had a discussion about this with a coworker and I did not know it was even possible. When I googled it the...
October 18, 2007 at 1:54 pm
What are the indices on your tables? Are the databases on the same machine? How much memory is allocated to SQL Server 2005 vs. SQL Server Express?
October 18, 2007 at 1:30 pm
Are you using SSMS to create the linked server? If you are it should be in the provider drop-down box. I had to scroll down to the 11th...
October 18, 2007 at 1:27 pm
Question 1:
I believe FoxPro does not support full object qualification, server.db.owner(schema).table. I believe you just want server.db.table.
Question 2:
I don't think you can access a linked server through a linked...
October 18, 2007 at 1:18 pm
You should make sure you have the latest version of MDAC installed.
October 18, 2007 at 1:15 pm
What jumps out at me to start are the outer joins. Are these really necessary?
October 16, 2007 at 12:54 pm
Check out this article on rebuilding and restoring the master DB.
http://articles.techrepublic.com.com/5100-1035_11-5025441.html
October 15, 2007 at 9:11 pm
Opus (10/11/2007)
=iif(Fields!Weight.Value<>0,sum(Fields!Earned.Value)/sum(Fields!Poss.Value)*Fields!Weight.Value*.01,0)
I am assuming you are using SSRS to develop this report. In SSRS you could put the calculation as a calculated field in the dataset and use that...
October 15, 2007 at 9:03 pm
Yes. But it actually brings us to a different point - that we can't have one set of ideals for the DBA candidate. No doubt each of...
October 15, 2007 at 2:35 pm
R L Reid (10/15/2007)
colin Leversuch-Roberts (10/15/2007)
non clustered PK, I'd say 75% of candidates have got this wrong - .
How about "Gee, I'm not sure. I don't see a...
October 15, 2007 at 1:46 pm
Grant Fritchey (10/15/2007)
Not the strict textbook answer, but WAY closer than the drivel I'm usually fed. When can you start?
Can I be a part-time remote DBA? I just moved...
October 15, 2007 at 12:45 pm
I've seen many knocked out with the "how do you return the identity value (post 2000)?
I guess that would depend on what identity value you are looking for? ...
October 15, 2007 at 11:47 am
Viewing 15 posts - 9,346 through 9,360 (of 9,641 total)