Hi,

Have you identified what spid is utilizing CPU during 100% utilization?

Thanks,

Phillip Cox

Hey,

If you are restoring via the GUI, make sure...

Codezilla (2/13/2009)

---

I was doing a large insert into a table say about 400M> i noticed i was running out of space on the log drive. so my inserts were not...

Aldo,

You do not have to reinvent the wheel, as SQL Server is the perfect companiion to help resolve your challenge. You first need to understand your entire challenge in...

amarbreddy21 (2/11/2009)

---

How sql server understands the point at which the full backup is completed

how it recognizes and takes a differential backup from the point, the full backup has completed.

does...

aldo_marchioni (2/11/2009)

---

Thank you khrisna

Krishna (2/11/2009)

---

You really need more information on this:

The type of data and quantity of data to be replicated

and one thing that differs from most of them is...

aldo_marchioni (2/11/2009)

---

Hi to everybody.

Sorry if i post a long message, but it is much better to exlpain everithing at the beginning. Also, 'im quite e newbie to this stuff, so...

stephen.morris (2/6/2009)

---

We go through the same cycle everytime it reboots. The SQL Server fails to login. We go to enterprise manager and configure it to run ad domain...

Hi Peter,

This is a good issue and I have no immediate answers to improve on your current strategy, but I will continue to research.

In the mean-time, here is a good...

gusbrasil (2/5/2009)

---

I tried the 70-453 and passed the Pro part but not the TS part (got a horrible 550!). Anyway, I will try again soon after studying a little more...

GilaMonster (2/1/2009)

---

Just for your info, scalable shared databases are not a new 2008 feature. 2005 had the capability. It wasn't well knows, I doubt it was...

Hey heavymind1,

Thanks for that!

In terms of preparation, it was down to using the SQL Server 2005 experience and combined with review of new SQL Server 2008 features that provided a...

Hi Colin,

In an ideal world, you would have ability to work with development team to appropriately size all database storage requirements, including tempdb, but this is not the case and...

Hi All,

Thanks for sharing insight and I succeeded in passing exam!

Thanks,

Phillip Cox

SQL Server Consultant

MCITP - SQL Server 2008|DBAdmin

MCITP - SQL Server 2005|DBAdmin

MCTS  - SQL Server 2008

MCTS  - SQL Server 2005

MCP    - SQL Server...

Hi Colin,

As already suggested, I would argue against restricting tempdb, as any query that requires tempdb to store in-flight data will fail, thus a more serious problem surface. If...