|
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
|
|
|
|
|
I may be wrong again with query.
select c.company,g.name,d.name,t.name
from Company_Group cg
inner join company c on c.id=cg.companyid
inner join [group] g on g.id=cg.groupid
inner join division d on d.id=g.id and d.groupid = cg.groupid
inner join team t on t.id = d.id
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Thanks for your time Blue_Boy, I have found that the design is flawed and there will have to be a work-around outside of the database.
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
Andy_L_J wrote: hanks for your time Blue_Boy,
My pleasure to help others
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi
I am busy working on a windows application to log working times of staff. The application is being developed using C# with SQL Server 2008 as the backend.
I have a [NetTime] column (Time data type) in my table in the database. I get the TimeSpan value by subtracting the official working hours and the actual working hours. This TimeSpan value can be positive or negative. I would like to store this value in the [NetTime] column, but the Time data type does not accept negative values.
What is the usual way of dealing with this problem? I will need to do calculations with the values in this column, for example to calculate the net or total time a staff member worked overtime or not.
Thank you.
Kobus
|
|
|
|