I have three tables tblPublication (PubID, PubName) tblMembers (MemberID, MemberEmail) tblPublicationMembers (PubID, MemberID) I want a list of all...
The table has about 4 million rows There is a clustered index on ipFROM and ipTO. Which would be faster: -------- Select * from tblIPData Where...
I have a question about connection pooling. We are running an ASP.NET site, and I have found a lot of information on connection pooling, like you...
I have a stored procedure that is executed on every web request that we get. On the web server, I get about 50 Requests a second. After looking into...
I have a series of counters in my Database that I need to increment. How bad of an idea is it to just: Update tblLog Set Counter = Counter + 1 A...
I have a simple query (Select * from tblTest) but it says that tblTest is an invalid object. But I can see it, edit it, and add data to it through...
I have a query that takes approximately 4 seconds to run in the query analyzer. Then when I put it in a stored procedure it takes 13 seconds... I...
Here's the deal. I have one table with names and ID's... UserTable: UserID, UserName Then I have a table of past selections, what I mean is that...
Separate names with a comma.
