It is a bit tough to convince your boss if there are more than 100,000 employees in your organization. Usually the boss ends up saying that there is not much...

Another easy question... Thanks.

Do you have a job output file configured for the step. That would capture some useful information.

Try this link

There are a number of real time examples you could think of. I came across one such example...

Easiest question in QotD section. Thank you 🙂

AntoDN (7/26/2011)

---

My client wants me to create a number of quarterly read only filegroups on an ever growing database, and backup each file group just once when it's set to...

No, it wouldn't matter. The jobs will run based on the schedule.

You could try this.

http://www.amazon.com/Knights-24-Hour-Trainer-Integration-Programmer/dp/0470496924

This book comes with a DVD which is like an online tutor.

There are more titles by the same author (Brian Knight) on SSIS which you...

I am not sure if I understood your question fully but did you try making use of SSMS for scripting out the tables?

Good question Steve. Thanks.

GilaMonster (4/14/2011)

---

They don't move. Data does not move from the log to the data file.

When a transaction occurs the data page is changed in memory and the log record is...

Good question but I thought the answer sounds evident. Many people would choose 'NO' as the answer because the question sounds like that 🙂

Thanks for question. Guess we would get the right answer soon 🙂

Iulian -207023 (7/19/2011)

---

Thank you for the question

It says on msdn link:

"You can query the bpool_commit_target and bpool_committed columns in the sys.dm_os_sys_info catalog view to return the number of pages reserved...