|
On the app I wrote for working with large datasets that can take over an hour to process certain fetch events, I have set my connection timeout to 5 seconds, and the command timeout to 0 (ie never timeout). works a treat.
|
|
|
|
|
Sure but that has nothing to do with the network 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thats why you confused me with this;
Mycroft Holmes wrote: If he is running a long stored proc then the timeout is relevant on the connection
The long running should be on the command, not the connection, or you should have said irrelevant on the connection.
Anyway, doesn't matter, we'll leave it there, I need a cuppa...... 
|
|
|
|
|
Mycroft Holmes wrote: Why would the network have anything to do with the connection timeout
requirements?
What other enterprise constraint would require changing it?
|
|
|
|
|
You seem to have taken a severe left turn, the OP was asking about how to change the connection timeout and you are now pursuing enterprise level network information. The guy may be working on a single user, personal application he is learning on (considering it is VB this is even more likely) and needs to cope with a long running stored procedure.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: and needs to cope with a long running stored procedure.
And changing the connection timeout is going to impact that?
|
|
|
|
|
Is it possible to change the tablespace for new (system-generated) partitions in a Range partitioned table after the table has been created? Thank you.
|
|
|
|
|
Hi,
Good morning. Would you please shed some light on the question I have on partitioning a table? I have a table with a size of 1.2 GB with 3.7 million rows. My question is whether it is a candidate for partitioning it? I thank you in advance for your help. Have a nice day.
Regards.
|
|
|
|
|
What do you mean by partitioning a table? Filtering,sorting?
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Partitioning. Comes in horizontal and vertical flavors; the act of splitting a table over multiple files.
Bastard Programmer from Hell 
|
|
|
|
|
|
|
countmein wrote: My question is whether it is a candidate for partitioning it?
Yes, it is.
Bastard Programmer from Hell
|
|
|
|
|
|
Do you have an obvious partitioning column?
|
|
|
|
|
Thank you for your replies. Yes, I do have a column(primary key) that starts from 1 and automatically generated by adding 1.
|
|
|
|
|
That's not really the best partitioning column.
What you want is to partition the table so that queries is only fetching or inserting data to and from one partition at a time, if possible.
For example, If you want to partition a sales table, the date column would normally be a good choice. Most updates, inserts and queries would be done on the current year partition.
|
|
|
|
|
I want to use Backgroundworker, Progressbar and Linq
Please, can i get some reference
I've alread written Database backup using Linq.How can i user backgroundworker?
|
|
|
|
|
|
wow..this is a big list..kudos to you Pravin.. 
|
|
|
|
|
If OP had used Google, he would have got more than this.....:lol
anyways thanks Prasad.....
I quit being afraid when my first venture failed and the sky didn't fall down.
|
|
|
|
|
Hi !
I need to track changes in the MS SQL 2008 DB, where the user works with the most updated data through views. One of my tasks is to show to the user two data chunks (before month and current) with highlighted changes.
CDC evidently works on the table basis. So my question: are there any tools/tutorials/walkthoughs that may help me recreate the view record and syncronize LSNs for different tables. In other words - represent the view record for certain point in time.
Thanks in advance.
Regards,
Gennady
My English is permanently under construction. Be patient !!
|
|
|
|
|
I have the following table structure:
Company:
Id (Int),
Name (VarChar)
Group:
Id (Int),
Name (VarChar)
Division:
Id (Int),
GroupId (Int) FK,
Name
Company_Group:
CompanyId (Int) FK,
GroupId (Int) FK
Team:
Id (Int),
DivisionId (Int) FK,
Name (VarChar)
I am trying to retrieve the Team Id and Name according to the CompanyId and DivisionId supplied.
Note that it is entirely possible that a team may belong to a division in multiple Company's.
I have tried various things but seem to get always get unwanted Teams in the results.
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
try this
select t.id,t.name,d.name,g.name,c.*
from team t
inner join division d on d.id = t.divisionid
inner join [group] g on g.id = d.groupid
inner join Company_Group cg on cg.groupid = g.id
inner join company c on c.id = cg.companyid
Hope it will help you
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Sorry Blu_Boy, not quite the expected results. I may not have explained correctly,
I want to get only the Teams from the supplied Company (@CompanyId) and where the supplied DivisionId (and thus referenced GroupId) maps to the GroupId in Company_Group table.
This is where I'm stuck. This really should be super easy, but I'm not seeing it tonight.
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
