Viewing 15 posts - 49,096 through 49,110 (of 49,552 total)
One minor correction
CREATE
Procedure select_Proc1
@Key3 varchar(10) = NULL
....
If you don't...
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
May 22, 2006 at 4:57 am
Whatever order the optimiser feels is best, based on it's knowledge of the data distribution statistics and the indexes that are available on the tables.
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
May 22, 2006 at 4:49 am
Whatever order the optimiser feels is best.
That said, it is considered beter to join in the from clause, rather than the where clause. for readability, if nothing else.
SELECT * FROM...
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
May 22, 2006 at 4:37 am
What you're asking doesn't make sense. Do youi want to add new records to tb1, or do you want to update fields of existing records in tb1 to a value...
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
May 22, 2006 at 2:39 am
This is one case where cursors are pretty much required.
There's no automatic syntax for executing a stored proc and taking params from a query result.
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
May 19, 2006 at 1:31 am
My pleasure. I'm glad it's fixed.
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
May 19, 2006 at 12:13 am
Weird. That's a little slow, but not close to causing a timeout. Even the default value is 5 min.
How long does it take from the web page?
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
May 18, 2006 at 10:55 am
No idea. The .net docs should tell you.
That's already a pretty high value. how long does that query take in QA?
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
May 18, 2006 at 10:08 am
Not the timeout in the config. Is something like cmd.Timeout in the code, after you create the command, but before you execute it. Not a C# expert.
For blocking, run sp_who2...
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
May 18, 2006 at 9:42 am
Different databases, or different tables? Looks like the latter, assuming that it is.
This isn't tested, but it should be mostly right.
SELECT HH_ID, StudentID, MAX(Parent_ID) As ParentID
FROM ParentDatabase P INNER JOIN...
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
May 18, 2006 at 3:28 am
select
suser_sname()
Returns <Domain>\<Loginname>
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
May 18, 2006 at 3:01 am
Many ways, but it depends greatly on what the root problem is.
Have a look in the performance forum, iirc there are a few posts on getting started with monitoring...
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
May 18, 2006 at 2:54 am
However, if you're still using SQL 2000, then the max datatypes are not available (New feature in 2005) and you're stuck with TEXT for large text strings.
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
May 17, 2006 at 7:54 am
The error has more to do with the wierd way text fields behave than anything wrong with your parameters. You might have some success using READTEXT, but I don't really...
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
May 17, 2006 at 2:30 am
What you're trying to do can't be done in SQL 2000 (function in FROM with parameter been a field from the query). It's a new feature in SQL 2005 (CROSS...
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
May 17, 2006 at 2:24 am
Viewing 15 posts - 49,096 through 49,110 (of 49,552 total)