Viewing 15 posts - 2,386 through 2,400 (of 2,894 total)
drew.allen (8/17/2010)
Eugene Elutin (8/17/2010)
Will it be...
August 17, 2010 at 9:24 am
roy.tollison (8/16/2010)
August 17, 2010 at 8:30 am
Ok, the number of logical reads will also depend on how many rows is affected by your query and how many indexes it should update.
As you have index on ScheduleRId,...
August 17, 2010 at 7:39 am
Does your delete uses indexed column in WHERE clause?
High number of logical reads in your case may be due to fragmented indices. Try to defrag them using DBCC INDEXDEFRAG or...
August 17, 2010 at 6:35 am
Logical read shows the total number of data pages needed to be accessed from data cache to process query. It is quite possible that logical read will access same data...
August 17, 2010 at 5:08 am
You will find the answer here:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 17, 2010 at 4:53 am
Can you code in C# or do you have anyone available with this skill (you don't need an expert for this task)?
August 17, 2010 at 4:51 am
LutzM (8/17/2010)
...If there is more than one value, use a subquery and join on it instead of using IN.
That it is no longer gurateeed to be the better way in...
August 17, 2010 at 4:47 am
iain-656842 (8/16/2010)
Thats interesting. I never thought of that.So the trigger would just copy the "inserted" data?
Actually, to help you more we need a bit more details from you.
Could you please...
August 17, 2010 at 4:36 am
Kind of. I have just shown how you can pass table name (or column name) in the input parameter (or variable) and use it to build dynamic SQL. You are...
August 16, 2010 at 8:49 am
It is not the best solution to use T-SQL for these sort of tasks.
Formatting of data for GUI should be done in GUI itself or, at least, in your...
August 16, 2010 at 8:46 am
You can do something like:
CREATE TRIGGER [TRIGGER-NAME] ON [TABLE-NAME] FOR INSERT, UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON
DECLARE...
August 16, 2010 at 8:30 am
scott.pletcher (8/16/2010)
Not completely true, you can do it using dynamic SQL to create the sql command to execute, however, in this case that is not the way to go. i...
August 16, 2010 at 8:27 am
Without seeing all picture how would anyone know that
"CustomerLoopTbl is a copy of #TempResults (without AmountLastest field)" and it exists only in order for controlling your loop? Ok, name...
August 16, 2010 at 8:10 am
What about DDL for your tables and UDF? Without these, no much futher to advise. Most likely it is possible to replace your loop with better performing set-base code. But,...
August 16, 2010 at 7:29 am
Viewing 15 posts - 2,386 through 2,400 (of 2,894 total)