Sample From Desktop

This is sample blogging from Google Blogger Desktop

Comments

Post a Comment

Popular posts from this blog

Alert : can not set credentials for principal sa

  While editing credentials of database user, you may get this error in Sql Server 2008 management studio. It is just a checkbox that needs to be checked to resolve this issue. But this may save your few minutes finding the issue cause. Here is a great link for resolving this issue – http://weblogs.asp.net/atlaszhu/archive/2009/08/08/alert-cannot-set-a-credential-for-principal-sa-when-trying-to-modify-sa-properties-through-sql-management-studio-2008.aspx Technorati Tags: sql server , login
Read more

Get Unused Stored Procedures from Sql Server 2008

While working in projects, I always used to wonder about maintaining Stored Procedures in Sql Server. The way in which we organize them is that we go on adding the required stored procedures with some name convention so that we can identify what is the module to which this SP refers. But as the project goes ahead modifications come, we go on adding required Stored Procedures and some Stored Procedures become obsolete because of business rule changes. But as far as I have observed in IT projects, these stored procedures are kept as it is and when the project completes no one has any idea about which Stored Procedures are currently in use and which are obsolete. But I have come across this post , which shows how to get probably unused SPs from Sql Server 2008. The query is as follows, which returns SPs which are not in procedure cache. //The first part gives list of all SPs and also works in SQL2005 Select p.name From sys.procedures as p wh...
Read more
Digital Divide Of 32 Bit And 64 Bit There are lot of products from hardware and software speaking about 32 and 64 bit. The article is an effort to understand the differences for common user. Your hardware and software both can be 32 bit OR 64 bit. If your hardware i.e. processor and other peripherals support 64 bit, then you can run 64 bit supported software on it provide you have 64 bit Operating System such as Windows Vista 64 Bit. 1.Software:- 32 bit OS Features of 32 bit OS: - Good for systems running 32 bit applications and having data sets smaller than 2GB. Supports - 4GB System Memory 2 GB Dedicated memory / process eg. Windows Vista, Windows Server 64 bit OS What do you mean by 64 bit OS? More than 4GB Dedicated Memory/process can be supported 64 bit of data can be moved per clock cycle. Features of 64 bit OS: - ASLR(Address Space Layout Randomizer) – It ensures system fil...
Read more