well done! a new way doing autodba job using SSIS.

thanks for sharing.

jiulu

did you find the root cause of why production server take more than 5 minutes and the reporting server take less than 1? caused by CPU contention? or the "read...

I am wondering how to handle concurrency of data loading and reporting...

I know you've designed the round robin to switch loading data for every 15 minutes, what if the report...

Doug Krawec (12/18/2007)

---

sunjiulu,

Thanks for the explanation.

Yes, I am using SQL Server login rather than Windows Authentication. We have created a SQL Login of the form "ApplicationUser" with...

Doug Krawec (12/18/2007)

---

I've noticed that when I Restore a database (in my case to a different machine) that the security settings that were in place on the original database are...

I have a question about windows authentication.

when one domain user belong to multiple windows domain group, say grp1 and grp2, and both groups are granted access to database and given...

all right, guys, doesn't mean to offending, apologize if I did. actually I love the post here and benefit a lot, as a DBA that dealing with sql, oracle and...

althought the knowlege is good to have, but asking this question in interview will make them think you are crazy, I would not like to work for you if you...

you ruined my Senior DBA reputation this morning when I forward this to my colleague. should I say thank you?

 

Jiulu

that's awesome, thank you very much. barsuk.

Hi barsuk,

what's "action" is available for this xp_servicecontrol? looks like only "start" and "stop", no "status"... how can I use this xp to check service running or not?

 

This is a bottomline index check, really cool, I used to do it manually on many sqlserver environment, it took time. now  the script will help me. thanks.

that sound like Oracle "materialized view" in 8i/9i, or snapshot in oracle8. used mostly in data warehouse or distributed database environment.

Thanks you very much for writing this wonderful article. does sqlserver2005 locking machnism changed?  e.g. no lock on normal read.

you may choose to update your sysusers table directly.

 

1. sp_configure 'allow update system table ...', true

 

2. use userdatabase

go

update sysusers set suid=m.suid from master..syslogins m,sysusers u

where m.name=u.name

go

 

and see how many users...