|
|||||||
|
Database administrators experience regular slowdowns on their SQL Server databases. The I/O subsystem is a key factor when it comes to SQL Server performance since database pages are constantly moved in and out of the buffer pool. Also the transaction logs and tempDB generate significant I/O traffic. Therefore you have to ensure that your I/O subsystem performs as expected, otherwise you will be a victim of increased . . . → Read More: How to Identify I/O Bottlenecks in MS SQL Server  5 comments  DBMS  array, avg, bottlenecks, buffer pool, cpu usage, database, DBMS, disk configuration, disk operations, disk performance, I/O bottleneck, peak usage, performance counters, queue length, response times, rule of thumb, server performance, server solution, SQL Server, sql server databases, tempdb, time outs, transaction logs EXEC sp_dboption N’mydb’, N’offline’, N’true’ OR ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK AFTER 30 SECONDS OR ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE Using the alter database statement (SQL Server 2k and beyond) is the preferred method. The rollback after statement will force currently executing statements to rollback after N seconds. The default is to wait for all currently running transactions to complete and for the sessions to be terminated. Use the rollback immediate clause to rollback transactions immediately. . . . → Read More: SQL Server : Take offline database  The new kernel version is notable because it hasn’t grown in size – yet it contains hundreds of advancements which will be obvious to end users, who don’t often notice changes in their Linux distribution’s kernel. After 80 days of development Linus Torvalds has released Linux version 2.6.36. It got the name “Flesh-Eating Bats with Fangs” with the eight pre-release; Torvalds was inspired by a bat that recently found its . . . → Read More: What’s new in Linux 2.6.36?  To attach a MDF without LDF you can follow the steps below: 1. Create a new database with the same name and same database (i.e. mydatabase) MDF and LDF files (i.e. mydatabase_data.mdf and mydatabase_log.ldf). 2. Stop SQL server and change the name of new MDF (i.e. mydatabase.mdf to mydatabase-new.mdf) and copy the original MDF to this location and delete the LDF file. 3. Start SQL Server. 4. Now . . . → Read More: How to attach a SQL Server data file MDF without LDF Solving ReportViewer Rendering Issue on IIS7 Applies to: Internet Information Services 7.0 (IIS7) Microsoft Report Viewer Redistributable 2005 Symptoms: Unable to render ReportViewer on ASP.NET Web pages while running on IIS7. You have no problem viewing your reports when running on debug mode with your Visual Studio 2005. You are able to view your reports on Report Manager but not able to view them on IIS7. You encounter . . . → Read More: Solving ReportViewer Rendering Issue on IIS7 Symptoms: I 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 error: Error: Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum) Additional Information: A exception . . . → Read More: How to fix creating index (Full-Text catalogs) – Error 229 (Permission denied) in SQL Server?
If 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. The Collation change script: Code: ALTER DATABASE {your database} SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE {your database} COLLATE Turkish_CI_AS ALTER DATABASE {your database} SET MULTI_USER where you . . . → Read More: How to change SQL Server database collation In this article we will describe to create Full text search in SQL Server 2008 through SQL Server management studio. To create a full-text catalog: Launch SQL Server management studio 2008 Connect to SQL Server In Object Explorer, expand the server, expand Databases, and expand the database in which you want to create the full-text catalog. Expand Storage, and then right-click Full Text Catalogs. Select New Full-Text Catalog. In the New Full-Text Catalog dialog . . . → Read More: How to enable Full text search in SQL Server 2008 Microsoft SQL Server 2008 Service Pack 2 (SP2) is released and it’s available for download. These packages may be used to upgrade any edition of SQL Server 2008. Service Pack 2 contains updates for SQL Server Utility, Data-Tier Application (DAC), as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 Technologies. Service Pack 2 introduces support for a maximum of 15,000 partitions in a database, and includes SQL Server 2008 SP1 Cumulative Update 1 to 8. You can download Microsof t SQL Server 2008 from Microft download center. Key enhancement in Microsoft SQL Server 2008 Service Pack 2 are: . . . → Read More: Microsoft SQL Server 2008 Service Pack 2 released |
|||||||
|
Copyright © 2012 ssysadmin.com | SysAdmin | System Administrator | Smartphones | Gadget | networking | Server | Technology | iPhone | Theme | smartphone | opensource | ethical hacking | news | Free Ads | Classified - All Rights Reserved |
|||||||
