Viewing 15 posts - 46 through 60 (of 66 total)
Because, by varying the server name, you are varying the object you a referring to, that is dynamic SQL.
Except, we have objects that "alias" to other objects .. views to...
May 28, 2003 at 1:11 am
"sysservers" does not mean all SQL servers, it should be called sysLINKEDservers, which relates to alzdba's point.
You would also have to define the procedure DatabaseSummaryInfo on each server.
I have recently...
May 28, 2003 at 12:38 am
I think that sp_helpserver and sysservers are really about Linked servers. That is, they dont recognise all the servers you might have, only those you have explicitly created "linked...
May 28, 2003 at 12:24 am
I meant, move the code from the trigger to a stored procedure, so the trigger becomes just one line "exec triggerprocedure", recompiling that would be cheap, and I wondered if...
May 28, 2003 at 12:01 am
IOs aint IOs.
There are two physical types of IOs - direct and sequential - and other terminology depending on what function you are using to look at it.
Firstly, the popup...
May 26, 2003 at 9:26 pm
Is it any different if you put your logic in a stored procedure that is called from the trigger ? (that is, SP may not recompile)
May 26, 2003 at 8:51 pm
In Query Analyzer, type in a query on your view. Select the menu Query - Display Estimated Execution Plan.
You will see that the query plan shows how the UNDERLYING...
May 21, 2003 at 7:17 pm
quote:
Beware using TRUNCATE TABLE as that is a non-logged operation
It will not fire on-delete triggers.
Some...
May 21, 2003 at 6:50 pm
Perhaps the constraints (especially the second) were create WITH NOCHECK.
Because you can bypass checking when the constraint is created, it is possible (I think) to create a unique constraint on...
May 16, 2003 at 1:05 am
EXEC (dynamic) is always executed in a separate scope, which means it does not have the variables that were declared in the scope where "exec" appears.
Just as
declare @code1 varchar(10)
execute 'select...
May 16, 2003 at 12:55 am
Some errors in SQLServer are Untrappable in T-SQL. You can trap it in application code (ADO for example) but since you refer to @@Error it seems like you are...
May 16, 2003 at 12:46 am
Unions should always be
UNION ALL
unless you want the effect of Select DISTINCT.
Just thought I'd mention it because someone had a bit of code with Union. It can effect performance.
May 15, 2003 at 1:43 am
Maybe if you compared cpu from sysprocesses with before&after values of the global variables @@idle and @@cpu_busy (in millisecs) you might figure it out.
EG if you can get a quiet...
May 15, 2003 at 1:33 am
Definitions:
Primary Key = A unique key, disallowing Nulls. It is a concept from relational theory, where a Primary Key is one type of Constraint (Unique constraint is another, very...
May 14, 2003 at 6:10 pm
I load 50,000 rows in 15sec. Multiplying that out, 24m would be 2 hours (just as a rough guide). Mine is a narrow table though - the total...
May 14, 2003 at 5:44 pm
Viewing 15 posts - 46 through 60 (of 66 total)