Hi Gila,

Am executing the SP from SQL Server Query window. A little background of the sp is - it calls other sp's internally to retrieve the data, and this...

Hi,

Thanks for the explanation, and reason for asking this question is - the db on which am working has tables without any PK defined, but either a single or...

Hi Jan,

Even I had raised this question with the development team, but they could not provide me satisfactory answer. The tables are having huge data, and that's one of...

Hi All,

Thanks for the comments, and here's the code that I could get from the SQL Server Profiler when I worked with a report. The tables its referring donot...

Hi All,

One more doubt on partitioning.

- Do we need to have a primary key in the table which needs to be partitioned?

- Can I use a composite key index...

Hi Gail,

Am the so called consultant they have hired. My background is - Data Modelling, and they have picked me as Sr. DBA for this project. Fixing of queries...

Hi Gail,

Simple he wants to improve performance (as told by the development team). The application is quite old, and the existing db design dose not suit the current requirement....

Hi All,

Thanks for the response, and now one more doubt which might look funny. The db on which am assigned to work is used for report generation. The...

Hi,

Thanks for the concern, but as of now I don't have any option. The lucky part of mine is - client is not at my place and hence am...

Hi,

It's simple, else do follow these links. They should help you out in completing the task.

http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide.aspx

http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/

http://msdn.microsoft.com/en-us/library/ms143219(v=sql.100).aspx

Regards,

Sai Viswanath

Hi,

Well, I had gone through SQL BOL. It's informative, and the reason for posting this query is - am from Data Modelling background and currently been projected as...

Hi,

Thanks for the useful comments, and just now discussed with some QA guys and got an waque idea of how the work is happening. The job doesnot look...

Hi Gail/Shetty,

Thanks for the inputs, and I don't think will have a chance to change the datatypes from Char/Varchar to Int. Reason, they have huge archive db's and...

Hi,

Thanks for the inputs, yes the guys who have designed the db have created indexes on almost all the columns present in the table. That's the reason - in...

Hi Gail,

It's not a single column in the table, almost all the columns are defined in that manner. If changing the datatype doesnot improve, do you have any other...