Viewing 15 posts - 47,881 through 47,895 (of 49,552 total)
Then run it in a loop a few thousand times, inserting into a table with an identity.
Is there any reason you refuse the first suggestion offered fo a particular problem...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 3:39 am
Did he give you a reason why? Sound a bit strange.
Here's one that doesn't actually use replicate, but does the same thing as replicate would.
DECLARE @Length INT
SET @Length = 4
SELECT...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 3:31 am
And please post the ASP code you're using to connect and submit query.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 3:26 am
Cross join the table in a couple more times untill you have the number of rows you need.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 3:23 am
karthikeyan (12/31/2007)
Yes, you are correct.But,how to perform this one without REPLICATE function ?
Why the restriction against replicate?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 3:22 am
karthikeyan (12/31/2007)
Yes i do agree.I think your query(column 0) will use TableScan instead of Index.
Possibly, but if the requirement is that all rows other than where column=0 or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 3:21 am
karthikeyan (12/31/2007)
we need to write,
select * from sometable where column > 0
select * from sometable where...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 2:44 am
I did see your post. And, no, you don't "need to execute SET ANSI_NULLS OFF.Otherwise the above statement will give wrong output."
I specifically wrote that to illustrate how nulls...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 2:24 am
con.open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Atab;
This connection string requires that the login has access to the DB Atab. If it doesn't, you'll get the error message you described earlier.
The second...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 2:13 am
karthikeyan (12/31/2007)
WHERE Column2 IS NOT NULL
AND Column2 <> 0
So the Better way is,
Select * from sometable
where Column2 > 0
Will...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 2:06 am
You missed the point.
NULL is not a value. It's a placeholder for 'unknown'. Because it is an unknown value, it is not equal to anything. It's not unequal to anything...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 2:00 am
A non-admin user's default database should not be master. Set the database that the login uses most frequently as the default.
Other thing to check is the connection string that the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 12:24 am
From object explorer, expand out security and logins, find the login ohk\jeva, right click, select properties, go to User Mapping
Make sure that the login is mapped to the DBs that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 12:11 am
How do those pageIDs link up with the ones you posted in your initial post?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 12:08 am
It looks like ''abs_tr'' is the default database for that login. Is that correct? Is it the DB you gave them data reader and data writer in?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 12:08 am
Viewing 15 posts - 47,881 through 47,895 (of 49,552 total)