Viewing 15 posts - 1 through 15 (of 34 total)
well done! a new way doing autodba job using SSIS.
thanks for sharing.
January 24, 2008 at 3:25 pm
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...
January 21, 2008 at 4:10 pm
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...
January 21, 2008 at 3:50 pm
Doug Krawec (12/18/2007)
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...
December 18, 2007 at 3:21 pm
December 18, 2007 at 2:46 pm
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...
December 18, 2007 at 9:07 am
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...
December 12, 2007 at 7:58 am
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...
December 11, 2007 at 8:19 am
you ruined my Senior DBA reputation this morning when I forward this to my colleague. should I say thank you?
April 1, 2005 at 7:26 am
that's awesome, thank you very much. barsuk.
February 2, 2005 at 6:27 am
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?
January 28, 2005 at 6:45 am
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.
December 8, 2004 at 9:02 am
that sound like Oracle "materialized view" in 8i/9i, or snapshot in oracle8. used mostly in data warehouse or distributed database environment.
December 2, 2004 at 9:46 am
Thanks you very much for writing this wonderful article. does sqlserver2005 locking machnism changed? e.g. no lock on normal read.
December 2, 2004 at 8:22 am
you may choose to update your sysusers table directly.
1. sp_configure 'allow update system table ...', true
2. use userdatabase
update sysusers set suid=m.suid from master..syslogins m,sysusers u
and see how many users...
December 1, 2004 at 6:38 am