Viewing 15 posts - 211 through 225 (of 595 total)
anam: good catch. don't know why I didn't notice that. You may want to contribute this little headache to the FAQ...just a suggestion. It may keep...
July 24, 2003 at 6:36 am
When I mentioned checkpoints, I was actually referring to "savepoints" in a transaction, created using the SAVE TRANSACTION command. Also, the procedure is executed in a batch. If...
July 23, 2003 at 11:34 am
I hat eto say it, but the causes of poor performance are probably due to your use of cursors. If you post an example of common usage, perhaps we...
July 23, 2003 at 11:18 am
You will see the results in QA usually after transactions are committed. If your proc runs in a nested transaction, produces nested transactions, or starts a transaction without any...
July 23, 2003 at 11:14 am
Run a sample of the dynamic sql queries that run through the front end in Query Analyzer. Look at the execution plan and see what's taking the longest to...
July 23, 2003 at 11:10 am
You need an ON clause for your JOIN, plus, you don't need to increment a counter...
DECLARE @counter INT
SELECT COUNT(*) = @counter
FROM unique_cust t1
INNER JOIN unique_cust t2...
July 23, 2003 at 8:25 am
Try the Crystal Decisions Developer Zone. Just go to http://www.crystaldecisions.com
July 23, 2003 at 7:48 am
I am torn between explaining what this procedure is doing, and explaining just how bad it is. That said, the part in question (starting with the DECLARE...CURSOR bit, is...
July 23, 2003 at 7:38 am
Run a comparison between using SCOPE_IDENTITY and @@IDENTITY and MAX(IDENTITYCOL). Strange that this would be taking so long. Are there concurrency issues (lots of users)? High OLTP...
July 23, 2003 at 7:05 am
is TableA a heap? Have you tried copying tableA and putting a clustered index on MessageID (or alternatively, SendDateTime)? Is it necessary to have unicode fields? What's...
July 22, 2003 at 11:37 am
No, my guess is you would never see a performance problem from implementing CHECK CONSTRAINTs on a table. The benefits of enforcing the business rule integrity at the database...
July 22, 2003 at 11:31 am
I guess the point is that the indexing strategy you take is inconsequential if the queries and tables are poorly designed to begin with. If you normalize the table...
July 22, 2003 at 11:18 am
Buell, please don't take my post the wrong way; I'm only trying to help. I believe that if you have numerous queries like the one you posted, you are...
July 22, 2003 at 11:12 am
Could you post the schema of the table in question?
July 22, 2003 at 7:17 am
Viewing 15 posts - 211 through 225 (of 595 total)