Category: Articles
-
The Unhealthy Argument
This post of mine is 100 percent a personal opinion and was written not to hurt anyone. Off late, I have been hearing or knowing incidents which have involved 2 or more persons going into an argument on deciding which technology is the best is it WINDOWS or UNIX, ORACLE or SQL SERVER, .Net or…
-
Variable and Assignment enhancements
Variable and assignment enhancements are small plus points in SQL Server 2008. We have around 4 things to discuss under this and they are below. All of these are mostly helpful to developers. Declare Statement Compound Assignment Operators Row Constructors Table Valued Parameter (TVP) Lets discuss on this titles one by one
-
Troubleshooting Login failed Error 18456
Input : select * from sys.sysmessages where error = 18456 Output: Login failed for user ‘%.*ls’.%.*ls%.*ls This is one of the infamous error message (and number) that most of the DBAs and developers have come across while working on SQL server. This message simply denotes that the client call was able to reach the SQL…
-
Error: 7139, Severity: 16, State: 1
Last week in our company we have started facing some error while uploading documents to the table. We have an database in which we will be uploading all the documents related to the customers, when the user tries to upload the document he she gets the error message as shown below
-
Utilizing SQL 2005 Performance Dashboard in SQL Server 2008
I got a question from one of our UG member. He asked whether we can use SQL Server 2005 performance dashboard with SQL Server 2008. When we tried at the session we failed to implement it in SQL2K8. I was just thinking this today and planned to try this. I found out the reason why…