SQL Server is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure but ...

I changed the server.scripttimeout to 999 and I still get problems. It timesout before the time limit i specified. Here is the situation. Users can check a number of check boxes on an ASP page and ...

We've got a strange problem here and I'm hoping someone has some kind of idea as to what could be causing it. We've got a stored procedure in Sql Server 2005. It's not terribly complicated but it's ...

Database connectivity gives desktop and Web applications much of their value. .NET developers have products and framework objects that can tie a front-end application to SQL Server, MySQL, Sybase, ...

Everyone wants faster database queries, and both SQL developers and DBAs can turn to many time-tested methods to achieve that goal. Unfortunately, no single method is foolproof or ironclad. But even ...

The latest version of Microsoft's flagship database, SQL Server 2005, introduces an enormous number of enhancements to the product's security, scalability, performance, and programmability features.

Microsoft continues to make positive strides in the world of open source. The company once considered open source software to be an anathema, but now it’s common for Microsoft to pull software ...