Problem solve
Get help with specific problems with your technologies, process and projects.
Problem solve
Get help with specific problems with your technologies, process and projects.
Top SQL Server resources
An introduction to SQL Server 2005's CLR functions
Among the new features in SQL Server 2005, the one that has the most relevance for programmers is the Common Language Runtime. Serdar Yegulalp discusses CLR's advantages here.Continue Reading
SQL Server backups made easy using Maintenance Plans
If you're new to SQL Server and not sure how to set up backups, Maintenance Plans may be the way to go. Although not all of the backup functionality is available using Maintenance Plans, Microsoft has developed an easy interface to set up backups for all of your databases.Continue Reading
-
SQL Server OLTP vs. data warehouse performance tuning
This article discusses two broad categories of SQL Server processing -- online transaction processing (OLTP) and data warehouses -- and outlines performance-tuning tips for each.Continue Reading
SQL Server 2005 Express
Along with the upcoming release of SQL Server 2005, Microsoft is introducing a new edition of SQL Server called SQL Server Express -- a free version of SQL Server 2005.Continue Reading
SQL Server 2005 bitmap index?
Why do applications use a single log on to SQL server?
Not allowing TEAM-SQL users to log in with SQL Server authentication
Convert owner field as loginAdmin
Fragmentation based on results from DBCC SHOWCONTIG
-
Return a SQL Server storing 100GB of data
Which process is consuming majority of central processing unit?
Speed up application
Convert English language database into Japanese
Find S_name & S_marks of which student gets 2nd highest marks in table
Development expert Andrew Novick explains how to use a TOP clause on a SELECT statement to query a table.Continue Reading