(Arthur Fuller) Your application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or of a string and one or two integers. In a small table, you might not notice the impact. But suppose the table of interest contains 50 million rows? Then you will notice

(Brian Walker) A SQL Server DBA often needs to perform ad hoc operations on data in their databases. The tasks can typically be handled with simple T-SQL statements, but other times a more complex operation is called for – and having to manually enter all the T-SQL code necessary for such an operati

Automatic checkpoints on some SQL Server 2000 databases do not run as expected. The automatic checkpoints previously ran as expected. Other SQL Server 2000 databases have no issues.

(Muthusamy Anantha Kumar) Among other enhancements in SQL Server 2005, enhancements were made to the OPENROWSET function. This article illustrates BULK operations of the OPENROWSET function.

When you run a SQL Server Agent job in Microsoft SQL Server 2000, you may receive the following error message: Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action.

(Jagadish Chaterjee) This article is the third in a series focusing on retrieving SQL Server 2005 information using SMO along with Visual Basic 2005 and Visual Studio 2005. In this article, we mainly deal with four topics: retrieving the column information of a selected table; scripting the selected

(Bob Dorr) Because new devices and storage solutions continue to appear in the marketplace, the environments in which Microsoft SQL Server runs have become extremely diverse. To ensure data integrity for our customers who are running SQL Server, it is important that I/O environments provide appropri

When you capture a SQL Profiler trace in a file and then you try to import the trace files into tables by using the fn_trace_gettable function in Microsoft SQL Server 2000, no rows may be returned. Additionally, you may receive the following error message: Server: Msg 568, Level 16, State 10, Li

(Jeremy Kadlec) You can improve your SQL performance by using indexes. But you have to choose the proper indexes and make sure the ones you do choose fit into your business situation. In this indexing guide, you will find answers to common indexing questions, indexing dos and don’ts, and tricks

(Kevin Beaver) Whether it is through manual poking and prodding or the use of security testing tools, malicious attackers employ a variety of tricks to break into SQL Server systems, both inside and outside your firewall. It stands to reason then, if the hackers are doing it, you need to carry the s