Thanks for your valuable comments.

I am already on chapter 6 (SQL Server Version & Editions) and will finish it very soon. But really thanks to share this informative resource...

Yes, this is right IOPS will depend on lots of other things as well like:

How much data is already in RAM

Structure of...

Thanks for sharing the book. I have gone through first 4 chapters.

I got the info related to CPU (and its main properties to be considered), chipsets, RAM, controller.

In the...

I totally agree with Jacob here. I also experience the same. But I have got different scenario.

Instead of the NVARCHAR column in the database, we have nTEXT. In the...

After converting it to Text, it converts the datetime column values to Integer with the no of days since 1/1/1900.

Yes, both the settings are there (IMEX, TypeGuessRows) as suggested.

As of now the the data type of the column is mixed. Some are integer and some are dates.

If I...

I am facing another strange issue on the same excel.

One of the column in the sheet is having the data like

2003

2004

2006

2012

1/4/2012

4/10/2010

As of now, this column contains only these kind of...

This really worked perfectly as i was looking for.

Now the data type is always coming as nvarchar as i wanted.

Thanks for the solution.

I have a csv file which has 18 rows and 5 columns. I have transferred the file into a 2 dimensional array.

Now i am using a ForEach from Variable Enumerator.

In...

The database server is on the same server where SSRS is configured.

TO open the SSRS: i am using machine administrator account

For Database connectivity, previously i was using user: sa

and...

Really appreciate for having more than required information on license cost.:-)

GilaMonster (10/13/2011)

---

If you go CAL, you'll need 100 CALs. You have 100 users accessing the database, the IIS server is not the user.

If you go processor, you'll need 2 licences,...