Viewing 15 posts - 631 through 645 (of 645 total)
i do agree with you, i wasnt sure either but i would just take those readings along with the memory counters to help understand the memory situation better- when...
May 12, 2011 at 3:03 am
tempdb is re-created each time the instance of SQL Server is started, you do not have to physically move the data and log files. i would do the following:
a -...
May 12, 2011 at 2:39 am
i tend to use system monitor for analysis and for memory analysis i would use
Memory pages / sec
Memory Available bytes
buffer manager buffer cache hit ratio
physical disk - reads/sec
physical disk -...
May 12, 2011 at 2:32 am
i get around this by running
sp_change_users_login 'auto_fix', 'login_name'
go
sometimes i have to restore 50 plus databases i usually wrap it around a sp_MSforeachdb when i know i will have many orphaned...
May 12, 2011 at 2:27 am
does his login show when running:
sp_change_users_login 'report' ? maybe his login is becoming "orphaned"..
May 12, 2011 at 1:46 am
yes that pretty much what i do, dettach the DB , move the MDF, NDF and ldf files, then re-attach to the new location. i tend to script it when...
May 11, 2011 at 8:32 am
hi,
RESTORE permissions default to members of the sysadmin or dbcreator fixed server roles and the owner (dbo) of the database
im not really sure what you mean by when the...
May 11, 2011 at 8:29 am
The only thing that you will not be able to do is backup the SQL 2008 server to the SQL 2000 server, however,
You will be able to use transactional replication...
May 11, 2011 at 8:25 am
if you mean generally in terms of performance i would check DMVs here you will get an idea of I/O, memory etc.
May 11, 2011 at 7:11 am
use the training kits. thats what i used.
May 11, 2011 at 6:55 am
cant you use nvarchar(max) meaning maximum storage size is 2^31-1 bytes?
May 11, 2011 at 6:53 am
the online = OFF means that the index in question will not be Accessible during the rebuild.
May 11, 2011 at 4:13 am
just a quick question what is your server authentication?
mixed or just windows?
the last time i had this issue it was that it was set to windows only and...
May 11, 2011 at 3:37 am
I have passed 4 2008 sql exams and found that the training kits from a book shop cover alot of what was asked in the exams.
May 11, 2011 at 2:21 am
Using SQL Azure, DBAs still need to manage schema creation, statistics management, index tuning, query optimization, and security administration (logins, users, roles, etc.).
Database administration in SQL Azure differs most...
May 11, 2011 at 2:13 am
Viewing 15 posts - 631 through 645 (of 645 total)