Finding the relationship of a filegroup and a partition

The other day, I was trying to find out which partition is on which filegroup for a a partitioned table....

Another use of OpenRowSet()

From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.

Traditionally,...

Distributed Transaction Issue Msg 7391

I solved an "interesting" issue today. It is about distributed transaction. When I set up transactional replication with immediate updating...

Generate RPC:Completed Event

I was doing a research on SQL trace regarding RPC:Completed event. So I need to generate a RPC:Completed event first...

save disk when doing backup

As a DBA, most of us will also take care of test environment. However test servers usually cannot afford to...

Survive A SQL Server DBA Technical Interview

Another little bit of career advice, this time from longtime author Jeffrey Yao who gives you some pointeres on what you should know for your next job interview.

How to be a Good DBA - Strategy and Tactics

New Author! And long time reader - Jeffrey was site member #712, almost 3 years and 130,000 members ago! This article describes the skills needed to progress from junior to intermediate to senior DBA.

Let database work for your daily life

I know there are many off-shelf stuff, like MS Money, that can help you organize your personal financial things, but...

about xp_sendmail

I got a very interesting issue, I may guess the reason but not sure why it is this way.
Symptom: Logon to...

one issue about SQL 2000 BOL

This is my first post, congrats to myself.
DTS Connection object does not list "UseTrustedConnection" property
I am working on a...