I think you're going to struggle as most tests of this nature are multiple choice (like the MCDBA ones)

the tests themselves show that you can write syntatically correct SQL such...

I'm guessing from what you're saying here you're talking about "drill down" reporting which might be a better term to search for.

if you're using msaccess to provide reports against an...

I'm guessing from what you're saying here you're talking about "drill down" reporting which might be a better term to search for.

if you're using msaccess to provide reports against an...

using the outer join with a y.id is not null will do more work than the 2nd query as you will have to do an index seek or table scan...

Nash,

I don't think that performance is really the maint point of ahaving outer and inner joins.

they both return different sets of data. An outer join will almost always...

I've been using crystal back from version 7 and while the product is now so much better it's also far too expensive

SQL server 2005 reporting services is actually pretty good...

if i could suggest something-

can you run the command DBCC SQLPERF(LOGSPACE) and paste the results back

if you need to claim space back it might be wise to claim it...

What is the diference between unallocated space and unused space

not sure if this is entirely accurate but here goes - unused is allocated space that has not been used...

i think you might have few problems doing it this way

1) the value you return from the child procedure is retuned as an output variable so you need to...

if you hadn't already said that you were on mixed mode authentication id'd swear that you were on windows only auth

by the way - is the server a member...

if you're attempting connect remotely is this via you LAN or are you coming through the internet via VPN?

i've seen this problem with juniper before.

do you have a firewall installed blocking your sql ports ?

DBCC SHRINKFILE WITH TRUNCATE_ONLY doesn't break the LSN (log sequence number) and cause you to lose your backup chain - all it does is remove the empty space from the...

you can find the contents of your file dsn's at c:\program files\common files\odbc

you can then edit one of them and add the PWD=mypassword or PASSWORD=mypassword line to the file

firstly it might be wise to run the following

use mydatabase

go

dbcc updateusage

go

that should make sure you get accurate sizing information

then run sp_spaceused again

to view which tables are using the most...