Viewing 15 posts - 136 through 150 (of 230 total)
Try BOL, it's free 🙂
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp?
Probably not what you were looking for but there is a lot of information in it and if you studied it and did practical...
October 3, 2003 at 3:32 am
Allen is right.
Ray Higdon MCSE, MCDBA, CCNA
October 3, 2003 at 3:27 am
Yes, I run AS on XP with no problems, I have sp3 installed and use Excel to connect to my cubes.
Ray Higdon MCSE, MCDBA, CCNA
October 3, 2003 at 3:26 am
This is an error that shows up often on systems that do not have sp3 for analysis services installed.
Ray Higdon MCSE, MCDBA, CCNA
October 2, 2003 at 5:49 am
The service packs definately should be updated. I've seen before on tran log backups that if the start and end times match the job loses its mind after a day,...
October 2, 2003 at 5:47 am
I assume this is what mbrood meant but the logical IO is not the number of DB pages visited, it is the number of times a page was hit (1...
October 2, 2003 at 3:24 am
Compatability level only changes the SQL syntax compatability, it does not change the storage mechanisms. I don't think you can change the page sizes in 7.0.
HTH
Ray Higdon MCSE, MCDBA, CCNA
October 1, 2003 at 6:22 pm
I've briefly looked through that book and it does seem good, I like Inside SQL Server 2000 by Kalen Delany as well.
Ray Higdon MCSE, MCDBA, CCNA
October 1, 2003 at 5:40 pm
I don't have a 7.0 BOL around, but I'm sure it is in there, lookup sp_who or spid in 7.0 BOL and see if it tells you.
You can kill system...
October 1, 2003 at 5:38 pm
You might look at UDF's for this kind of functionality, of course they have their limits as well.
HTH
Ray Higdon MCSE, MCDBA, CCNA
October 1, 2003 at 7:29 am
select value=case(value) when 'y' then 'n'
when 'n' then 'y' else '?' end
from tablename
HTH
Ray Higdon MCSE, MCDBA, CCNA
October 1, 2003 at 6:14 am
From BOL:
SQL Server 2000 reserves SPID values from 1 through 50 for internal use, while SPID values 51 or higher represent user sessions.
You could use this in your statement to...
October 1, 2003 at 6:10 am
Try suser_sname(), if you want the PC it was done from you can use host_name()
HTH
Ray Higdon MCSE, MCDBA, CCNA
October 1, 2003 at 3:17 am
Are the ones that are failing in simple recovery mode or have truncate log on checkpoint turned on?
Ray Higdon MCSE, MCDBA, CCNA
September 30, 2003 at 5:52 pm
Try these:
http://www.sql-server-performance.com/sql_server_configuration_settings.asp
http://www.sql-server-performance.com/optimizing_indexes.asp
HTH
Ray Higdon MCSE, MCDBA, CCNA
September 30, 2003 at 5:48 pm
Viewing 15 posts - 136 through 150 (of 230 total)