Ninja's_RGR'us

Forum Replies Created

Viewing 15 posts - 7,186 through 7,200 (of 18,923 total)

RE: know TSQL, need to learn PLSQL

PaulB-TheOneAndOnly (2/7/2011)
Oracle documentation is free so, when in doubt RTFM 😉
Here http://www.oracle.com/pls/db102/portal.all_books
And I thought BOL was huge!!! :w00t:

February 7, 2011 at 11:00 am

#1283315
RE: know TSQL, need to learn PLSQL

http://www.functionx.com/oracle/Lesson03.htm

February 7, 2011 at 9:14 am

#1283202
RE: I lied, now what?

GSquared (2/7/2011)
GilaMonster (2/7/2011)
SuperDBA-207096 (2/7/2011)
Wow. There are people who do lie on thier resumes, and I've interviewed quite a few of them. NEver ceases to amaze me... one person...

February 7, 2011 at 8:46 am

#1283165
RE: concatenate Rows using group by

rockingadmin (2/7/2011)
Hi
i want to concatenate rows based on group of values in sqlserver 2000. from sqlserver 2005, we can use it in many ways like XPATH,CTE...

February 7, 2011 at 6:33 am

#1283068
RE: How do I shrink the size of backup file

mw112009 (2/4/2011)
Sorry, I should have mentioned this earlier.
I just ran the script against another database to see how it worked.
This is not the real database that is giving me...

February 4, 2011 at 11:03 am

#1282600
RE: How do I shrink the size of backup file

mw112009 (2/4/2011)
mw112009 (2/4/2011)
Hope this output is very clear ( Earlier reponse the numbers got mixed... )
3550.19 304.26 ...

February 4, 2011 at 10:57 am

#1282597
RE: How do I shrink the size of backup file

mw112009 (2/4/2011)
Ok ran the first script --- here are the results
File Size Used Unused Type DBFileName
======================================
3550.19295.853254.34LogNextGen_Log
207.13176.9430.19DataNextGen_System_Data
4911.504505.19406.31DataNextGen_Core_Data_1
5235.694431.13804.56DataNextGen_Index_1
13904.519409.114495.40*** Total...

February 4, 2011 at 10:52 am

#1282591
RE: How do I shrink the size of backup file

How about you run it against ANY other db to see how it works?

February 4, 2011 at 10:44 am

#1282585
RE: How do I shrink the size of backup file

Go read the articles and then come back if you have questions.

February 4, 2011 at 10:20 am

#1282573
RE: How do I shrink the size of backup file

So I have 20K tables and I can do it.
You need to get the data for each table and then order by rowcount and / or size to see what...

February 4, 2011 at 9:30 am

#1282544
RE: How do I shrink the size of backup file

Well yes and know. The log can grow during the delete. Let's say you delete a table with 10 GB of data pages, then the log will grow...

February 4, 2011 at 8:41 am

#1282515
RE: How do I shrink the size of backup file

mw112009 (2/4/2011)
3.) Can you please explain why you need to switch recovery modes ( What is the advantage )
The transactions don't need to be log in most dev environements... save...

February 4, 2011 at 8:27 am

#1282506
RE: How do I shrink the size of backup file

rebuilding the indexes is a maybe here... if you only keep 10 clients worth of data, you might not need to with so little selectivity.

February 4, 2011 at 8:14 am

#1282497
RE: How do I shrink the size of backup file

checkpoint is a command, look it up in books online.
to shrink the whole db :
USE [PRODDB_restored]
GO
DBCC SHRINKDATABASE(N'PRODDB_restored')
GO

February 4, 2011 at 8:12 am

#1282496
RE: How do I shrink the size of backup file

If you have active transactions in the system you won't be able to shrink the log, hence you need to back the tlog to allow the shrink (especially after a...

February 4, 2011 at 6:49 am

#1282422

Viewing 15 posts - 7,186 through 7,200 (of 18,923 total)