crystal reports sql server

is SQL2005, you can use the Report provided by SSMS to view the space usage. If it is SQL2008, you can directly view the table space usage on the details page of the object Resource Manager (if you are using SQL2008 but do not know how to view the table space usage, please refer to a blog I wrote earlier: SQL Server 2008 New Feature-enhanced SSMS ). I am using SQL2008 here and can see the situation Of co

is sql2005, you can use the Report provided by SSMs to view the space usage. If it is sql2008, you can directly view the table space usage on the details page of the object Resource Manager (if you are using sql2008 but do not know how to view the table space usage, please refer to a blog I wrote earlier: SQL Server 2008 New Feature-enhanced SSMs ). I am using sql2008 here and can see the situation Of

sys. allocation_units as a ON a. container_id = p. partition_id Where I. object_id = OBJECT_ID ('tb4039') OR I. object_id = OBJECT_ID ('tb404040 ') System return result: TableName DataSizeTb4039 400Tb4040 800 Similar to the results we can see through reports or SSMS, the two tables only differ by one byte, but one occupies KB of storage space and the other occupies KB of storage space, double the value of another table !!! The gap between one byte l

A common problem with SQL Server is the SQL problem, which is mostly due to high CPU and blocking. One, the problem of high CPU 1, query system Dynamic View query execution time of the SQL statement With Processcte (blocked) as ( Select a spid from sys.sysprocesses WHERE cpu>500 ) SELECT DISTINCT a.* S

separate disks, and with multiple CPUs, SQL Server can process multiple partitions in parallel, greatly reducing the overall time to process a large number of complex reports and analyses.2.3. Create a partition functionPartition functions are used to define boundary conditions for partitions, and the syntax for creating partition functions is as follows:CREATE

the height of the isolation band between transactions. It can be adjusted according to specific requirements to control the transaction defects that can occur. The ANSI SQL-92 defines four isolation levels: SQL Server uses locks for isolation. Given that the lock affects performance, you must weigh the isolation level and performance. The default isolatio

database can be stored in a combination of uppercase, lowercase letters, or both. For example, the last name can appear in the form of "Smith", "Smith" or "Smith". Whether a database is case-sensitive depends on how SQL Server is installed. If the database is case-sensitive, when searching for text data, you must construct the search condition with the correct combination of uppercase and lowercase letters

to use a native Administrator account (Administrator) to log in. Then switch the local administrator account to try again, sure enough.But this brings some trouble, can not always switch to log in with the administrator account, so it is necessary for us to add the local common account is chuntingLog in to the Admin interface http://chuntingPC/Reports, click Site SettingsClick on the following interfaceSwitch to security on the left, then click New R

with other Transact-SQL statements. By default, the parameter can be blank. To prevent passing a null parameter value to a column that does not allow null, add the programming logic to the process or use the default value for the column (use the default keyword of create or alter table ). Whether SQL Server interprets a null string as a single space or as a

Today we start another important part of SQL SERVER bi--reporting service, relative to integration service and analysis service,reporing Service in the domestic users should be a lot more. On the one hand, because the reporing service cost is lower, directly attached to SQL Server, on the other hand, in fact, SSRS to a

SQL Server Error 15023 SQL server Error 15023: a user or role already exists in the current database After restoring the database backup on the remote server to the local machine, an error occurs: "error 15023: A user or role already exists in the current database" Caus

a delete statement, because the data on the publishing end does not exist, so it can only be skipped;--If it is a modification, You need to verify whether the above data exists on the faulty subscription server. If it does not exist, add it. 5. Error:User 'xxx' logon failed or the process cocould not connect to subscriber 'xxxx'.Solution: Check whether the account is correct. You can log on to the publishing and subscription servers and have the rel

the DLL we just compiled in SQL Server. We can use the following command in the database to register the DLL (path of your DLL file) Create Assembly asmhelloworld from 'C: \ sqlserverclrtest. dll' Call our. Net Method in SQL Server To call the. NET method, we can write an SQ