Viewing 15 posts - 1,171 through 1,185 (of 1,199 total)
Since the description you give is on a fairly high-level, it is difficult to give exact advice, but, no, from what you say I don't think indexed views is what...
July 7, 2013 at 1:55 pm
This is not a simple problem, but mister.magoo is correct. The trigger way is not likely to work out well. First a few words on why the trigger you have...
July 7, 2013 at 1:50 pm
Sean Grebey (7/2/2013)
July 6, 2013 at 3:00 pm
Have you considered log shipping?
July 6, 2013 at 2:51 pm
How does the format file look like? Any chance you can attach the problematic datafile?
July 6, 2013 at 3:04 am
You could do away with the big CASE expression if you use the datename function:
datename(MONTH, ins.lasUpdateDate) + ', ' + datename(YEAR, ins.lastUpdateDate)
As for the actual problem, I assume that ins.LastUpdateDate...
July 6, 2013 at 2:58 am
If I understand the query correctly, the task is to find the RefKey for the interactions which INum is @INum, PromoOrRef is R, ResultStatus is 312 and DeleteFlg is N...
July 6, 2013 at 2:48 am
Yes, the data type for isnull is always the type of the first argument.
July 5, 2013 at 1:54 pm
When you use EXECUTE AS, you impersonate a database user, not a server login and you are sandboxed inside your database. You can break out of the sandbox - and...
July 5, 2013 at 1:30 pm
jhager (7/5/2013)
Another great reply; I currently ask my team to use COALESCE exclusively because it's ANSI standard and more flexible due to multiple parameters..
However, there is a major problem with...
July 5, 2013 at 1:25 pm
shyam00 (7/5/2013)
Is there any way to tackle my scenario mentioned here.?
I need to combine (UNION) two non related derived tables and create an indexed...
July 5, 2013 at 1:19 pm
So maybe there is a failed mass-insert after all. Anyway, again, this is nothing you should waste your time on. Seriously.
July 5, 2013 at 1:16 pm
Without knowledge of the table it is impossible to give a good answer. You can always do:
JOIN (SELECT *,
...
July 5, 2013 at 5:00 am
Do you have any reason to believe that this is related to SQL Server? On the surface it seems that you should look for a forum elsewhere for help.
July 5, 2013 at 4:51 am
Take a look at sys.dm_db_task_space_usage
July 5, 2013 at 4:49 am
Viewing 15 posts - 1,171 through 1,185 (of 1,199 total)