Whats in the windows event viewer for the service start command?

It depends....

Speed of network

IO performance

What else is happening on the servers

GilaMonster (1/28/2013)

anthony.green (1/28/2013)

I take it you missed the "Get your free eBook download here." link on the webpage...

I take it you missed the "Get your free eBook download here." link on the webpage then?

bulk insert ... from '...' with (fieldterminator = ',', rowterminator = ', \ n') --Remove the spaces between , \ n

Need to ensure that there is a carrage return at...

Regular index maintenance is a must, you can use the free scripts provided by Ola for a comprehensive intelligent way to do index maintenance. There is a link to...

Use the ROWTERMINATOR option of the BULK INSERT command.

http://msdn.microsoft.com/en-us/library/ms188365.aspx

, \ n

or something along them lines, just remove the spaces.

Ah, an Oracle trigger, you would of been best posting that in the "Working with Oracle" section instead as this is primarily a Microsoft SQL Server forum.

Someone with Oracle experience...

Again it would depend on your data and how you want to analyse that data as to what route you need to take in your warehouse. Only you would...

How often is the table going to be inserted into?

But a simple insert trigger would do the job, if the inserts are very few and far between.

CREATE TRIGGER ..... ON...

Well it would all depend on your data, and how you want to slice and dice it.

I would recommend choosing a warehousing route, like Kimball or Inmon as various people...

A page is allocated to a table

An extent can be allocated to multiple tables.

An extent is what is created when new pages are required, it creates a 64k block, so...

Crispy

Use IIF or SWITCH expressions

=SWITCH(Fields!ServiceCallCompletion.Value < 90 "Red", "Green")

=IIF(Fields!ServiceCallCompletion.Value < 90, "Red", "Green")

You didnt need to detach the DB to do what you wanted.

A simple change of the recovery model to SIMPLE then CHECKPOINT the DB then shrink the file would of...