Can a lookup query do your task here?

In my daily work, I have implemented a set of backup and restore strategy. The key component is to use one command to restore a DB to a point of...

Thanks, Robertm, for pointing out the bug. Really appreciate it !

Sameer, I have replied your email. Pls check it.

This SP will only display the relationship tree from the top...

In management field, there are generally two ways to encourage people to work harder: 1. Punish people for not doing well 2. Reward people for doing well. It seems Peoplesoft...

I especially like G Bryant McClellan's point that "each teaches you things about the other.", I cannot overstate the importance of this...

I like the power of PL/SQL, much better than T-SQL most of the time.

"I have a question, is a Database Developer more variable than a DBA according to the industry or vice versa?"

A DBA has the following major topics as his/her daily tasks:

1. Security 2....

Peter, if you use Exec('Use '+@DB+' DBCC ShowFileStats'), DBCC ShowFileStats will only show stats for TempDB instead of the current database, which may not be what David wants.

David, to solve ur problem, see below

CREATE TABLE #db_file_information(

  fileid integer

, theFileGroup integer

, Total_Extents integer

, Used_Extents integer

, db varchar(30)

, file_Path_name varchar(300) )

-- Get the size of the datafiles

insert into...

David,

I guess it is "Alter table" that caused you pain.

Try the following:

CREATE TABLE #db_file_information(

  fileid integer

, theFileGroup integer

, Total_Extents integer

, Used_Extents integer

, db varchar(30)

, file_Path_name varchar(300)

, dude as...

We should not blame Bill. The issue should be put into the global perspective. Just imagine if Cisco cannot outsource their R&D while Nortel /Siemans (non-US company) can, do you...

Gee, this is really the most attractive career-focused job description I have ever seen. If this position is still open 3 month later, I will apply for it.

Never mind, Mark, I love SSC because I can meet many talented peers here and share with my ideas and learn from their experiences.

Whether my view is economical or not is not important, the important thing is my approach is practical / flexible and helps me a lot in my daily work. I do not...

Based on your saying, it seems that we can take Better advantage of dbghost only if source control system exists. But in real world, this...