background preloader

SQL Server

Facebook Twitter

Test - Google Search.

TempDB optimization

Test. Tuning. Transact SQL. How to: Install SQL Server 2008 R2 from the Command Prompt. Can Analysis Services be upgraded from lower version to SQL 2012?

How to: Install SQL Server 2008 R2 from the Command Prompt

The article says for "Prepare Failover Cluster Parameters" - there is no mention of /ASSERVERMODE switch. But under "Complete Failover Cluster Parameters" - there is /ASSERVERMODE switch provided. Is this a typo? Getting a popup Window during the Silent uninstallation of SQL Server 2008 Dev R2. Managing Data Sources. After you have installed an ODBC driver from the driver's setup program, you can define one or more data sources for it.

Managing Data Sources

The data source name (DSN) should provide a unique description of the data; for example, Payroll or Accounts Payable. The user and system data sources that are defined for all currently installed drivers are listed in the User DSN or System DSN tabs of the ODBC Data Source Administrator dialog box.