Viewing 15 posts - 1,501 through 1,515 (of 5,502 total)
Syed Jahanzaib Bin hassan (5/27/2011)
use Database Audit Specification against particular object or schema,you can capture all stuff
Please note this is the SQL 2K5 forum....
Or is the intention of your reply...
May 27, 2011 at 10:42 am
Oh, I forgot: an issue open since last Sunday is unlikely to be urgent. If it still is, you might want to consider calling a consultant in. Or you could...
May 27, 2011 at 8:22 am
What exactly is wrong with the approach posted by Jeffrey at the original thread?
The ROW_NUMBER approach is the right direction to dynamically calculate the StatusEndDate.
Please refer to the ROW_NUMBER solution...
May 27, 2011 at 8:19 am
The whole trigger is designed to only work with one inserted row.
The heavy use of NOLOCK hints provide a risk of dirty reads which might be the root cause.
Rewrite the...
May 25, 2011 at 12:43 pm
I would prefer an inline-Table valued function over of a stored procedure.
The benefit: you can still use it like a view (e.g. SELECT * FROM your_function(param1))
May 24, 2011 at 4:01 pm
What table is it, actually, you need to refresh?
If you don't consider adding proper indexes as an option, you could rewrite the query to create a temp table using the...
May 24, 2011 at 3:55 pm
Did you realize the @x actually is a variable and not a column name?
Since we still don't know anything about your table structure we can't provide the correct (SQL Server)...
May 24, 2011 at 2:50 pm
Ok, let's start from the beginning:
Please read and follow the instructions given in the first article referenced in my signature and provide ready to use sample data.
May 24, 2011 at 1:31 pm
??????
Did you try to modify the solution I posted to work against your sample data?
May 24, 2011 at 1:18 pm
A very basic example due to missing sample data:
DECLARE @x VARCHAR(50)
SET @x='Maryland<h2></h2>'
SELECT '<h2>'+ REPLACE(@x,'<h2></h2>','</h2>')
WHERE @x LIKE '%<h2></h2>'
May 24, 2011 at 1:00 pm
ORDER BY CAST(SUBSTRING(CONVERT(VARCHAR(11), date, 113), 4, 8) AS DATETIME)
May 24, 2011 at 12:29 pm
The major issue is this rather large join is not supported at all by non-clustered indexes leading to a monster of 26m rows before any filter is applied (in between...
May 24, 2011 at 11:42 am
GilaMonster (5/23/2011)
LutzM (5/23/2011)
May 24, 2011 at 3:57 am
Based on some of your latest reply I might have to re-evaluate my position regarding NP organization... 😎
Regarding the specific situation: it might be better for the person in question...
May 23, 2011 at 4:56 pm
Viewing 15 posts - 1,501 through 1,515 (of 5,502 total)