Yes, run the "Query Optimizer" report. It will provide you with different statistics including the use of hints (i.e. table, join, plan, etc.)

Yes, run the "Queries with Table Hints", "Queries with Query Hints", and "Queries with Join Hints" to find this information. Please, keep in mind that the filtering option: "Show Top (in %): N" will filter the top queries with most executions and then it will check them for Hints usage; this lowers quite a bit the impact on the server when running this report. reports.

Why am I being blocked by spid -1? I am not able to kill it and have to restart SQL Server to get around it. Why does the new 'TOP' command in SQL 7 not work? I get a syntax error. Also ALTER TABLE and other SQL 7 only commands.

the Microsoft Full-Text Engine for SQL Server (MSFTESQL) service running a query to retrieve data from an indexed view, or The causes listed above are only a sampling of the issue slow response time issues encountered with SQL Server 2005. This slow response time can be rectified according to Microsoft by upgrading to the latest service pack for SQL Server 2005, Service Pack 2.

In addition to the commonly used treatments many people find their own methods of managing eczema. Some examples follow, but remember that what works for one person may not work for you, and could even make things worse. Anthisan cream, made by May & Baker, is for the relief from pain, itching and inflammation in insect bites and stings and nettle rash and it should not be used for eczema or on extensively broken skin surfaces.

SQL Server is Microsoft's flagship database system for enterprises. While it is extremely fast and reliable, it may be costly for small companies. Find out more at the SQL Server product page.

Server SQL modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. This makes it easier to use MySQL in different environments and to use MySQL together with other database servers. The MySQL Server apply these modes individually to different clients. For more information, see Section 5.2.6, "SQL Modes".

You can set the default SQL mode (for mysqld startup) with the --sql-mode option. Using the statement SET [SESSION|GLOBAL] sql_mode='modes', you can change the settings from within a connection, either locally to the connection, or to take effect globally. You can retrieve the current mode by issuing a SELECT @@sql_mode statement.

By default, no special modes are enabled. See Section 5.2.6, "SQL Modes", for information about all available modes and MySQL's default behavior.

I'm getting an error message - "Cannot Load DLL 'SDI' Reason 126 ( The specified Module Cannot be found)" when doing a stored-procedure debug on SQL Server. Or breakpoints just don't fire.

I'm doing a transfer using the SQL EM transfer tool, and not only is it not transferring the objects.

Yes. You can use any relational database that is accessible by JDBC and satisfies the SPECjAppServer2004 Run and Reporting Rules.

CNRI uses Berkeley DB for its major handle installations. The current handle server version includes code that helps you connect the Berkeley DB to your handle server instance. See the Technical Manual, Chapter 12, Enabling Berkeley DB JE Database Support, for information. Support for other databases is possible for anyone who provides a Java class, implementing the net.handle.hdllib.HandleStorage interface, to store and retrieve handles.

No, they won't. These SSPs are written specifically for ASE, using ASE-specific features. Porting these SSPs to MS SQL Server could be an interesting thing to do, but nothing is planned.

A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements.

The TCL time or clock commands are useful for timing statements. More information is available in the documentation.