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....
2007-12-12
1,538 reads
The other day, I was trying to find out which partition is on which filegroup for a a partitioned table....
2007-12-12
1,538 reads
From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.
Traditionally,...
2007-11-29
1,394 reads
I solved an "interesting" issue today. It is about distributed transaction. When I set up transactional replication with immediate updating...
2007-11-21
3,460 reads
I was doing a research on SQL trace regarding RPC:Completed event. So I need to generate a RPC:Completed event first...
2007-11-14
1,714 reads
As a DBA, most of us will also take care of test environment. However test servers usually cannot afford to...
2007-11-11
371 reads
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.
2007-10-12 (first published: 2006-07-10)
36,078 reads
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.
2007-10-02 (first published: 2004-03-03)
38,863 reads
I know there are many off-shelf stuff, like MS Money, that can help you organize your personal financial things, but...
2005-09-11
1,330 reads
I got a very interesting issue, I may guess the reason but not sure why it is this way.
Symptom: Logon to...
2005-09-09
1,370 reads
This is my first post, congrats to myself. 🙂
DTS Connection object does not list "UseTrustedConnection" property
I am working on a...
2005-09-08
1,341 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers