Search Results

Search found 36788 results on 1472 pages for 'sql 2008'.

Page 667/1472 | < Previous Page | 663 664 665 666 667 668 669 670 671 672 673 674  | Next Page >

• Instruction for installing an environment with Qt and Qt integration with Visual Studio 2008.

  - by Narek

  I want to use Qt lib but I don't know how to install Visual Studio 2008+Qt+Qtintegration. I have read some forums, that step by step tell what to download, where to download from, and then what to do. But that was for old versions of mentiond products. I ask to Qt developers tell me the way to install these items on Windows. Any forum or site will be fine. Thanks.

  Read the article

• Why would SQL be very slow when doing updates?

  - by ooo

  Suddenly doing updates into a few tables have gotten 10 times slower than they used to be. What are some good recommendations to determine root cause and optimization? Could it be that indexing certain columns are causing updates to be slow? Any other recommendations? I guess more important than guesses would be help on the process of identifying the root cause or metrics around performance. Is there anything in Fluent NHibernate that you can use to help identify the root cause of performance issues?

  Read the article

• which sql query is more efficient: select count(*) or select ... where key>value?

  - by davka

  I need to periodically update a local cache with new additions to some DB table. The table rows contain an auto-increment sequential number (SN) field. The cache keeps this number too, so basically I just need to fetch all rows with SN larger than the highest I already have. SELECT * FROM table where SN > <max_cached_SN> However, the majority of the attempts will bring no data (I just need to make sure that I have an absolutely up-to-date local copy). So I wander if this will be more efficient: count = SELECT count(*) from table; if (count > <cache_size>) // fetch new rows as above I suppose that selecting by an indexed numeric field is quite efficient, so I wander whether using count has benefit. On the other hand, this test/update will be done quite frequently and by many clients, so there is a motivation to optimize it.

  Read the article

• Which method is best method for speed? in SQL Server, stored procedure

  - by AjmeraInfo

  I have select, insert, update and delete query. If I have to write all queries in the same stored procedure that is good for performance or should I write all queries in separate stored procedures?

  Read the article

• what is the use of view in sql server?

  - by Surya sasidhar

  hi, i have a doubt what is a view. where should we use and what is the use of view. is there any good reference for views. thank you

  Read the article

• Can I make a SQL Server 2005 Table Column accept only letters and numbers ?

  - by Space Cracker

  When we have a column that will store a username that will only accept letters and numbers we always do validation on this input field using javascript or even server validation from code .. but i want to know if is there any way that can allow me make this validation on the Table column itself even some one try to enter data from any place it don't accept and throw exception ?

  Read the article

• How to select the last record from MySQL table using SQl syntax.

  - by Vafello

  I have a table with several records. There is an id field. I would like to select the record with the most recent id (i.e. the ighest id). Any ideas?

  Read the article

• How do I remove database name from SQL Server generated script?

  - by bucha

  Anytime I use 'script table as' - 'Insert To' (or other command), the script generated automatically places the database name in the script. Such as: INSERT INTO [DatabaseName].[dbo].[tblToBeInserted] ... While not a huge problem to just delete it, it has slipped by a few times and the script breaks if run on a different server with a different database name but has the same schema. (Such as running on [DatabaseName.Test]) Is there an option I can change, or can I modify the output in any way to remove this?

  Read the article

• Copy huge tables data from one database to another in SQL Server.

  - by Narasimhulu

  I have two database say DB_A and DB_B. In DB_A database, table having huge data (few tables are having 2 to 10 million data). I want to move the all table data from DB_A to DB_B database. Please help me on writing stored procedures to move efficiently (fast) the data from one database to another.

  Read the article

• How to list all the branches in TFS 2008 programmatically ?

  - by Cleyton

  Hi, I would like to list all the branches in a TFS 2008 project. Currently, I'm trying to use this: VersionControlServer vcs = (VersionControlServer)tfs.GetService(typeof(VersionControlServer)); But, there's no method like "GetAllBranches()". Is it possible? Thanks!

  Read the article

• Is there a way to convert a Non-Clustered Index on a Primary Key to a Clustered one? (sql-server 200

  - by Lieven Cardoen

  With Management Studio I can't alter the index. Dropping it doesn't work because it's being used as a foreign key in a lot of other tables. Can I somehow alter it? Or how would you do this?

  Read the article

• How to install SDL library in Visual C++ 2008?

  Hey, How to install SDL library in VISUAL C++ 2008? I I am looking for a tutorial how to install, but I found nothing good :(( please help me?, sorry for bad english. Thanks :))

  Read the article

• SQL Reporting Services 2005 - Date field based on a user entered date?

  - by Pierce

  Hi, I have a report in report services 2005 that has two date fields. The problem is that if users run this for a large section of time it uses too much resources on our server. It is possible to only allow the end user to enter the start date and then the end date be auto populated/derived from this field (for example they enter the 1st of a month and this automatically change the end date to the last of a month.)

  Read the article

• Visual Studio 2008 or 2010 on 64-bit Machines?

  - by Zai

  I know many have asked the same question but I am still confused that does Visual studio 2008 or 2010 works with 64-bit computers? Here in this post the answer is that he can run Visual studio on Windows 64 bit OS? How?

  Read the article

• [Linq to sql] query result what should i use Count() or Any()...

  - by Pandiya Chendur

  I am checking login of a user by this repository method, public bool getLoginStatus(string emailId, string password) { var query = from r in taxidb.Registrations where (r.EmailId == emailId && r.Password==password) select r; if (query.Count() != 0) { return true; } return false; } I saw in one of the previous questions !query.Any() would be faster... Which should i use? Any suggestion....

  Read the article

• Is the available disk space stored in the sql server (2000) master database?

  - by cindi

  I want to be able to monitor the space left on drives that various databases sit on.

  Read the article

• Can you define values in a SQL statement that you can join/union, but are not stored in a table outs

  - by Mervyn

  I'm trying to create a query and need to join against something that I can define values in without creating a table. I'll attempt to describe what I'm trying to do: table1 is joined on field a with table2 (titles for FK in table 1) - Table1 has values outside of what exists in table2 - I want to add an additional 'table' to be unioned with table2 and then joined with table 1 Thanks

  Read the article

• SQL query to get lowest 2 values of a counted query selection (using db2)?

  - by jNoob

  Hi, Imagine I already have a query that returns the following: Col1 | Col2 ------------ A | 2 B | 3 C | 3 D | 4 E | 8 ... Say I used something like this: select Col1, count ( * ) as Col2 \ from ... where ... order by Col2 \ group by Col1 \ So now, all I want to select are (Col1, Col2) such that it returns the selections (a, b) and (c, d) where (b >= all (Col2)) and (d >= ((all (Col2)) - a)). So for the above example, it would return {(A, 2), (B, 3), (C, 3)}. How do I go about doing this? Any help would be highly appreciated. Thanks.

  Read the article

• PHP SQL, SELECT corresponding data from 3 tables at once?

  - by user346325

  I have 3 tables, 'u' 'd' 's' 'u' has userid divid 'd' has divid divname 's' has sname primaryuserid secondaryuserid Now what I'd like to do is display a table with rows of the following format userid, divname, sname Plus figure out a way to decipher whether userid is a primary or secondary for this sname table. I'm able to show userid and divname using a left join, but I don't know how I would add a third table? To make it trickier, there can be more than 1 snames for each userid, up to ~20. Is there a way to display 0-20 snames depending on the userid, seperated with commas?

  Read the article

• what could be a suitable datatype for storing telephone numbers in sql server 2005?

  - by Mac

  There are various datatypes from which i can choose for example varchar or bigint or decimal or money but which one could be the best in all respect.

  Read the article

• What is the best way to truncate a date in SQL Server?

  - by John Gietzen

  If I have a date value like 2010-03-01 17:34:12.018 What is the most efficient way to turn this into 2010-03-01 00:00:00.000?

  Read the article

• [Linq-To-Sql]How to return two values of different datatypes?

  - by Pandiya Chendur

  Here is my repository method which returns UserId , public IQueryable<int> getLoginStatus(string emailId, string password) { return (from r in taxidb.Registrations where (r.EmailId == emailId && r.Password == password) select r.UserId); } How to return UserName which is a string along with UserId... Any suggestion?

  Read the article

• How to check group for containing certain elements in SQL?

  - by noxvile

  I have a simple table: id num 1 7 1 5 1 4 2 5 2 4 2 7 3 4 3 7 How to select ids having num 5 as well as 7 and 4 For this example ids: 2, 3

  Read the article

• In sql server is there a way to uniquely identify a database?

  - by s_rajasekar

  Is there any way to uniquely identify a database. If we were to copy a database to another machine, this instance is assumed to be different. i checked on master tables, but could not identify any information that can identify this.

  Read the article

• SQL & PHP - Which is faster mysql_num_rows() or 'select count()'?

  - by Joel

  I'm just wondering which method is the most effective if I'm literally just wanting to get the number of rows in a table. $res = mysql_query("SELECT count(*) as `number` FROM `table1`"); $count = mysql_fetch_result($res,0,'number'); or $res = mysql_query("SELECT `ID` FROM `table1`"); $count = mysql_num_rows($res); Anyone done any decent testing on this?

  Read the article

< Previous Page | 663 664 665 666 667 668 669 670 671 672 673 674  | Next Page >