Database

13-Sep-11 4:38

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.

Blue_Boy13-Sep-11 5:59

13-Sep-11 5:59

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.

Eddy Vluggen13-Sep-11 6:51

Eddy Vluggen

13-Sep-11 6:51

Partitioning. Comes in horizontal and vertical flavors; the act of splitting a table over multiple files.

Bastard Programmer from Hell Suspicious | :suss:

David Mujica13-Sep-11 6:12

David Mujica

13-Sep-11 6:12

Read this article from Microsoft ...

http://technet.microsoft.com/en-us/library/dd578580(SQL.100).aspx[^]

countmein15-Sep-11 7:23

15-Sep-11 7:23

Thank you for your help.

Eddy Vluggen13-Sep-11 6:52

Eddy Vluggen

13-Sep-11 6:52

countmein wrote:
My question is whether it is a candidate for partitioning it?

Yes, it is.

Bastard Programmer from Hell Suspicious | :suss:

countmein15-Sep-11 7:23

15-Sep-11 7:23

Thank you for your help.

List of common misconceptions

Jörgen Andersson13-Sep-11 9:15

Jörgen Andersson

13-Sep-11 9:15

Do you have an obvious partitioning column?

countmein15-Sep-11 7:22

15-Sep-11 7:22

Thank you for your replies. Yes, I do have a column(primary key) that starts from 1 and automatically generated by adding 1.

List of common misconceptions

Jörgen Andersson15-Sep-11 8:46

Jörgen Andersson

15-Sep-11 8:46

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.

How To Write Database Backup

black0712-Sep-11 20:05

black07

12-Sep-11 20:05

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?

Re: How To Write Database Backup

Pravin Patil, Mumbai12-Sep-11 21:05

Pravin Patil, Mumbai

12-Sep-11 21:05

Backgroundworker :
1. BackgroundWorker Threads and Supporting Cancel[^]
2. Generic Background Worker[^]
3. Basic Backgroundworker[^]
4. Asynchronous Invocation Using BackgroundWorker[^]
5. BackgroundWorker.ReportProgres...[^]

Progressbar :
1. Progress Bar Best Practices[^]
2. Advanced Progressbar[^]
3. Percent Progress Bar[^]
4. ProgressBar with Percentage[^]
5. Color ProgressBar[^]

Linq :
1. http://msdn.microsoft.com/en-us/netframework/aa904594[^]
2. http://msdn.microsoft.com/en-us/library/bb308959.aspx[^]
3. http://msdn.microsoft.com/en-us/vcsharp/aa336746[^]
4. http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx[^]
5. http://www.hookedonlinq.com/[^]

Hope this helps.
All the best.

I quit being afraid when my first venture failed and the sky didn't fall down.

Re: How To Write Database Backup

Pradeep Shukla17-Sep-11 15:19

Pradeep Shukla

17-Sep-11 15:19

wow..this is a big list..kudos to you Pravin.. Smile | :)

Re: How To Write Database Backup

Pravin Patil, Mumbai23-Sep-11 7:15

Pravin Patil, Mumbai

23-Sep-11 7:15

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.

CDC and views

Gennady Oster12-Sep-11 1:57

Gennady Oster

12-Sep-11 1:57

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 !!

This should be simple

Andy_L_J11-Sep-11 23:19

Andy_L_J

11-Sep-11 23:19

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

Blue_Boy11-Sep-11 23:44

11-Sep-11 23:44

try this

SQL

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.

Andy_L_J12-Sep-11 0:37

Andy_L_J

12-Sep-11 0:37

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

Blue_Boy12-Sep-11 0:48

12-Sep-11 0:48

I may be wrong again with query.

SQL

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.

Andy_L_J12-Sep-11 1:31

Andy_L_J

12-Sep-11 1:31

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

Blue_Boy12-Sep-11 1:35