Viewing 15 posts - 2,866 through 2,880 (of 2,894 total)
For the future, please supply create table and data insert scripts together with question. It will help helper 🙂
That is what you need:
DECLARE @FirstTable TABLE
( ParentID int , ParentName...
May 15, 2010 at 4:46 pm
I am wondering what your log sp logs when the main sp does something within transaction and transaction is rolled-back. Unlike Oracle there is no autonomous transaction concept in SQL...
May 14, 2010 at 4:59 pm
UMG Developer (5/14/2010)
May 14, 2010 at 4:36 pm
Try this:
SELECT *
FROM (SELECT ROW_NUMBER() OVER (PARTITION BY PropID
ORDER BY LatestApptDate desc ) AS PARowNumber
,PrevApptID
...
May 14, 2010 at 4:11 pm
There is no straight answer to this. Its depends on many factors.
For begining you can just add non-clustered indices for all these columns.
And see if the query will start using...
May 14, 2010 at 4:07 am
It is well known issue with SQL Server full-text predicates.
You can use dynamic sql with sp_executesql or -
I have once used the following and it did work:
IF ISNULL(@Param,'') =...
May 13, 2010 at 5:05 am
First of all. You should better use JOIN for joining tables:
select A.DTrackID, A.DVersion, A.Version, ...
May 13, 2010 at 4:40 am
Does SQL2005 support CREATE ASSERTION statement?
>NO, you will need to use CHECK constraint (unfort. a bit different to SQL-92 CREATE ASSERTION idea)
Does Sql2005 support SUM(POSITION()) ?
>NO, use CHARINDEX/PATINDEX instead
May 13, 2010 at 4:15 am
Jeff Moden (5/12/2010)
elutin (5/12/2010)
1. Quirky Update is very fast, but has some limitations and it is using undocumented feature of the SELECT. If you've read the article I've mentioned...
Yet you...
May 13, 2010 at 2:23 am
Small modification to the given query will do what you want:
;WITH CTE as
(
SELECT MAX(TickID) AskSideRWsizeTickID
FROM #TABLE WHERE AskSideRWsize IS NOT NULL
UNION...
May 12, 2010 at 1:33 pm
Check this one:
http://sql-articles.com/blogs/return-code-values-documentation-for-sp_send_dbmail-procedure/
Most likely you have an error in your query, which can be due to some security issues...
Check what the query string contains and execute it within SP.
Actually, I...
May 12, 2010 at 1:24 pm
add the following to see what this sp returns:
DECLARE @RtnCode INT
EXEC @RtnCode = msdb.dbo.sp_send_dbmail...
Check what is returned in the @RtnCode.
0 - success, 1- failure.
BUT! There are some more undocumented return...
May 12, 2010 at 12:32 pm
1. Quirky Update is very fast, but has some limitations and it is using undocumented feature of the SELECT. If you've read the article I've mentioned, you have seen that...
May 12, 2010 at 9:59 am
Can you please include the exact line of code where you are calling sp_send_dbmail?
Can you see the "Mail queued." message, which is returned on success?
When the user sending the message...
May 12, 2010 at 9:44 am
There is very simple answer to your question:
To increase your query performance you just optimize it using well known query optimisation techinques.
I do hope my detailed answer will help you...
May 12, 2010 at 9:33 am
Viewing 15 posts - 2,866 through 2,880 (of 2,894 total)