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

purushottam2 (1/27/2013)

---

Production db had the 100 GB of log file. to remove log file i did following steps.

- Deattached Database

- Renamed logfile

- Attached Database with-ought log file.

Above process creates new...

There is no SSRS2010, SSDT (SQL Server Data Tools) is built using Visual Studio 2010 is the means to create reports for SSRS 2012

SSRS 2008 and SSRS 2008R2 use BIDS...