SQL Server Misc

SQL Server Error FAQs (All)

Add Node to A SQL Server failover Cluster failed with invalid SKU errorSQL Server Destination remote server errorAdd Node to A SQL Server failover Cluster failed with invalid SKU errorAn ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode XQuery [query()]: Attribute may not appear outside of an elementCannot find […]

SQL Server Clustering FAQs (All)

We are unable to install SQL Server 2005 on additional node on top existing cluster setup running Windows 2003 x64 bit operating system? What is the usage of the WITNESS instance in SQL Server 2005 Database Mirroring?What are the specific tasks assigned to System Administrator (SA)role in SQL Server? How can I disable or rename […]

SQL Server General Developer FAQs (All)

Multiple lookups to the same table in SSIsHow to unzip a File in SSIS?How to view previous query plans?How to Change schema in a SQL Server table?How to Debug SQL Server 2005 Stored procedure?SQL Server Reporting Server (SSRS) service is failing to start How to Import Excel 2007 Version to SQL Server using SSISUsers are […]

SQL Server DBA Performance Tuning FAQs (All)

How can I confirm whether a SQL Server installation is 32 or x64 bit?Using SQL Server 2005 cannot Connect to a Remote SSIS Server?Why can’t I install multiple instances of SQL Server Integration Services components on the same physical server?What is the effect of DBCC CHECKDB and DBCC DBREINDEX on the Transaction log?How do I […]

SQL Server Developer Performance Tuning FAQs (All)

How can I confirm whether a SQL Server installation is 32 or x64 bit?Using SQL Server 2005 cannot Connect to a Remote SSIS Server?Why can’t I install multiple instances of SQL Server Integration Services components on the same physical server?What is the effect of DBCC CHECKDB and DBCC DBREINDEX on the Transaction log?How do I […]

SQL Server General DBA FAQs (All)

Import Data Using SSIS from an Excel Workbook which has Dynamic Sheets Using SSIS invoke-sqlcmd Not Recognized ORDER BY behavior with NOLOCK Automate Generate Scripts in SSMS Invoke-Sqlcmd vs sqlcmd utility Change Select Top 1000 Rows value in SSMS Change The SQL Server Port Number Change Edit Top 200 Rows value in SSMS Decode COLUMNS_UPDATED […]

SQL Server ASP.NET / ADO.NET Articles (All)

WCF Tutorial ASP.NET Hosting Guide WebMatrix Tutorial – Getting Started ASP.NET 4.0 – New Features 50 Tips to Boost Performance of an ASP.NET Application – Part 2 50 Tips to Boost Performance of an ASP.NET Application – Part 1 Implementing a Generic Data Access Layer in ADO.NET Part 1 Implementing a Generic Data Access Layer […]

SQL Server General DBA Articles (All)

Adding Column to a SQL Server Table Implementing Database Settings Using Policy Based Management Manage and Monitor Identity Ranges in SQL Server Transactional Replication Controlling Growth of a Distribution Database Monitoring Transactional Replication – The Distribution Queue New T-SQL Features in SQL Server 2011 ERROR_PROCEDURE does not return a schema name Understanding SQL Server 2008 […]

SQL Server Reporting Services Articles (All)

SQL Server Data Mining with Microsoft Office Excel Backup and Restore of an Analysis Services Database Reporting Services 2008 R2: Geospatial Visualization – Part I Data Warehouse Partition Strategies Tweaks in SQL Server Reporting Services Enhancing Reporting Services with Dundas Reporting Controls Using Report Parameters in SQL Server Reporting Services Overcoming Software Limitations in Multidimensional […]

SQL Server Developer Articles (All)

SEQUENCE in SQL Server 2011 Monitor User Connections in SQL Server Denormalization in SQL Server for Fun and Profit Understanding WCF Hosting Introduction to SQL Azure Writing Custom Rules for FxCop New Controls in ASP.Net 3.5 Getting Started with the ADO.NET Entity Framework Part 3 Getting Started with the ADO.NET Entity Framework Part 4 Getting […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |