Resource usage of SQL Server 2005 Generate Script
Hi, I am wondering how resource hungry the Generate Script for SQL Server 2005 is. We are planing to script out one of our production database on a production server that has over 1000 object to script, and wether this will have more affect on SQL performance during the scripting? Thanks.
View Answer
| Oct 13 2009 12:28 AM GMT
SQL Server 2005, SQL Server performance, SQL Server performance tuning
Hi, I am wondering how resource hungry the Generate Script for SQL Server 2005 is. We are planing to script out one of our production database on a production server that has over 1000 object to script, and wether this will have more affect on SQL performance during the scripting? Thanks.
View Answer
| Oct 13 2009 12:28 AM GMTSQL Server 2005, SQL Server performance, SQL Server performance tuning
230 pts.
Plans and Guidelines for a Web Application Project
Hello there fellow users, I have been entrusted with the task of designing and implementing a financial system for a charity foundation where I live. The charity foundation requires its work (addition and retrieval of records, for example) to be done online, using a web app. The app connects to a...
Hello there fellow users, I have been entrusted with the task of designing and implementing a financial system for a charity foundation where I live. The charity foundation requires its work (addition and retrieval of records, for example) to be done online, using a web app. The app connects to a...
Question about Crystal Reports
I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase's name is "Database.mdf" . Why i am not able to see it ? My...
I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase's name is "Database.mdf" . Why i am not able to see it ? My...
abt the server
is it possible to make my personal computer to act both as client and server for the purpous of doing project like php-mysql-apache and for deployinf j2ee also
is it possible to make my personal computer to act both as client and server for the purpous of doing project like php-mysql-apache and for deployinf j2ee also
How do you get Visual Basic 4 to play sound.wav files
Hi everone, I thought I saw this answer on this site earlier, but now can't find, at the time, I clicked the button e-mail myself, but now realized it didn't send me anything, here's my problem. I wrote a program using vb4, I also have vb 2005 but don't like the way it compiles, so I went back to...
Hi everone, I thought I saw this answer on this site earlier, but now can't find, at the time, I clicked the button e-mail myself, but now realized it didn't send me anything, here's my problem. I wrote a program using vb4, I also have vb 2005 but don't like the way it compiles, so I went back to...
To increase my knowledge abt web technologies like asp.net
hello sir, Currently I m geting involved in one project, actually it is not a project just doing it for myself or to increase my knowledge. the project is portofolio management sevice.In this you can get ur current market worth bot all ur invesment thru this s/w. I have collected some info., but I...
hello sir, Currently I m geting involved in one project, actually it is not a project just doing it for myself or to increase my knowledge. the project is portofolio management sevice.In this you can get ur current market worth bot all ur invesment thru this s/w. I have collected some info., but I...
ms sql query problem with a case statement
[strong]This code works: SELECT passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...
[strong]This code works: SELECT passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...
Convert and Expand Field through SQL/400
I am using the AS400 platform and a novice with SQL. I have a common field in multiple files - some files define the field as numeric and some alpha. My question: Is there a way in SQL to first convert the numeric field to alpha and then expand the alpha field adding two leading zeros? If this is...
I am using the AS400 platform and a novice with SQL. I have a common field in multiple files - some files define the field as numeric and some alpha. My question: Is there a way in SQL to first convert the numeric field to alpha and then expand the alpha field adding two leading zeros? If this is...
SQL EXPLAIN
How do I interpret the EXPLAIN plan of a particular SQL which has "Bytes" and "Cost(CPU%)" columns?
How do I interpret the EXPLAIN plan of a particular SQL which has "Bytes" and "Cost(CPU%)" columns?
Replication Causes Client Application to Hang
I've got 25 Sites that are running an application that connects to MS SQL 2005, All the sites have their own copy of a database and have one similar database that holds information gathered from the different sites, now what is happening is that if a client registers at one institution and then...
I've got 25 Sites that are running an application that connects to MS SQL 2005, All the sites have their own copy of a database and have one similar database that holds information gathered from the different sites, now what is happening is that if a client registers at one institution and then...
Updating a View
I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated. The database name is: ABCD_Dbase The view that needs to be updated is: dbo.vGoLPgcfos Thanks in advance. ~DJ
I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated. The database name is: ABCD_Dbase The view that needs to be updated is: dbo.vGoLPgcfos Thanks in advance. ~DJ
Performance counters
Can anyone give my a good set of numbers to go by when I'm looking at my counters. I know everyones counters are different some but I would like to get an idea of what is good and what is bad regarding memory. If anyone could help it would be great. thank you JM Software/Hardware used: Hardware
Can anyone give my a good set of numbers to go by when I'm looking at my counters. I know everyones counters are different some but I would like to get an idea of what is good and what is bad regarding memory. If anyone could help it would be great. thank you JM Software/Hardware used: Hardware
Apache HTTP server for AS/400 and OS/400
I've looked for the download for Apache Tomcat Server HTTP for AS/400 and OS/400, but can only find versions for Windows, Unix and IS/2. Does anyone know the download location? Software/Hardware used: AS/400 94066-170-2290 and OS/400 V4R2
I've looked for the download for Apache Tomcat Server HTTP for AS/400 and OS/400, but can only find versions for Windows, Unix and IS/2. Does anyone know the download location? Software/Hardware used: AS/400 94066-170-2290 and OS/400 V4R2
connecting oracle forms to mysql
the problem is, its is connecting but there is a packet checksum failure... please help us out. thanks. by the way, my email is lance_arch_angel@yahoo.com Software/Hardware used: oracle forms 9i, mysql
the problem is, its is connecting but there is a packet checksum failure... please help us out. thanks. by the way, my email is lance_arch_angel@yahoo.com Software/Hardware used: oracle forms 9i, mysql
Soon you can redeem knowledge points for Amazon.com gift cards
Yes we are coming up knowledge points and will be announcing the ability to redeem all the points you have earned thru december this year for amazon.com gift cards. Next week we will be sending out an email with all the details but it should be fun to see who ends up asking and answering to beef up...
Yes we are coming up knowledge points and will be announcing the ability to redeem all the points you have earned thru december this year for amazon.com gift cards. Next week we will be sending out an email with all the details but it should be fun to see who ends up asking and answering to beef up...
Open source project management tools?
What open source project management tools you've found succesful for mid-sized businesses? Played with Open Atrium and some others, but wondering if there's something more mature, especially for tracking project completion. Software/Hardware used: Open Atrium
View Answer
| Oct 7 2009 4:16 PM GMT
Project Management Software, Open source applications, Open source software
What open source project management tools you've found succesful for mid-sized businesses? Played with Open Atrium and some others, but wondering if there's something more mature, especially for tracking project completion. Software/Hardware used: Open Atrium
View Answer
| Oct 7 2009 4:16 PM GMTProject Management Software, Open source applications, Open source software
How can I install multiple Lotus8.0 clients on same box
I have windows XP box. How can i have multiple Lotus 8.0 clients on same box. I do not see the option for installing Lotus client in multi user environment.
I have windows XP box. How can i have multiple Lotus 8.0 clients on same box. I do not see the option for installing Lotus client in multi user environment.
export crystal report to flat file in fixed length with headers and footers
Hi; I need to produce a flat file in fixed length format as output of Crystal Reports version 8.5. The issue I am having is that the file has a batch header and trailer record which must be placed in the header and footer sections of the report. I also have multiple subreports within the details...
Hi; I need to produce a flat file in fixed length format as output of Crystal Reports version 8.5. The issue I am having is that the file has a batch header and trailer record which must be placed in the header and footer sections of the report. I also have multiple subreports within the details...
.NET framework
Hi all, please what can I do to resolve this problem?? unhandled exception error has occured in your application .NET frame work, an attemt to compromise security. if click continue the application will attampt to continue and if u click quit the appln will quick. please what could have caused...
Hi all, please what can I do to resolve this problem?? unhandled exception error has occured in your application .NET frame work, an attemt to compromise security. if click continue the application will attampt to continue and if u click quit the appln will quick. please what could have caused...
