Forum Replies Created
Viewing 15 posts - 31 through 45 (of 59 total)
-
RE: Views (performance)
Thats right.
CREATE view t1t3
as
select t1.srno as T1SRNO,t3.srno as T3SRNO,t1.fname as T1FNAME, t3.fname as T3Fname, t1.lname as T1Lname,t3.lname as T3Lname
from t1 inner join t3 on t1.srno=t3.srno
CREATE view t1t3limit
as
select t1.srno as...
What I hear I forget, what I see I remember, what I do I understand -
RE: Views (performance)
The size is varchar(100).
I am omitting some columns, ofcourse.
Heres the picture
I have two tables
T1 and T3, having similar structures.
fname varchar(100)
lname varchar(100)
srno int (identity)
In query I am omitting column T1LNAME and...
What I hear I forget, what I see I remember, what I do I understand -
RE: Views (performance)
I dont have that info right now as I am not at my office, but the width (thickness) of a coulmn, how would it impact the query? Since they are...
What I hear I forget, what I see I remember, what I do I understand -
RE: Views (performance)
Its a development environment, hence I can afford the restarts.
Query Analyzer is opened on the server PC so network is...
What I hear I forget, what I see I remember, what I do I understand -
RE: Views (performance)
I executed these commands before I executed the queries.
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
And if they werent enough, I even stopped and restarted my dev server.
The execution plans are as..
View - V1
What I hear I forget, what I see I remember, what I do I understand -
RE: Views (performance)
OK I did some testing and here are my observations.
I created 2 tables each containing about 300000 records. I joined them in a view, didn’t use any where clause and...
What I hear I forget, what I see I remember, what I do I understand -
RE: Views (performance)
Thanks for replying Lee.
I gave it some more thought and I think a stored procedure with a flag as an input parameter which would determine which query to execute (a...
What I hear I forget, what I see I remember, what I do I understand -
RE: Question of the Day for 05 Sep 2005
Ditto.
What I hear I forget, what I see I remember, what I do I understand -
RE: Question of the Day for 05 Sep 2005
Both A and B are correct answers. I chose A, do I still get the points?
What I hear I forget, what I see I remember, what I do I understand -
RE: Concurrency Issues
In development environment usually, there is less load on the server (obviously), which is hosting the database hence the response time for the query is faster. But if the database...
What I hear I forget, what I see I remember, what I do I understand -
RE: Which is faster or better for performance ??
Table variables are NOT created in memory. They are created in temp DB. As a rule of thumb use table variables if you are "NOT DEALING" with hugh...
What I hear I forget, what I see I remember, what I do I understand -
RE: Microsoft ODBC Driver for DB2
Thanks for the info.
I could establish the connectivity using the IBM DB2 drivers
The problem was that the object owner for the schema table...
What I hear I forget, what I see I remember, what I do I understand -
RE: Execute multiple queries on a single connection simultaneously.
Can I specify the prefetch clause so that I can regulate (read increase) the number of rows of data that gets copied from the database to the client, as this...
What I hear I forget, what I see I remember, what I do I understand -
RE: Execute multiple queries on a single connection simultaneously.
The reason why I want asynchronous execution is because that way both the queries will get executed on the same connection simultaneously and at the same time hence it will...
What I hear I forget, what I see I remember, what I do I understand -
RE: Execute multiple queries on a single connection simultaneously.
Not physically
, but mentally i could'veMARS
http://www.codeguru.com/Csharp/Csharp/cs_network/database/article.php/c8715__1/
I'm not much of a DOT net guy, but I did show this to someone who...
What I hear I forget, what I see I remember, what I do I understand
Viewing 15 posts - 31 through 45 (of 59 total)