Quoting BOL:

A code page is an ordered set of characters of...

Congrats!

I'm...

There is not enough information to give an answer to your question.

Please read the following article:

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

It kind of depends.

On what source will your reports be based on? If your sources are only relational databases, then you can skip SSAS.

If you have OLAP sources, you should...

Nice article, thanks for sharing.

They should be the same.

If you go to SSMS and delete something, you'll get the Delete Object window. At the top, you have a Script button. If you click this,...

Great, thanks.

The Microsoft SQL Server 2008 Internals was already on my "to read" list.

Now just...

GilaMonster (1/17/2011)

---

Considering there are some blatant inaccuracies in that article (shrink...

GilaMonster (1/17/2011)

---

Koen (da-zero) (1/17/2011)

---

It depends. If someone else has made changes to the table and the transactions are not yet checkpointed in the log file, you'll probably read it from...

How are you trying to get the data?

Did you write a SQL statement yourself? Or are you using a stored procedure? If the latter, do you have access to the...

GilaMonster (1/17/2011)

---

When you query SQL it reads from pages in memory, not pages on disk. Always.

If the page is not in memory, it's fetched in by the storage engine,...

No problem, glad to help.

EDIT: the answer I gave here was...

If you look at the screenshot you'll see that month is at the top, then year, followed by date. This is incorrect, year should be at the top.

I guess you are trying to connect with SQL Server authentication, right?

How do you input the password into the Execute Process Task?

Isn't it easier to use the Execute Package Task?...