Try the Microsoft Certification site:

http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

SQLServerCentral.com and Google are your friends but experience is a MUST.

web.config files are generally used in .NET development. This is SQL Server forum. Also, there's not enough details in your question to direct you to a resource or to answer...

Very good. After learning to build, configure and deploy cubes this is an excellent next step.

Great question thanks.

For this type of scenario, I would look at maybe implementing a calendar/tally table that holds all the necessary information against each day.

My own calendar table stores (for each...

ananda.murugesan (9/17/2012)

---

please find the attached sample data for header and detail table

CREATE FUNCTION [dbo].[GetDataType] ( @Table varchar(50), @fld varchar(50) )

RETURNS varchar(1)

AS

BEGIN

Declare @datatype varchar(1)

select...

Nice question thanks!

All of the above and more - don't forget people skills as you'll be liaising with business owners, budget holders, developers, data protection individuals and other database professionals.

I'm not sure...

Have you check the service Dependencies?

Might be useful to see some data!

Its also depends on whether the columns you are joining on are indexed.

Indexing and performance is a large topic in it's own right.

Too many indexes on a large table...

Thanks Phil, I saw your reply just after I posted mine...

Doing SSIS research as we type...

I'm a bit unclear of your requirements but I assume you want to extract the Month and Year from a given date and create a string from the components in...

I've often been asked to attend meetings as the database\technical contact.

The audience is usually the business managers with low or very little experience with databases, hardware and all the...

Good question and explanation