Perfect. Thank You.
OK, I added the "where M.MemeberID = 10" to your query.
It only shows the Publications that it is associated with.
I also need the Pubs they aren't...
Well, I have two Publications, but 200 Members..
So your query listed like 300+ records.
I want only the publication and (IsAssociated) for a...
But how do I specify I certain MemberID..
Your query just gives me a huge list...I need both (2) Publications and the MemberID (IsAssociated)
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...
It did speed things up a little bit....but still not acceptable, I'll have to keep researching.
Thanks for the help.
There are only about 50 rows in the table.
YES, the same row is updated every time.
The table actually looks something like this:
ID (int, primary...
We will, but for this testing, the update command is the only one running.
I apologize, I got a little mixed up. There is an ID column that is the primary key and it has a clustered index.
Is there any way that I can find...
Yes, that is what I meant.
No it is not...just a regular Identity column that increments.
Yes, I have an identity column that is the primary key....the id field.
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
Do I have to run that sp for each table, or is there a way to change ownership for all tables in a database?
the owner is not dbo, it is actually the SQL User I assigned to Visio.
Do I have to change the ownership of the table?
I added the tables through Visio, then I did my select in Query Analyzer.
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...
Separate names with a comma.