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
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