Linda Johanning (8/20/2008)

---

Think of this scenario. A company purchases a 3rd party product and the vendor installs the software, IIS, and database server onto one server. They add...

To be honest with you, Vivien, whenever I see requirements like

Vivien Xing (8/14/2008)

---

* Expertise covering a broad range of specialized skills

* In-depth project management, vendor management, and business process...

I have a feeling those "un-replicated" tables are not included in the publication in the first place.

On the publishing database, run the following

select * from sysarticles

where name='un-replicated table name'

and see...

Coby Barrus (8/5/2008)

---

Thank you everyone for the great advice. I'll put some deep thought in to writing up a few articles regarding recruiting trends, the Volt environment, technical recruiting,...

Coby Barrus (7/31/2008)

---

Hello!

As a Recruiter for Volt Technical Resources in Redmond, Washington, am I able to announce our SQL Developer, DBA and T-SQL positions? I noticed that there...

Check BOL sp_helpSubscription

In the return set, there is a column called "Subscription type", 0 = push, 1=pull, 2=anonymous

HTH,

J.Y

Check the log space usage before and during the exectuion (wiht begin tran / commit tran), if you find the log space usage is increased by your insert sqls, I...

When serveral big inserts are combined in one transaction, there is a "hot" demand for the log space. Without "begin tran / commit tran", as soon as one insert is...

Huge congrats, Jeff and Michael !

GilaMonster (6/18/2008)

---

Two things come to mind for me if a person 'refuses' to write the test or complains about it not been necessary.

First, are they trying to hide...

I think we should not under-estimate the value of a well-designed test. IMHO, these days, lots of questions in a MCP test are scenario-based, it is not about to memorize...

I think another way to do interview is to get the candidate into an unbiased test (without allowing the candidate to do any preparation).

Last year, when I responded to a...

It is a really interesting topic to discuss about what an exceptional DBA should be.

An exceptional DBA can be judged from many perspectives. But IMHO, to be an exceptional...

What a sad hit to SQL Server community ! My deepest condolence to his family !

Ken, may you rest peacefully in heaven ... we will forever miss you in this...

Running job every minute really does not matter as I have seen lots of production systems that have jobs running every minute. However, here the assumption is the job can...