Sorry Noeld

What do yoy mean exactly

Thanks you for sahring the info.

Hi,

I have just 3 years as DBA.

I am leaning a lot helping you.

Did you replace username by your login user and password by your login passwor in the following

EXEC...

Hi David,

check this link a good site for database design http://www.databaseanswers.org/data_models/index.htm

Regards,

Ahmed

you mean to load the created xml file

Hi David,

Like I see you have snowflake data model, If I really understood, for me, I will create a table location(locationId, locationName) and each table will have the location id...

Hi krishna,

Use SSMS, in the Object Explorer, Right click on your database, choose task the generate script.

Just follow the wizard script instructions.

Regards,

Ahmed

Hi Anujahnavi,

bcp Bulk Copy

Check the link http://msdn2.microsoft.com/en-us/library/ms162802.aspx

Elements

Check link http://msdn2.microsoft.com/en-us/library/ms188273.aspx

root('tracks') I have just a root node to the xml document to be valide.

alter Trigger TestTrigger

On dbo.tablefortrigger

For Insert

As

Begin

Set...

Hi anujahnavi,

set nocount on

EXEC master.dbo.xp_cmdshell 'bcp "select * from tablefortrigger order by track FOR XML Auto, ELEMENTS, root(''Tracks'')" queryout c:\Result.xml -S. -Uusername -Ppassword -c -r -t', no_output

set nocount off

Regards,

Ahmed

Hi Kyle,

MSDN Virtual Lab: SQL Server 2005 SQL Query Tuning

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032286853&EventCategory=3&culture=en-US&CountryCode=US

MSDN Webcast: Application Performance Tuning Using SQL Server Profiler 2005 (Level 200)

http://msevents.microsoft.com/cui/webcasteventdetails.aspx?eventid=1032266508&eventcategory=5&culture=en-us&countrycode=us

TechNet Webcast: Troubleshooting Performance...

Hi,

Check the following

http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/

http://support.microsoft.com/kb/224071

Regards,

ahmed

Hi Suchita,

sp_spaceused 'tablename'

Regards,

Ahmed

Hi,

You need to create a job to check if the log growth reach a certain threshold, then make the truncate of log.

Managing SQL Server 2000 Transaction Log Growth

Hi Devon,

Memory you are limited to 2 G and 4 CPUs

Check thoses links for more info

Comparison Between SQL Server 2005 Standard and Enterprise Editions

http://www.microsoft.com/sql/editions/enterprise/comparison.mspx

difference between SQL 2000 Enterprise/Standard

Hi,

It's just a temporary table, if you want to keep it, it ok.

You can put this code in stored proc.

Regards,

Ahmed