Search Results

Search found 30858 results on 1235 pages for 'database tuning'.

Page 366/1235 | < Previous Page | 362 363 364 365 366 367 368 369 370 371 372 373  | Next Page >

• how to get data from a datagridview and insert into database without using databinding?

  - by KATy

  hi guys i ve a datagrid and wen a button s clicked i want the values from the datadrid to the database.. without databind to dataset/datatable.. thanx in advance

  Read the article

• Average time from database list in C# with ASP MVC?

  - by Jacob Huggart

  I have a list of times that I have acquired from a sql database and I need to find the average time. I tried just doing list.average() and list.sum(), but neither of those work with timespan lists. What do you all suggest? btw, time is returned in a hh:mm:ss format.

  Read the article

• How to performance test a Rails application without rebuilding the test database?

  - by Cheng

  I would like to do some performance testing of a Rails app. I want to test the app with real world data, which is 100 MB in size. The problem is, Rails' test environment always rebuilds the database from fixtures, which always overwrites the real world data. So how should I do the performance test?

  Read the article

• word macro to save a selected range into database.

  - by Thunder

  Is there a way in word to save a selected portion into the database as range object.So that we can later retrieve it . It is required to generate a report in word ,the section needs to be repeated many times. I have searched net for quite some time but not much material is found. thanks.

  Read the article

• Slick: why would I save "Unit" to my database?

  - by alapeno

  I'm new to Scala and Slick and was surprised by something in the Slick documentation: The following primitive types are supported out of the box for JDBC-based databases in JdbcProfile ... Unit ... I don't get why this list contains Unit. From my understanding, Unit is similar to Java's void, something I neither can save to nor receive from my database. What is the intention behind it? edit: you can find it here.

  Read the article

• How can I plot graphs with MS Chart controls using data from the database?

  - by Allan

  I need a sample code on how I can plot a graph in a C# application using the MS Chart add on in Visual Studio 2008 using linq to sql to collect the data from the database?

  Read the article

• how to import the excel file to sql database using vb.net?

  - by subhashiniskmr

  I have a more data in excel file .so i have to import it into sql database using vb.net.can anyone send the source code?

  Read the article

• In a web farm environment, should we base the system date/time to the web servers or the database se

  - by leypascua

  Assuming there are a number of load-balanced web servers in a web farm, is it safe to use DateTime.Now in the application code for getting the system date/time or should we leave this responsibility to the database server? Would there be a chance that machine date/time settings on all servers in the webfarm are out of sync? If date/time will be the responsible of the DBMS, how will this strategy work if we have load-balanced replicated DBs?

  Read the article

• PHP: How do you safeguard application/server/database from your employees?

  - by Patrick

  What do you guys do (system/framework wise) to safeguard things like 1) employees writing malicious code to destroy your server 2) employees reading all your database sensitive information 3) generally programmers that have access to your back-end and potential damages that they can do. Is there any PHP scripts that guards against these, etc.?

  Read the article

• Excel macro to change external data query connections - e.g. point from one database to another

  - by Rory

  I'm looking for a macro/vbs to update all the external data query connections to point at a different server or database. This is a pain to do manually and in versions of Excel before 2007 it sometimes seems impossible to do manually. Anyone have a sample? I see there are different types of connections 'OLEDB' and 'ODBC', so I guess I need to deal with different formats of connection strings?

  Read the article

• Is there any MS SQL database designer software like MySQL workbench?

  - by newbie

  I need to design database for MS SQL Server, is there any MySQL workbench like software for that? I have access to MSDN, so it can also be commercial product that can be found form MSDN.

  Read the article

• Where does Drupal store user permissions in the database?

  - by Ryan Nelson

  Does anyone know where Drupal stores, in the Database, the role of a user? It's not in the users table, and I can't seem to find it. I can find where it defines the role, defines the role's permissions, but I can't find where it defines what Role a certain User is. Anyone know? Thanks!

  Read the article

• How can i learn Table Name in database an column name?

  - by Phsika

  How can i learn table Name in database an how can i learn any Table's Column name? SELECT Col.COLUMN_NAME, Col.DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS AS Col LEFT OUTER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS Usg ON Col.TABLE_NAME = Usg.TABLE_NAME AND Col.COLUMN_NAME = Usg.COLUMN_NAME LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS Con ON Usg.CONSTRAINT_NAME = Con.CONSTRAINT_NAME WHERE Col.TABLE_NAME = 'Addresses_Temp' AND Con.Constraint_TYPE = 'PRIMARY KEY' But it returns to me empty data:(

  Read the article

• i have two tables in my sql database of 1 million records, is there a way to find out the non matchi

  - by sharma

  i have two large tables in a database. table 1 with 2 fields rank,name and table2 with 2 fields rank,name. both are of 1 million records. can you write php sql code to fetch those records which exists in table2 but does not exist in table1.

  Read the article

• problem to Get Date, month Year separately From database in Php File ?

  - by aamir Fayyaz

  i want to separate date, month, time, hour, min ,sec getting from database, for count down timer, in data base stored date is 2010/10/10: me using this code : $m=date('m',$row['Date']); $d=date('d',$row['Date']); output is month=31 date = 12....

  Read the article

• Using serializable in hibernate what underlying database types do i use.

  - by joe90

  I need to use a serializable type in hibernate (to store a Subject (security)) All this works fine. I just need to know what the underlying database types are for the following databases: MSSQL - I used 'image' db2 - postgre - mysql - Thanks..

  Read the article

• How can I get all the database names in a sql server instance using tsql?

  - by Yousui

  Hi guys, How can I get all the database names in a sql server instance using tsql? Great thanks.

  Read the article

• Can php listen for a mysql database change or update? ...thinking real-time, live search here

  - by Derrick

  Im trying to think of the best way to handle real time search for a website. The only solution I can come up with is to keep checking the server every few seconds for something new in the database, but that does not seem very practical to me.

  Read the article

• How can I force NHibernate to hit the database when querying for an entity?

  - by Chris Holmes

  I have a situation where I need NHibernate to ignore its caches and just hit the database because the data has changed (another user on another computer has changed the data). How is this possible? So far I have had no luck. Get, Load, Linq query, doesn't matter. NHibernate is not getting the most recent data.

  Read the article

• In python, is there a simple way to connect to a mysql database that doesn't require root access?

  - by Matthew

  I'm writing a script to parse some text files, and insert the data that they contain into a mysql database. I don't have root access on the server that this script will run on. I've been looking at mysql-python, but it requires a bunch of dependencies that I don't have available. Is there a simpler way to do this?

  Read the article

• How to keep backup of our database in MySql.

  - by Sanjeev

  I want to keep backup of my database and import it into different System? and how to make .dmp or store file in MySql?

  Read the article

• Is it possible to get Java fmt messages bundle from database ?

  - by newbie

  I nedd to localize application and now files are loaded from text files. Is it possible to change source to database? This is how localized messages are now loaded: <!-- Application Message Bundle --> <bean id="messageSource" class="org.springframework.context.support.ReloadableResourceBundleMessageSource"> <property name="basename" value="/WEB-INF/messages/messages" /> <property name="cacheSeconds" value="0" /> </bean>

  Read the article

• What is the most efficient way to populate class attributes with a row from a database query?

  - by ensnare

  Looking to have a database query set all the instance variables in a class: Example: def populate(self, if): #Perform mysql query self._name = row['name'] self._email = row['email'] ... What's the fastest way to do this? Or is this not recommended (with a better approach)? Thanks.

  Read the article

• SQL select from data in query where this data is not already in the database?

  - by Michael

  I want to check my database for records that I already have recorded before making a webservice call. Here is what I imagine the query to look like, I just can't seem to figure out the syntax. SELECT FROM (1,2,3,4) WHERE id NOT IN table.id Is there a way to do this? What is a query like this called?

  Read the article

• Is it a good idea to Strtolower the username then store it in database?

  - by Axel

  Hi, In a php/mysql application where people can registre, is it a good idea to strtolower the username then store in the database in order to not have problems in the future? because people are using DiFfeReNt cases and i'm afraid that will make conflict in some queries. Thanks

  Read the article

< Previous Page | 362 363 364 365 366 367 368 369 370 371 372 373  | Next Page >