|
||||||
|
Problem \r\nWe experience regular slowdowns on our SQL Server databases. After analyzing the memory and CPU usage we would like to continue the root cause investigation by examining I/O bottlenecks. What is your recommendation to recognize I/O related bottlenecks in SQL Server?\r\n Solution \r\nThe I/O subsystem is a key factor when it comes to SQL […] EXEC sp_dboption N’mydb’, N’offline’, N’true’\r\nOR\r\nALTER DATABASE [mydb] SET OFFLINE WITH\r\nROLLBACK AFTER 30 SECONDS\r\nOR\r\nALTER DATABASE [mydb] SET OFFLINE WITH\r\nROLLBACK IMMEDIATE \r\n \r\n Using the alter database statement (SQL Server 2k and beyond) is the preferred method. \r\n The rollback after statement will force currently executing statements to rollback after N seconds. \r\n The […] 
To attach a MDF without LDF you can follow the steps below:\r\n \r\n 1. Create a new database with the same name and same database (i.e. mydatabase) MDF and LDF files \r\n (i.e. mydatabase_data.mdf and mydatabase_log.ldf).\r\n \r\n 2. Stop SQL server and change the name of new MDF (i.e. mydatabase.mdf to mydatabase-new.mdf) and \r\n copy […] Solving ReportViewer Rendering Issue on IIS7\r\n\r\n\r\n\r\nApplies to:\r\n \r\n Internet Information Services 7.0 (IIS7) \r\n Microsoft Report Viewer Redistributable 2005 \r\n \r\nSymptoms:\r\n \r\n Unable to render ReportViewer on ASP.NET Web pages while running on IIS7. \r\n You have no problem viewing your reports when running on debug mode with your Visual Studio […] Symptoms:\r\nI have my development database on a SQL Server 2005 server. I enabled it for full-text catalogs and created a catalog with no issues whatsoever. When I go to create the index, however, I run through the wizard (using SQL Server Management Studio) until the last step. Upon finishing the wizard, I get the following […] \r\n \r\n \r\n\r\nIf you tried changing collation to from English to Turkish or other using the script as below but it will fail due to dependencies issues, You have to script them, drop them, change db collation and recreate them from script.\r\n\r\nThe Collation change script:\r\n \r\n Code: \r\n ALTER DATABASE {your database} SET SINGLE_USER WITH […] To recover database from suspect mode in SQL Server 2005 / 2008 use this script in MS SQL Server management Studio:\r\n\r\nEXEC sp_resetstatus ‘yourDBname’;\r\nALTER DATABASE yourDBname SET EMERGENCY\r\nDBCC checkdb(‘yourDBname’)\r\nALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE\r\nDBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)\r\nALTER DATABASE yourDBname SET MULTI_USER\r\n\r\nNote: change ‘yourDBname’ with database name you want to recover from suspect mode. |
||||||
|
Copyright © 2019 ssysadmin.com | SysAdmin - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
