[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search

 Contents
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
SQL Server 2008
Tips
Troubleshooting
Tuning


Analysis Services

bulletHow to create an analysis services cube

Azure

bulletGetting Started with Windows Azure Platform

CLR Integration

bulletEnabling CLR Integration
bulletUsing CLR Integration in SQL Server 2005

High Availability

bulletBest Practices for Clustered Environments
bulletHow many nodes exist in a SQL Server Cluster
bulletHow to set a manual failover using Database Mirroring
bulletLocation of useful log files when troubleshooting SQL Server Cluster
bullet Move Cluster Storage to a New SAN
bulletShared Drives of a SQL Failover Cluster

Performance Tuning and Optimization

bulletEnable the Lock Pages in Memory Option
bulletInformation About Resource Waits
bulletSQL Server Performance Monitor Counters are Missing
bulletSystem Stored Procedure sp_recompile  
bulletTroubleshooting I/O Bottleneck

SQL Server 2008

bullet Backup Compression Feature
bullet How to install SQL Server 2008 (Katmai) - CTP November 2007
bullet How to install SQL Server 2008 Release Candidate 0 (RC 0)
bulletHow to install SQL Server 2008 R2
bullet New Spatial Data Types
bullet Performance Data Collector
bulletPolicy Based Management - Enforcing Recovery Model Full
bullet Preventing Undesired Actions Using Policies
bullet Report Designer Preview
bullet SQL Server 2008 - New Data Types
bullet Transact-SQL Query Editor IntelliSense
bullet Transparent Data Encryption
bulletUpgrading One Edition To Another Edition

Tips

bulletConfiguring Antivirus for MSSQL servers
bullet Database Snapshots
bullet Determining  Server Name using T-SQL
bulletHow to Disable SSL on Reporting Services
bullet How to install SQL Server 2005 SP3
bullet Know What Sessions Were Assigned to Each Workload Groups
bulletPorts and Protocols Used by Microsoft SQL Server 2000
bulletPorts and Protocols Used by Microsoft SQL Server 2005
bulletPorts and Protocols used by Microsoft SQL Server 2008
bulletSpeed Up Insert Performance
bulletUsing Transact-SQL for Full-text Indexing in SQL Server 2005

Troubleshooting

bulletA fatal error occurred while reading the input stream from the network. The session will be terminated
bulletAttach Database Failed
bulletBackup failed for Server
bulletBackup Log is terminating abnormally.
bulletBuffer Cache Hit Ratio Very Low.
bullet BusinessObjects: Connection or SQL sentence error: (DA0005)
bulletCannot access the specified path or file on the server.
bulletCannot Connect to SQL Azure.
bulletCannot create new connection because in manual or distributed transaction mode.
bulletCannot Launch Activity Monitor for a SQL SQL Server 2000 Instance
bulletCannot Open User Default Database.
bulletCannot show requested dialog (SqlMgmt)
bullet Cannot Start SQL Server Agent Service
bulletClass Not Registered (Microsoft.SqlServer.SqlTools.VSIntegration).
bulletCould not connect because the Maximun Number of 1 DAC Already Exists
bulletCreate Database Permission Denied.
bulletDatabase <databasename> exists but it is unaccessible.
bulletDetach Database Failed for Server. (Microsoft.SqlServer.Smo)
bulletError 15457 Severity 0 State 1.
bulletError 3205 Too Many Backup Devices Specified.
bulletError 51005: The row was not inserted in the alarm_history table.
bulletError Creating a New Job
bulletError has occurred while opening database 'DBName'.
bulletError Installing SCOM 2007 Database.
bulletError MsInstaller EventId 11706
bulletError on Data Protector Manager.
bulletError Registering Laserfiche Repository.
bulletError Reverting a Database to a DB Snapshot.
bulletFailed to Create Configuration Database
bulletHow to rebuild system databases in SQL Server 2005
bulletHuge SQLAGENT.OUT log file.
bulletIndex Corruption.
bulletINSERT failed because the following SET options have incorrect settings.
bulletInvalid Input Trace File.
bulletInvalid Operations Manager Database Version.
bulletjTDS Exception Connection Refused.
bulletjTDS Exception - Connection Timed Out.
bulletKB955706 failed to install
bulletLogin Failed for User
bulletLogin Failed for User Error 18452
bulletMS DTC was unable to start
bulletMsg 6522, Level 16, State 1, Line 3  ... Aggregate 'geometry'
bullet Msg 6522, Level 16, State 1, Line 3  ... Aggregate 'geometry' (2)
bulletMSSQLServerADHelper Event Id 100
bullet MSSQLSERVER Event ID 3041
bullet ODBC Error Installing VMware vSphere.
bulletORA-00904 Invalid Identifier.
bulletORA-12704 character set mismatch.
bulletPerflib. Event Id: 1023.
bulletProperty IsLocked is not available for login
bulletProperty Owner is not available for Database.
bulletPurge job history failed for JobServer
bulletReporting Services Catalog Error
bulletRestart Computer Failed
bullet Restore failed for Server
bulletSQLBrowser Event Id 3
bulletSQL Server Express 4 GB Limit
bulletSQL Server Resource Group Failed
bulletSQL Server Setup cannot install files
bulletSSPI handshake failed
bulletStarting Up Database
bullet Successful Installation SP3 not Applied on Server
bulletThe conversion of a varchar data type to a datetime data type resulted in an out-of-range value
bulletThe Media Family on Device is Incorrectly Formed
bulletThe Operating System Returned Error 21
bulletThe SQLBrowser service was unable to establish Analysis Services discovery
bulletThe Transaction Manager is not available
bullet This Recordset Is Not Updatable.
bulletWarning Server Agents Event Id 1123.
bulletWarning SQLSERVERAGENT Event ID 208
bulletWarning SysmonLog Event ID 2059.
 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.