SqlServer-QA.net

Hi,I run a stored procedure and it returns a result of a couple thousandrows. I need to get these rows into a temp table or table variable, andthen loop through the results. I need to run 1 or 2 queries for eachrows in this result set. What way is the best to go?Table variable / temp table. Cursor / while loop. I want to pass theresults to a ...

In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?  blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking to handle these important tasks in hand with the scripts and not to leave to the GUI or API ...

Refer a SharePoint Colleague!   Forward To A Friend ___________________ Want to receive Idera's monthly newsletter? Sign-up here   For a quick reference list of SharePoint URLs to commonly used administrative functions on a SharePoint site, visit the blog of Heather ...

I am using ssma to migrate db from oracle 9i to sql server 2000. I successfully migrated oracle tables,views,procedures,functions etc.. But can you please help me on how to migrate packages,triggers and indexes? Here i can able to view the headings like''Triggers'', ''packages'', ''Indexes'' in SSMA. But none of my oracle objects are displaying ...

As a DBA you might be aware that since SQL Server 2005 database maintenace plans have given flexibility in deploying the workflow of tasks required to make sure that your database is optimized, is regularly backed up, and is free of inconsistencies in addition to the avoiding the fragmentation on indexes with optimization tasks. This may be ...

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes occur in a database the changes are formed as transactions that are held in buffer pool ...

http://suguk.org/blogs/sharepointhack/archive/2008/03/17/9161.aspx

You may be aware that Database Mirroring is an important High Availability [HA] option available within SQL Server 2005 version. Having this HA option within your Sharepoint farm where the databases are associated to failover, then you must note few issues that might crop up in this case. Also you should be cautious when you have reporting ...

Here is a link for a white paper for database maintenence for Sharepoint Technologies http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as:  [Id]  INT (make this primary key clustered), [Unit_Id]  UNIQUEIDENTIFIER, [EventType_Id]   ...