SqlServer-QA.net

It may not be a hardcore requirement on day-to-day basis to drop all tables, views and stored procedures from a SQL Server database within your environment, but it will be handy to have such a code at your end when such task is required. There are 2 ways to accomplish this, first using undocumented stored procedure such as ...

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

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

No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures.  Where the backup sequence comes the database RECOVERY model comes as another important ...

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be  listed on this  Windows Catalog and Hardware Compatibility, otherwise you may not be able to utilize or install full set of clustering ...

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

The following context is the one I have received from SQL Server Magazine that talks about a good backup tool in the market, study on:  Third-Party Tool Enhances SQL Server Backup and RecoveryMicrosoft SQL Server’s own backup and restore facilities are probably some of the most robust in the industry. So why consider purchasing a third-party ...

Like SQL Server Data, email is also an important aspect of day-to-day business life, more or less it is a business-critical communication tool, and downtime can be disastrous for your company. As like to the Disaster Recovery for your data, is your email environment performing at its highest level? Do you understand how the components ...

Until last month I was not  aware about Volume Shadow Copy and what is the relation between that service & SQL Server services, so here I would like to give the information in this regard that will discuss SQL Server connection issues that you may encounter when you use Volume Shadow Copy Service (VSS) enabled backup applications. SQL ...

Do you have a large ETL process to finish on day-to-day basis? Is your ETL process is suffering with performance loss during the BULK insert or export task? Are you using SQL Server 2005? If it is YES for all the above then you can take advantage of SQL 2005 in speeding up the ETL process to perform better. Also it is one of the best ...