Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DrSql
  • Content: Threads
  • Order by date
  1. DrSql

    CLR vs. SP

    As DBA we have been debating with our developers whether we should be using CLR Stored procedures or SQL Server Stored procedures. Is there any have any experience with it or suggest the Pros and Cons. Thanks in advance. Dr.Sql Good Luck.
  2. DrSql

    mirroring vs. log-shipping

    Please share your thoughts about why you would choose mirroring over log-shipping in SQL Server 2008. Quick responses are greatly apppreciated. Thanks Dr.Sql Good Luck.
  3. DrSql

    DR Plans

    I am looking to create a DR plan and looking for sample template. IF anyone have any suggestions please respond. 1.) Contacts 2.) DBA Action Items (Mirroring, Replication, Log-shipping) 3.) SA Actions (Cluser, OS issues) 4.) SAN Admin Actions (Disk issues) 5.) Tape Backup (Incase require...
  4. DrSql

    Replication Test Case

    I am in the middle of setting up a Peer2Peer replication but I am looking for some good test cases to make sure that I address all possible scenarios prior to releasing to production. Here few scenarios I came up with: Site A down Site B Down Cluster Fail over Transaction queues up during a...
  5. DrSql

    Optimal SQL DB response

    What would be considered as an optimal database reponse time. Is it a myth or fact? If query response time is 3sec <= is considered as Excellent then what would be good and bad? Dr.Sql Good Luck.
  6. DrSql

    Track Object usage

    I am trying to track how often few tables are being used in a database and would like to track the login name and host name for that process. I know how to track this down using Profiler but in our prod environment we can't use it due to app timeouts. The environment is SQL 2005. Any help is...
  7. DrSql

    Analysis SSAS 2008-64 bit

    Can someone please provide me some articles or recommendations about SSAS configurations for optimal performances. Dr.Sql Good Luck.
  8. DrSql

    Setting Timeout to &quot;0&quot;

    Are there anything to be concerned about setting the timeout to "0". Our developer has a report that has a long running query and he would like to set to "0" to avoid time out. By defauly its 600 ms, and 0 is infinite. I am looking for Pro and Cons. Thanks Varghese Dr.Sql Good Luck.
  9. DrSql

    Best Practice

    I read several Best Practcie articles stating that always reccoemnded to use DROP and CREATE objects excpet for tables when making chnages production. Can anyone give me a justification for this? Dr.Sql Good Luck.
  10. DrSql

    SQL Server Log

    I have an instance with a large SQL Server log and not able open through enterprise manager. The server hasn't rebooted in a longtime. I am looking for any suggestion to cycle the log files and clear it out without restarting the SQL Server service. Any help is appreciated. Dr.Sql Good Luck.
  11. DrSql

    Trace Tools

    Are there any tools to trace Analysis Service 2000 and can be helpful for performance tuning. With sql 2005 profiler I was able to trace 2005 but not 2000. Any suggestions are greatly appreciated. Dr.Sql Good Luck.
  12. DrSql

    Objects inside DTS Pacakge

    Not Sure its a DBA or Developer question Please forgive me for posting this question Any idea how can I analyze a DTS package and see the tables and other objects used inside. Is it possible to scan the entire server? If its possible please give me some suggestions. Any quick help would be...
  13. DrSql

    Objects inside DTS Pacakge

    Any idea how can I analyze a DTS package and see the tables and other objects used inside. Is it possible to scan the entire server? If its possible please give me some suggestions. Any quick help would be greatly appreciated. Thanks VP Dr.Sql Good Luck.
  14. DrSql

    Help Log File

    Having a bad week. I have dev databases and one of my developer "accidently" deleted few tables two days back and we dont have a good backup. The ldf file should have all transactions because we havent made a full backup or truncate the log. Is there any way I can explore the log file and...
  15. DrSql

    Lost T-Log (Help Plz.)

    One of my server crashed today. We lost one of the T-log, is there any way that I can atleast recover rest of the t-logs. I have weekly full backup from Sunday, Tlogs from Mon & wed Is there any possible way we can recover tha data from wed t-log without tue t-log. Any help would be greatly...
  16. DrSql

    Lost DTS package password

    Is there anyway to recover lost DTS package password? Thanks Dr.Sql Good Luck.
  17. DrSql

    Disk IO concerns

    I have server with some performance issues, afetr gathering all the details i could see few system spids are the top IO consumers. Should I be concerned about this? Here are the details. SPID Status Login DbName Command CPU DiskIO 5 BACKGROUND sa master TASK MANAGER 0...
  18. DrSql

    Red-Gate vs LiteSpeed

    Is anyone have any thoughts or experinces working on both Red-Gate & LiteSpeed. The Pro's and Con's, Price, Licensing and Customer Support. Any feedbacks are gretly appreciated. Thanks Dr.Sql Good Luck.
  19. DrSql

    Quest backup products for SQL Server

    Is anyone have any thoughts or experince with "Quest backup products for SQL Server". Our compnay is currently evaluating third party tools for backups and moniotring. Any suggestions or comments are greatly appreciated. Thanks Dr.Sql Good Luck.
  20. DrSql

    Clustering Help

    Currenlty I have an ACTIVE/ACTIVE cluster running on NODE-A and NODE-B. SQL1==>NODE-A SQL01\VS2 NODE-B Recently I recived a request to add another two more instances to the NODE-A and B. Is its possible? What are the pro's and con's of it. Is there any pit fall during the install? How many...

Part and Inventory Search

Back
Top