ASP.NET Tips: Working with large SQL tables

DotNetKicks.com — Wed, 26 Mar 2008 17:11:31 GMT

You've been kicked (a good thing) - Trackback from DotNetKicks.com

re: ASP.NET Tips: Working with large SQL tables

Francois Ward — Wed, 26 Mar 2008 22:34:35 GMT

I'm not into the whole SP vs dynamic SQL thing, so don't take this as starting a debate :)

That said... parameterized queries are also immune to SQL injection, and SQL Server also cache their query plans (which is the only "compilation" it does with stored procedures, too). There are finer details, but thats the general idea. Many of the other RDBMS work that way, too.

So while there's a million (good) reasons to use SPs, these really aren't part of that equation :)

re: ASP.NET Tips: Working with large SQL tables

Tom — Wed, 26 Mar 2008 23:50:24 GMT

Those are very good points. I was trying to keep it simple but yes, those are very good things to point out.

re: ASP.NET Tips: Working with large SQL tables

Sajid Wahab — Thu, 27 Mar 2008 10:42:07 GMT

I have a problem with SQL Server,,,

there are round about 7 hundred thousand records,, and I use multiple joins in select queries....

after 3, 4 transactions it prompt me with,,

Possible ErrorMsg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database 'tempdb'(ID:2) on page (1:781). Please contact technical support. Reference number 4.

can any body HELP me,,,.:(

re: ASP.NET Tips: Working with large SQL tables

Josh Coswell — Thu, 27 Mar 2008 12:25:20 GMT

Good insight.

I will look for some more exmples of this kind in Large Data in SQL

Is'nt large data from the database query independent of whether we use SP or NOT?

Josh

http://riverasp.net

re: ASP.NET Tips: Working with large SQL tables

Suprotim — Thu, 27 Mar 2008 13:26:03 GMT

The TOP clause in SQL Server 2005 has been enhanced. You can now specify an expression as the number definition in the TOP clause. This makes your TOP clause dynamic as you can pass the number value in a variable and use that variable in the TOP clause of your T-Sql query or your stored proc

Sample Usage:

DECLARE @TopVar AS int

SET @TopVar = 20

SELECT TOP(@TopVar)

CustomerID,CompanyName, ContactName

FROM Northwind.dbo.Customers