Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2003
    Posts
    114

    Unanswered: SQL Server Limits

    Where can I find info on how much data SQL Server can handle? What is too big of a table in terms of records? When (in terms of table/db size)does processing from a web site using querys and joins begin to bog down?

    Thanks!

  2. #2
    Join Date
    Sep 2003
    Location
    Mumbai, India
    Posts
    36
    I have seen upto 15 tera Bytes without any problems. On the other hand I have seen one of just 6 GB but with ample problems. Both were being accessed by a web based application.

    The primary concern is the RAM, the tempdb size, your database configuration (spread across discs), how refined your SP's/queries are, et al. My observation has been that with good/well written queries and a good database setup, SQL Server works very fast from any sort of application.

  3. #3
    Join Date
    Apr 2003
    Posts
    114
    How does this query look?
    Code:
    sql = "SELECT pd.FirstName, pd.LastName, pd.Grade, td.TrngDate, td.TimeDay, td.Effort, td.UnitMeas, td.Partners, td.Comments "
    sql = sql & "FROM PartData pd INNER JOIN TrainingData td ON pd.PartID = td.PartID "
    sql = sql & "WHERE td.TrngDate >= '" & CDate(Session("beg_date")) & "' AND td.TrngDate <= '"& CDate(Session("end_date")) & "' AND TeamID = " 
    sql = sql & Session("teamid") & " ORDER BY td.TrngDate DESC"
    Set rs = conn.Execute(sql)

  4. #4
    Join Date
    Sep 2003
    Location
    Mumbai, India
    Posts
    36
    Can you please give me the T-SQL query out of this? I feel it can be refined using a derived table.

  5. #5
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Originally posted by suresh_m_kumar
    Can you please give me the T-SQL query out of this? I feel it can be refined using a derived table.
    Ya ... something like this :-
    Code:
    SELECT 
    	pd.FirstName, 
    	,pd.LastName, 
    	,pd.Grade, 
    	,td.TrngDate, 
    	,td.TimeDay, 
    	,td.Effort, 
    	,td.UnitMeas, 
    	,td.Partners, 
    	,td.Comments 
    FROM 
    	(
    		select
    			pd.FirstName 
    			,pd.LastName 
    			,pd.Grade 
    			,pd.partID 
    		from
    			PartData 
    	) pd INNER JOIN 
    	(
    		select 
    			td.TrngDate
    			, td.TimeDay
    			, td.Effort
    			, td.UnitMeas
    			, td.Partners
    			, td.Comments
    			,td.partID 
    		from 
    			TrainingData td 
    		WHERE 
    			TrngDate >= @begindate 
    			AND TrngDate <= @end_date 
    			AND TeamID = @teamid 	
    	) td
    	ON pd.PartID = td.PartID 
    ORDER BY td.TrngDate DESC
    I bet if you have a lot of data in the table TrainingData .. this query will definitely be an improvement. ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  6. #6
    Join Date
    Apr 2003
    Posts
    114
    Thanks!!!

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I've seen sql down many pitchers of margaritas...but if it's past .08 blood alchol level, things get dicey...and take the keys away....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    Sep 2003
    Location
    Mumbai, India
    Posts
    36
    Enigma is right.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •