crystal reports sql server

the amount of data (size), the more important it is to increase I/O. 2. Vertical and horizontal partition table, reduce the size of the table (Sp_spaceuse) 3. Upgrading hardware 4, according to the query criteria, index, optimize the index, optimize access mode, limit the data volume of the result set. Note that the fill factor is appropriate (preferably using the default value of 0). The index should be as small as possible, using a Lie Jian index with a small number of bytes (refer to the cre

I often encounter some questions about database optimization. I think this is the most basic skill requirement, especially the use of SQLServer2005. for SQL Server optimization, full-time or part-time DBAs are easier to work and more efficient, but many new users may not know much about them, I will write some basic introductions here. 　I. First, I will introduce the two tools used to optimize data in

.2. By default, the table or index changes, and the statistics are automatically updated accordingly to keep the statistics up-to-date. However, you can turn off this automatic Update feature in the database options to improve the speed of updating the data table. However, you need to manually update the statistics regularly. Because outdated statistics can result in a miscarriage of judgment about whether or not to use an index. There is no difference between the statistics of SQL2000 and SQL20

search for separate reports of data rows instead of using the group by clause. In this case, SQL statements using the distinct keyword are more efficient. Use group by when you need to calculate Aggregate functions (sum, Count, Max, etc. In addition, if your query always returns a unique row, do not use the distinct keyword. In this case, the distinct keyword only increases the system overhead. As you ca

Tags: Memory performance for rebuild requests ref POS no handle The source of this article: http://www.cnblogs.com/wy123/p/6984885.html An error message that a disk request exceeds a certain amount of time in a errorlog in the database occurs when a SQL Server server has recently encountered an extremely slow response and a client request error occurred.Is this

. During the installation process, if you are filling out a connected report server, you can locate the report Server Web URL copy in the Web Service URL in the rscm mentioned above. When the installation process problems, you can not fill out the report Server, and so on after the installation is started to use and then connect.Create a reportTo create a report,

and reports the process cocould not execute 'SP _ replcmds 'on 'server name' error. In this case, try to restart the SQL proxy of the server, and then the log reader can work normally for a period of time (I am experiencing a few hours), but it will fail every day, the Log Reader job fails. Because the subscription

Original article address: Stairway to SQL Server Indexes: Level 2, Deeper into Nonclustered Indexes This article is part of the SQL Server Index advanced series Stairway to SQL Server Indexes. The first level introduces non-cluste

Sometimes, in order to make the application run faster, all the work is to make small adjustments here or there. Ah, but the key is to determine how to adjust it! Sooner or later, you will encounter this situation: the SQL query in the application cannot respond as you want. It either does not return data or takes a surprising amount of time. If it reduces the speed of reporting or your enterprise applications, users will not be satisfied if they have

-- Sp_revokedbaccess Jacobean: Delete the Jacobean account in the current database -- Sp_change_users_login 'report': displays the current user report mapped to logon. -- Sp_droprole sqladmin1: Delete the sqladmin1 role from the current database -- Sp_droprolemember 'sqladmin1' and 'jacky' Delete the account Jacky from the sqladmin1 role -- Sp_grantlogin 'nwtraders/sqladmin1' create a domain user nwtraders/sqladmin1 logging on to SQL

reports "An error occurred in the initialization context ". Emergency ModeWhen Yi Hongyi says there is no log for restoration, you can do this: 1. Set the database to emergency mode. 2. Create a New log file. 3. Restart SQL Server. 4. Set the application database to single-user mode. 5. Perform DBCC checkdb 6. If there is no major problem, you can

efficiency of SQL Server in finding rows affected by any data changes in the index. Maintaining an indexed view can be more complex than an index on a base table. You should create an index on a view only if the result of the view is more efficient than the cost of modifying it. Such views typically include views that are mapped to relatively static data, handle multiple rows, and are referenced by many q

Several problems encountered when reading Excel in the sql2005 query analyzer, collected all the resources on the Internet, and finally solved the problem. Many answers on the Internet are pasted and copied, therefore, it cannot be used in the actual environment. I believe many of my friends have encountered the same mistakes. To avoid the same mistakes, I would like to share them with you:Environment:System: windows7,Database: Sqlserver2005,Office: office2003 SQLCommonly used Excel reading meth

lock_timeout value is not set. Select @ lock_timeoutThe following is the result set:-----------------1 The following example sets lock_timeout to 1800 milliseconds and then calls @ lock_timeout. Set lock_timeout 1800Select @ lock_timeout The following is the result set:------------------------------1800 4. Set identity_insert Note: explicit values can be inserted into the table's ID column. Syntax: Set identity_insert [database. [owner.] {table} {on | off} Parameter: database

server, it is safe to establish an independent user for management. Figure 1-14 Database Engine configuration As shown in Figure 1-15, specify an administrator for Analysis Services configuration, as an example of the system administrator. Recommendation: When installing SQL Server on a server, it is safe to estab

Label:Sometimes, in order for the application to run faster, all that is done is to make minor adjustments here or there. But the key is to determine how to adjust! Sooner or later you'll encounter this scenario: the SQL query in your application doesn't respond the way you want. It either doesn't return data, or it takes a surprisingly long time. If it lowers the speed of the enterprise application, the user must wait a long time. Users expect applic

the New Task Step dialog box, enter the name of the output file that reports the fragmentation analysis results: 　　 6. Click the OK button to return to the new Job dialog box; 7. On the schedule page of the New Task dialog box, click New Schedule and enter the appropriate plan for running the SQL Server task: 　　 Schedule this stored procedure to execute at non-p

clustered Columnstore index, we don't need a nonclustered column index, because all of the data is stored in columns at this time. However, if you need to add constraints on the table or if the workload still requires a nonclustered index of b-tree form, then we can only consider using nonclustered Columnstore indexes.The following improvements are performed on the execution of a statement0 Vector-based computing methods are modified0 Support for more syntaxAll join methods (including outer, HA

standardize data. These include functions similar to "blur" matching and grouping, so that those that appear to be the same data (just through different imports and exports) can be filtered out and standardized. A good example of this is the different kinds of data from different geographic regions: the same ideas can be expressed in different ways, and they need to be standardized before being processed. Connecting to the Analysis Services cube You can use SSIS to connect data directly to a

SQL Server 2005 and 2008 provide many new and enhanced business intelligence functions, including integrating multiple data sources using the Integrated Service (SSIS) and using the Analysis Service (SSAs) enrich data content and create complex business analysis; use the report Service (SSRS) to edit, manage, and submit rich reports. if you do not know these func