February 2008 - Posts
One of the web application user complained about the above error during the upload process of images to SQL Server database! Most of the web applications have a lot of images used in it. Its not a best practice to store the Image/BLOB type data on the
Read More...
How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology
Read More...
Another set of Cumulative update package ready to download for SQL Server 2005 Service Pack 2, again only by the way of contacting the CSS. From our CumulativeUpdate blog series here is another one to add up as well and this CU6 package is only intended
Read More...
Until last month I was not aware about Volume Shadow Copy and what is the relation between that service & SQL Server services, so here I would like to give the information in this regard that will discuss SQL Server connection issues that you may
Read More...
In order to keepup the database logical and physical integrity of all the objects, you must run the DBCC statement such as DBCC CHECKALLOC, DBCC CHECKTABLE and DBCC CHECKCATALOG. Overall you can do this with another statement DBCC CHECKDB that will avoid
Read More...
One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout
Read More...
I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall
Read More...
If you are Developer then debugging your own code is an usual practice and when you got used to perform the same on SQL Server 2000 version, it is not an easy way in SQL Server 2005 version. As you may be aware that SQL Server 2000 engine includes a debugger
Read More...
Database Mail, very flexible to setup and easily manageable as compared to its pre-decessor (SQLMail) in previous versions! Unlike other software application features when it goes wrong its hard to find the root cause, for instance if you see the following
Read More...
When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled , the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL Server
Read More...
Postponement of SQL Server 2008 release has become old news now and within the SQL Server community (especially MVPs) there has been a state of commotion in demanding Service Pack3 for SQL Server 2005 version, true its the time isn't it! Coming to SQL
Read More...