Error:
Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
1) Enable Server for CLR Support.
SQL SERVER – Fix: Error: HResult 0x2, Named Pipes Provider: Could not open a connection
In this blog post we are going to fix the error which is related to Named Pipes Provider.
SQL SERVER – Index Optimization CheckList
Index optimization is always interesting subject to me. Every time I receive requests to help optimize query or query on any specific table. I always ask Jr.DBA to go over following list first before I take a look at it. Most of the time the Query Speed is optimized just following basic rules mentioned below. Once following checklist applied interesting optimization part begins which only experiment and experience can resolve.
SQL SERVER – DBCC Commands to Free SQL Server Memory Caches
Lots of people do not know that following command can be very helpful to clear your memory caches of SQL Server. I have often seen people restarting their entire system to clear the memory caches.
SQL SERVER – Enable Login – Disable Login using ALTER LOGIN – Change name of the ‘SA’
Enable Login – Disable Login using ALTER LOGIN – Change name of the ‘SA’
SQL SERVER – Collate – Case Sensitive SQL Query Search
In this blog post we are going to learn about how to do Case Sensitive SQL Query Search.
If Column1 of Table1 has following values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records.
SQL SERVER – SET ROWCOUNT – Retrieving or Limiting the First N Records from a SQL Query
A SET ROWCOUNT statement simply limits the number of records returned to the client during a single connection. As soon as the number of rows specified is found, SQL Server stops processing the query. The syntax looks like this: