The SQL Post

Ashish Upadhyay's Blog : The SQL Post!

Pages

Home
Performance Tuning
SQL Server Architecture
SSRS
SSIS
T-SQL
Best Practices
DBA

SQL Server Architecture

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

Home

Subscribe to: Posts (Atom)

About Me

Ashish Upadhyay

View my complete profile

Search This Blog

Total Pageviews

Popular Posts

SQL Server Error: Invalid use of schema or catalog for OLE DB provider "SQLNCLI11" for linked server "*". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

SQL Server Error: Recently I was building a new database infrastructure on SQL Server 2012 to run a third party application called Rela...
Adding DEFAULT value for a column in SQL Server

By Ashish Upadhyay What is Default Value in SQL Server? Default is a constraint in the SQL Server which provides the ability can be app...
The SQL Server failover cluster instance name 'SQLCluster01' already exists as a clustered resource. Specify a different failover cluster instance name.

I got below issue during a new 3+1 SQL server cluster environment setup for SQL Server 2008 R2 Enterprise. This is because you have alrea...
Microsoft SQL Server: Error: 909 while migrating a Database from SQL Server Enterprise Edition of SQL Server 2008 to any lower Edition

By Ashish Upadhyay Problem: While trying to migrate the database from SQL Server 2008 Enterprise Edition to Standard Editon or Ex...
Microsoft SQL Server, Error: 4064 (Cannot open user default database. Login failed.)

SQL Server Error: TITLE: Connect to Server ------------------------------ Cannot connect to * (Server Name). ----------------...
Best Practices are for paging large datasets for SQL Server based databases.

by Ashsh Upadhyay Paging is one of the common scenario in the industry for any projects dealing large records and have a UI to pool...
Column '*' in table '*' is of a type that is invalid for use as a key column in an index. (Microsoft SQL Server, Error: 1919)

Scenario: TITLE: Microsoft SQL Server Management Studio ------------------------------ Create failed for Index 'tmp_IX_*...
SQL Server failover Cluster: The operation could not be completed because the cluster resource is online.

During the SQL Server failover cluster installation you may get following error while trying to delete any cluster resources. Problem: ...
SQL Server Error: Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1 (SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.)

I was trying to enable xp_cmdshell on one of our SQL Server in order to calculate folder size and got below error, just thought to share o...
SQL Server: User Defined Function to Split delimited text

SQL developers frequently need to split comma delimited text or string delimited by any other delimiter. I am placing a generic user define...

Labels

Active Connections (1)
Active Processes (1)
all_sql_modules (1)
Backup (2)
Backup & Restore (2)
Backup directory (1)
Best Practices (1)
Clustered Index (4)
Comma Separated List of Indexes (1)
Configure Database Mail (2)
Current Connections (1)
Data Compression (1)
Database Backup (2)
Database Development (1)
Database Mail (2)
Database Migration (1)
DataTypes (1)
Default (1)
Default Directory (1)
Failover cluster (2)
Foreign Key (2)
Get All Index from SQL Server database (1)
Get data file location (1)
Index (1)
Index Architecture (3)
Index Internal (3)
Indexes (4)
Joins (1)
Linked Server (1)
List of Columns (1)
List of current connections (1)
List of Indexes (1)
Manage Permission (1)
Microsoft SQL Server Error (8)
Non-Clustered Index (4)
Paging (1)
Recovery Model (1)
Send email from database (2)
sp_MSforeachdb (1)
SQL Server (15)
SQL Server 2005 (27)
SQL Server 2008 (37)
SQL Server 2008 R2 (35)
SQL Server 2008 R2 and SQL Server 2012 ( Release Candidate) (4)
SQL Server 2012 (26)
SQL Server 2014 (1)
SQL Server Architecture (6)
SQL Server Connections (1)
SQL Server failover Cluster (2)
SQL Server Troubleshooting (1)
sql_modules (1)
SQLRootDirectory (1)
syscomments (1)
sysmail_allitems (2)
sysmail_faileditems (2)
sysmail_log (2)
sysmail_mailitems (2)
sysmail_sentitems (2)
sysmail_unsentitems (2)
sysobjects (1)
T-SQL (14)
TempDB (2)
User Defined Functions (2)
xp_instance_regread (1)
xp_instance_regwrite (1)

Ashish Upadhyay, www.thesqlpost.com. Simple theme. Theme images by 5ugarless. Powered by Blogger.