New & Notable
Microsoft SQL Server Database Development News
March 01, 2005
SearchSQLServer.com is dedicated to serving the information needs of database developers, administrators and managers working with Microsoft's flagship database enterprise server: SQL Server and the upcoming SQL Server 2005.
Microsoft SQL Server Database Development Get Started
Bring yourself up to speed with our introductory content
A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Continue Reading
Evaluate Microsoft SQL Server Database Development Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Features available in SQL Server to identify rows in a table are comparable to those offered by Oracle, such as Rownum and Rowcount. Continue Reading
Product ReviewsPowered by IT Central Station
Pros: Flexible, Open-ended, Useful default values and fields. Cons: Deep and complex, it takes a while to familiarizePowered by IT Central Station
Want Project Management Tool? I tried OpenProject.org and got frustrated with its performance (because it's Ruby-based ?) and skimpy features. ...Continue Reading
Our development team and it's functional staff have gained a better overview of the issues that are being worked onPowered by IT Central Station
Valuable Features: <ul> <li>Ability to search old issues.</li> <li>Ability to create your own tags and fields, ie...Continue Reading
My deployment was expensive due to the complexities I implemented. Other deployments have been less expensive.Powered by IT Central Station
Valuable Features: Workflow configuration (escalation, workflow chaining, conditions, validators, post-scripting, etc) Improvements To...Continue Reading
Problem Solve Microsoft SQL Server Database Development Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
I'm currently working on table partitioning. I'm struggling with using this " SELECT MAX(NAME) from sys.filegroups WHERE NAME NOT LIKE 'PRIMARY' " in order to get the last used Filegroup. Now this works just fine, but when I run the following script... Continue Reading
While working with business objects in SQL Server I am getting the error "conversion of char data type to datetime data type resulted in an out of range datetime value." What is the problem? Continue Reading
I received this error: "XP and VS2003 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." The same page under Server 2003 works well. I need to continue developing under XP, what can I do? Continue Reading