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:
SQL SERVER – Random Number Generator Script – SQL Query
Random Number Generator. There are many methods to generate random numbers in SQL Server.
Method 1: Generate Random Numbers (Int) between Rang