SqlServer-QA.net

In continuation to Tech-ed North America - what I'm doing there? & Say goodbye to Tech-ed 2008 Developers and say hello to IT-PRO! posts here and to wrap up the earlier posts about Tech-ed Online Panel: Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy the panel discussion video is available to view for ...

Are you visiting Tech-ed, North America? Tech·Ed offers the premier technical education conference just for IT professionals. Microsoft and industry experts will share their expertise about how to architect, deploy, manage, and help secure a connected enterprise. With only a few weeks to go, there’s still time to register for Tech·Ed IT ...

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 Processing team about offline ...

From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy to download files from the Microsoft download site, you have to submit a Online Customer ...

SQL Bits is back again, this time 01st March 2008 at The Lakeside Conference Centre in Birmingham. Its a bigger venue than Microsoft TVP that will give more people 'SQL Geeks' to attend. Hold on your horses, registrations aren't open yet but if you register on the site you will get the information when it is available. If you are ...

A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application is initiated and data is stored with relevant scheduled jobs and processes the ...

All of sudden the re-org of an index started failing and no error was displayed within that scheduled job we execute. After executing the code from Query Editior I was able to get the message as follows:  Msg 2552, Level 16, State 1, Line 3The index ''<name>'' (partition 1) on table ''TableName'' cannot be reorganized because page ...

So July2007Ctp is available now and you need to learn more details about this release, then look at the calendar of events (online & webcasts) that are lined up by Microsoft SQL Server Developmetn Team. The first event is scheduled to host on 13th August 2007, register for July CTP Public Web Chat and don't forget to Add ...

I have written an article explaining how effectivley you can take help of SQL Server 2005 books onilne here. I'm a big fan of BOL that has given me relevant first hand help whenever needed.

In SQL Server designing efficient indexes is paramount to achieving good database and application performance. The selection of the right indexes for a database and its workload is a complex balancing act between query speed and update cost. Narrow indexes, or indexes with few columns in the index key, require less disk space and maintenance ...