GilaMonster (9/23/2008)

---

When was the previous log backup taken?

Or when was the...

what if the transaction log back up is taken after the 3rd differential bachup

not at all....tho i think that these are the core DBA fields and each...

Anirban Paul (9/22/2008)

---

Jeff Moden (9/22/2008)

---

Ahmad Osama (9/22/2008)

---

but question here is that if i didn't get any experience on SQL server in next 90 days ..... then how will i pitch...

Jeff Moden (9/22/2008)

---

Ahmad Osama (9/22/2008)

---

but question here is that if i didn't get any experience on SQL server in next 90 days ..... then how will i pitch my self...

Matt Miller (9/22/2008)

---

For what it's worth - stable or no, happy or no, I wouldn't go around advertising who I work for. Especially if you don't have something else...

Loner (9/22/2008)

---

This is your first day and you start thinking to quit !!!!!!!! You did not catch in the wrong job, it seemed to me you caught in the...

thank u all

how can i get all databases aggregated in a single table ,....as sp_spaceused and dbcc showfilestats are database specific....

Renuka (8/29/2008)

---

Hi,

In Taskpad view the size is shown in MBs. Ideally it should match with the results of DBCC SHOWFILESTATS.

@used_space=(CONVERT(dec(10,2),usedextents*64/1024))

@total_space=(CONVERT(dec(10,2),totalextents*64/1024))

The results are in MBs and should match with Taskpad...

MANU (8/28/2008)

---

Ahmad,

Try this:

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 #db_file_information

( fileid...

Renuka (8/28/2008)

---

I am not sure if there is direct query or a command, but if you use DBCC SHOWFILESTATS it returns Total extents and the Used extents of the Database;...

Thanks...I used it to group all the database in a single table.

- I created a temp table to store the result set exec sp_msforeachtable...

Thanks I do know that....but how can I get it thru qry analyzer i.e PL/sql

thanks...