No announcements
Found 3961942 threads
-
0 VotesHOW TO CREATE TRIGGER ON DATABASE
you can create trigger using CREATE TRIGGER statement you have to first decide what type of trigger you want to ...Answered | 5 Replies | 908 Views | Created by PRIYASAHA - Saturday, February 21, 2015 3:58 AM | Last reply by pituach - Saturday, February 21, 2015 10:28 AM
-
0 Votes
how to use the database generated script file
Please help me about how to create database using the generated script of other database??Answered | 4 Replies | 922 Views | Created by DvinceCode - Saturday, April 9, 2016 10:05 AM | Last reply by Visakh16 - Sunday, April 10, 2016 6:27 AM -
0 Votes
How to check space on Oracle Database server + How to generate CREATE script for Indexes and Triggers using c# code
User-1209179946 posted Hello, I have to automate one database process in .Net web applicaiton which uses Oracle 11g Database ...Answered | 2 Replies | 35 Views | Created by Anonymous - Wednesday, January 27, 2010 4:19 PM | Last reply by Anonymous - Sunday, December 5, 2010 6:18 PM -
2 Votes
How much HDD space and an index possibly use?
http://www.mssqltips.com/sqlservertip/1225/how-to-determine-sql-server-database-transaction-log-usage/ Thanks ...Answered | 8 Replies | 875 Views | Created by ryguy72 - Monday, December 8, 2014 8:37 PM | Last reply by pituach - Friday, December 12, 2014 4:23 PM -
0 Votes
generate DROP&CREATE INDEX scripts for nonclustered indexes
Hi there, You can use the following query that will generate the DROP INDEX statement for all indexes inside ...Answered | 3 Replies | 10078 Views | Created by 9390877 - Monday, September 17, 2012 8:59 AM | Last reply by Basit Farooq - Monday, September 17, 2012 9:24 AM -
2 Votes
Oracle database 11G to C# WPF application
In my opinion, the client should be supplying you with a test database with everything already setup so that you can ...Answered | 6 Replies | 1651 Views | Created by Markus Freitag - Tuesday, January 29, 2019 5:27 PM | Last reply by Markus Freitag - Saturday, February 2, 2019 11:41 AM -
1 Votes
Needed transaction log space to create a clustered index.
How much transaction log space is needed to create the clustered index?Answered | 4 Replies | 1719 Views | Created by hcv01 - Tuesday, March 31, 2015 2:19 PM | Last reply by Erland Sommarskog - Tuesday, March 31, 2015 9:52 PM -
2 Votes
Space wars : Space used by indexes vs space used by actual data
So, I shrunk the database..Answered | 9 Replies | 1747 Views | Created by Avaneesh Bajoria - Wednesday, April 10, 2013 7:20 AM | Last reply by Avaneesh Bajoria - Wednesday, April 17, 2013 12:25 PM -
2 Votes
How indexing works in oracle DB based on given scenario?
I suggest you read ...Answered | 2 Replies | 513 Views | Created by Rajneesh4U - Thursday, May 7, 2020 9:31 AM | Last reply by Tom Phillips - Thursday, May 7, 2020 1:12 PM -
1 Votes
C# checking for spaces
You can use String.IsNullOrWhiteSpace method to perform check that sveroa has provided to make you code more readable.Answered | 4 Replies | 1535 Views | Created by midnight_car - Saturday, October 6, 2012 6:42 PM | Last reply by Alireza Dehqani - Saturday, October 6, 2012 7:08 PM -
0 Votes
create database from file script in trigger
Triggers are high-maintenance database objects.Answered | 1 Replies | 5365 Views | Created by jacky the rookie - Wednesday, March 17, 2010 2:28 PM | Last reply by Kalman Toth - Wednesday, March 17, 2010 4:27 PM -
1 Votes
How to Properly Index a Database
Again, from a general database design a cell is where data is stored. the implimentation that Microsoft uses is a recordset is a row of data with fields, but this is ...Answered | 15 Replies | 3903 Views | Created by Matt Demakos - Sunday, July 10, 2011 1:39 PM | Last reply by Tony Toews 0 - Sunday, July 10, 2011 10:29 PM -
0 Votes
Compile (syntax check) triggers
You can migrate the objects and the data, do testing, change code and finally migrate the data again from the Oracle system.Answered | 9 Replies | 3431 Views | Created by AU-Rabbit - Saturday, January 5, 2013 1:21 AM | Last reply by sytahmtcbn - Tuesday, March 12, 2013 4:06 PM -
0 Votes
How to use script file of database ?
Option 3 : Create the scripts and move the data to flat files .Uninstall SQL 2008 .Install SQL 2005 .Run those scripts .You will see the new ...Answered | 3 Replies | 3098 Views | Created by Faiza Iqbal Butt - Friday, December 30, 2011 12:57 PM | Last reply by Abhay_78 - Friday, December 30, 2011 4:42 PM -
1 Votes
How much space is required to rebuild all my indexes in my database?
>>I prefer not to use the Mainteance plan instead of that you can go through and you can implement the Index Optimization article here ...Answered | 6 Replies | 13841 Views | Created by Manu_vmr - Wednesday, July 11, 2012 2:56 AM | Last reply by VidhyaSagar - Wednesday, July 11, 2012 10:53 AM -
0 Votes
How to check whether SQL server Instance has enough space to create a New Database
Then you would just use that stored procedure to determine weather the database was created.Answered | 4 Replies | 1904 Views | Created by Rakpa88 - Wednesday, September 6, 2017 4:09 AM | Last reply by MDeero - Saturday, September 9, 2017 9:39 AM -
0 Votes
how to generate a script from one database to another through code in vb.net
Hi Chris, This code is working fine but it is not giving me the header of the stored procedure like Create Procedure Procedure_name.Answered | 5 Replies | 1830 Views | Created by Sonal M Jain - Friday, January 25, 2013 3:01 PM | Last reply by Sonal M Jain - Monday, January 28, 2013 2:20 PM -
1 Votes
How to backup a single database table or some tables by C# code
Do you just want to back up the data or the entire table including the DDL (indexes, triggers, etc).Answered | 4 Replies | 5183 Views | Created by Lythen - Monday, August 18, 2014 9:39 AM | Last reply by PradyothanaDP - Monday, August 18, 2014 10:40 AM -
1 Votes
How to use a database Script?
The version numbers (https://en.wikipedia.org/wiki/History_of_Microsoft_SQL_Server) indicate that the database was made in SQL Server 2016, but it cannot be used in SQL ...Answered | 2 Replies | 390 Views | Created by WinnerM - Monday, May 8, 2017 5:06 PM | Last reply by Sara Liu - Tuesday, May 9, 2017 3:10 AM -
2 Votes
how can using oracle dataBase to create a external List
check this http://www.lightningtools.com/blog/archive/2010/12/28/sharepoint-2010-secure-store-service-and-oracle.aspx is about SharePoint 2010 Secure Store ...Answered | 3 Replies | 10223 Views | Created by Engr.Mohamad Al-Dahshoury - Saturday, April 2, 2011 7:34 AM | Last reply by Mai Omar Desouki - Saturday, April 2, 2011 2:55 PM - Items 1 to 20 of 3961942 Next ›
No announcements
