As part of the launch of SQL Server Migration Assistant (SSMA) for Oracle, Microsoft is looking for the most compelling Oracle to SQL Server migration story.
Tag: sql server
FIX: You receive an ‘Error: 8526, Severity: 16, State: 2’ error message when you use SQL Query Analyzer to start a distributed transaction after you have installed SQL Server 2000 SP4
When you use a client application such as SQL Query Analyzer to start or to enlist into a distributed transaction after you have installed Microsoft SQL Server 2000 Service Pack 4 (SP4), you receive an error message that is similar to the following: [Microsoft][ODBC SQL Server Driver][Shared Memo
FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a SQL Server 2000 full text search of Office Word documents
Consider the following scenario: • You run Microsoft SQL Server 2000 together with the Full Text Search component. • You start the filtering daemon (Mssdmn.exe) to parse Microsoft Office Word documents.
DBAs Bar Door Against Big Bad .Net Wolf
(Lisa Vaas) Microsoft has been mercilessly tightening the screws between SQL Server and stack components BizTalk Server and Visual Studio—a tighter integration that’s making developers gleeful and causing DBAs to cringe.
SQL Server normalization rules you must follow
(Greg Robidoux) In this tip we will take a look at database normalization and the advantages and disadvantages of normalization for SQL Server databases. (R)
Exploring the various uses of SQL’s CASE keyword
(Arthur Fuller) The CASE keyword may be one of the most underused keywords in SQL. While you’ve probably used it to create a column, it has many more uses. For example, you can use CASE in a WHERE clause.
FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000
When you use a SELECT statement to fetch information from a view, and the SELECT statement returns an error message in Microsoft SQL Server 2000, the error message may contain user data. The user data is not returned in the final result if the SELECT statement successfully fetches data from a view.
Working with the SQL Server 2000 Maintenance Plan Wizard
(Steven Warren) Managing a database server is like owning a piece of machinery. You need a maintenance plan to keep the machinery running smooth. Just as your machinery required maintenance, your databases need attention to ensure great performance. To help keep your databases in tiptop shape, I am
Undocumented stored procedure: Repair table indexes with sp_fixindex
(Serdar Yegulalp) In its collection of undocumented stored procedures, SQL Server 2000 has a function called sp_fixindex that can be used to repair the index for a given system table. System table indexes are crucial elements of a smooth-running SQL Server, making it necessary for you to be able to
FIX: Event ID 20 ‘Volume Shadow Copy Service error’ is logged when you back up the System State on a Windows Server 2003 x64 Edition-based computer that is running SQL Server 2000
When you perform a System State backup operation on a Microsoft Windows Server 2003-based computer that is running Microsoft SQL Server 2000, both of the following events are logged: • Event ID 20 Event Type: Error Event Source: VSS Event Category: None Event ID: 20 Date: date Time: tim