Browse by Tags

Get ready for SQL Server 2008 RTM release!

Are you desperate to get Relase To Manufacturing (RTM) release of SQL Server 2008? Well, long wait for SQL Server 2008 is nearly over. It is an official announcement that SQL Server 2008 will be on the August price list. This means that customers and partners will soon be able to place their orders for...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 07-11-2008
SQL Server Upgrade - don't forget the Collation issues?

Whenever any user (forum or usergroup) asks me about Upgrade gotchas and FAQs I will refer this SQLUpgrade-blurb post that I have made from my experience. Further I would like to enhance the topic of upgrade and things you need to watch about Collation settings, think the task when you have to perform...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 05-29-2008
End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?

The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement where few applications may have issues in...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 04-08-2008
SQL Server 2008 Express features and variation from previous version

Flood of questions fromthe users during a recent usergroup meeting. What will the specification for the SQL Server 2008 Express version be? What will be the differences between it and the 2005 version, not with MSDE? How about SQL Agent attachment to the SQL Express engine? Any memory limitations and...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 03-28-2008
SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation, in this regard review the blogs by SQLQuery...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 02-25-2008
SQL Server 2005 Bug Report

Saw this link to a SQL Server 2005 bug report on the Microsoft Connect site. I guess someone was having one of those days https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=253524&wa=wsignin1.0

Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-21-2008
SQL Server 2008 Certifications

As I am currently preparing for the MCDBA to MCITP 2005 upgrade exam (70-447) it may seem a bit premature to talk about SQL Server 2008 certifications, but there is a webcast available at Trika's blog (from the Microsoft Learning team) below. http://blogs.msdn.com/trika/archive/2008/02/08/sql-live-meeting...

Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-19-2008
SQL Server 2005 Index Optimization Best Practices

Do you have a maintenance window to perform database reindexing? Have you ever performed full set of re-organize and re-index process on a bigger database? Do you know there are best practices to deploy in this regard? On large database systems, with large numbers of insert and update commands, the problem...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 02-19-2008
Resources

Whitepapers & Webcasts SQL Server 2005 Waits and Queues Troubleshooting Performance Problems in SQL Server 2005 Whitepapers on SQLSkills.com SAP with SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability Top SQL Server 2005 Performance Issues for OLTP Applications...

Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-15-2008
Top Tips for SQL Server Clustering

As part of a current project I am working on, I came across this article , which includes a tip for clustering SQL Server workgroup edition using a combination of Windows clustering and virtual server !

Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-13-2008

Page 1 of 2 (15 items) 1 2 Next >