|
Do you mean that SQL sessions are blocking on other user's sessions because of locking?
This can be detected using the "sp_who2" stored procedure. The normal ways of reducing lock contention are:- Keep your transactions short.
- Check your "isolation level". Some frameworks use the "serializable" isolation - which severely impacts concurrency.
- For reports, consider using "read uncommitted" isolation.
- If your transactions access multiple tables then try to update tables in the same sequence.
Hope that helps. This artical[^] may help.
Regards
Andy
|
|
|
|
|
|
ma se wrote: AND tblProduct.Status = 1
should be changed to
WHERE tblProduct.Status = 1
SG
|
|
|
|
|
Hi
ma se wrote: AND tblProduct.Status = 1
Remove it and add it in where clause.
Harini
|
|
|
|
|
Don't delete the original question - It is rude and does not help people that may have a similar problem and are searching the forum.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton
My website
|
|
|
|
|
hi ,
i want to make table hints for fastfirstrow what is the syntax for the same
|
|
|
|
|
select x, y from a
order by x
option (fastfirstrow)
Note that the "option(fast n)" is preferred under SQL2000 (where "n" is the number of rows).
|
|
|
|
|
Hi I am new to database design and I would like your opinions on my database. I am creating a database to hold website member info. In my register page I ask users who wish to become members to supply the following infos.
First Name, Last Name, Profession, Address, City, State, Zip, Phone Number, Email, User Name, Password
From the info above, I've created a database called Members, a table called Users, and another table called ContactInfo.
Users ContactInfo
_______________ ___________________
|UserID | |Email |
_______________ ___________________
|Email | |Phone |
_______________ ___________________
|FirstName | |Address |
_______________ ___________________
|LastName | |City |
_______________ ___________________
|UserName | |State |
_______________ ___________________
|Password | |Zip |
_______________ ___________________
Do you see any problem with the above database? Please point out any problems that you see. Thank you in advance for your help.
-- modified at 3:43 Monday 11th June, 2007
|
|
|
|
|
The two tables aren't linked to each other. How will you retrieve user's contact info given his/her userID?
|
|
|
|
|
Hi
1. Why two tables?
2. Are you storing more than 1 record in ContactInfo table for a particular user?
3. If you are storing more than 1 contact Info, link should be maintained between those two tables. Users table should have one more column i.e., UserID to maintain unique row. This column should be added to ContactInfo Table so that you can retrieve contact details based on UserID.
See definitions of Normalization for more information. There are three normal forms in database design.
For best example, have a look at Orders and Order Details tables of Northwind database and check the common column between these two table.
Harini
|
|
|
|
|
hi,
Database is correct use userid for relation more than email id.
it is preferable in database.
k.ravi sankar
|
|
|
|
|
Hi there,
I have a stock table and a barcode table. A stock can have many barcode records and a barcode belongs to only one stock.
How can I query the database, so as it returns me those stock which have more than one barcode?
Thanks for helping,
David
|
|
|
|
|
select StockCode, count(*) BarcodeCount
from BarCode
group by StockCode
having count(*) > 1
|
|
|
|
|
Hi,
I use mysql on my project and I can connect to mysql with my IP,this is a good thing.
But the problem is that I can't create a user.
My sintax is:
cmd1.CommandText = "GRANT ALL PRIVILEGES ON test .* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;"<br />
cmd1.ExecuteNonQuery()<br />
<br />
cmd1.CommandText = "flush privileges;"<br />
cmd1.ExecuteNonQuery()<br />
The problem is that when I connect to mysql with localhost this command works and when I connect with my IP it doesn't work.
Thank .
|
|
|
|
|
The error doesn't appear to be anything to do with the above command as it works with localhost.
WhiteGirl23 wrote: I use mysql on my project and I can connect to mysql with my IP,this is a good thing.
Can you execute any command at all when using your IP? e.g A simple select statement.
WhiteGirl23 wrote: it doesn't work.
What does it do when it doesn't work? Does it throw any exception?
There are 10 types of people in the world, those who understand binary and those who dont.
|
|
|
|
|
What user are you connecting to the DB with?
|
|
|
|
|
Now it works.
I found a sql command for creating user which works with IP and localhost.
Thanks
|
|
|
|
|
Hi Friends I have a problems
I have a table Employee
two fields Name, Age
Name Datatype is varchar()
Age Datatype is Int()
the table look likes this
Name.........Age
Ram.............23
Steve............22
when i swap this two fields using this query"update Employee set Age = Ename,Ename=Age;'
then the error occured
error is "Syntax error converting the varchar value 'Ram' to a column of data type int."
If i changed the datatype of Age is "Int" to "Varchar" then the query runs.
My question is if i don't changed the datatype then how i swap the two fields
Plz help me....
|
|
|
|
|
It seems to me you don't understand the difference between a varchar column versus an int column. A varchar column is used to store text while an int column is used to store numbers.
You cannot do what you are trying do, becuase you cannot put Text into an Integer column, which is why you get the error message 'Syntax error converting the varchar value 'Ram' to a column of data type int'.
Further, I don't see any reason why you would ever want to do this, as it just doesn't make any sense.
Mike Lasseter
|
|
|
|
|
"cast age as varchar" convert data type for select caluse,dot know update
|
|
|
|
|
how about 'Cast age as varchar', not sure
|
|
|
|
|
hi want to find the out puts
There are 2 fields namely name,mark
The following are the values in the field
name....mark
A...........10
A...........10
B...........20
C...........15
C............5
my output should be in the form :-----
name...........mark
A................20
B................20
C................10
Please write a query for this ???
|
|
|
|
|
Parameswar Mal wrote: Please write a query for this ???
Please specify the route between the input and output. It is not obvious.
A seems to add the marks
C substracts one from the other. What are the rules for this? Given that a SQL works on SET based operations with no intrinsic order how do you work out which number should be subtracted from the other.
I don't know what B does as there is only one of them.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton
My website
|
|
|
|
|
Are you trying to find the average or sum?
If C's mark is wrong, then
select A,sum(mark) from tblName group by name order by name
If A's mark is wrong, then
select A,avg(mark) from tblName group by name order by name
Regards,
Arun Kumar.A
|
|
|
|
|
Hi there,
In SQL Server, is there anyway to check other open connections (who else currently connected to the database)?
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
