Viewing 15 posts - 136 through 150 (of 252 total)
In some cases, it's a good idea to restore to a new database, leaving the original alone. If you can find the missing data or objects in the new database, it...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 26, 2004 at 12:33 pm
The udf is returning TABLE data_type - it's used in a FROM. Unlike in a temporary table, the storage will be in RAM. Something to worry about if there is a...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 4:06 pm
Because views do not have parameters, a separate view for each division will be required. If this is not acceptable, then a stored procedure or udf will be the way...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 3:33 pm
...maybe a left join and a where clause looking for no record joined (i.e., [ID] is null)....
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 11:39 am
and Issuers.TickerSymbol not in
(
select [ID] from dbo.fn_EqOnlyBeta(@INTERVAL_ID)
where BETA <> 0
This looks very ugly to me. Make sure that not very many records are in the TABLE data_type...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 11:37 am
However it's done, be carefull to limit the records when possible. In the OPENROWSET, be sure to use a WHERE when possible to limit the records returned. With linked servers, simple joins...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 11:27 am
Depending on your needs, an OPENROWSET might be used (e.g., in a join, to load a temp table, etc.)
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 11:20 am
However, if your login does not have execute permissions to a stored procedure, then syntax tricks will not help. "Extra" access is not granted based on the T-SQL in the ad-hoc...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 11:12 am
You have at least two options if you need to use the resultset from the stored procedure.
1) You can use the stored procedure to insert the results into a...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 10:56 am
If access is by username, the user name can be passed to a stored procedure (returning a rowset) or user-defined function (returning a TABLE data_type). The T-SQL code can then use...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 10:31 am
I have similar trouble using a TABLE data_type. The TABLE datatype has local scope and can't be passed as a parameter.
I wanted to return a list of table names...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 10:14 am
I have had this problem in the past. I ended up doing do-nothing transactions to get the "logical log" to wrap to the beginning. See "Shrinking the Transaction Log" in...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
September 28, 2004 at 11:23 am
It is possible to create your own user-defined messages using sp_addmessage (c.f., BOL). The user-defined error numbers start at 50001. However, messages are not database specific. If moving the related...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
September 28, 2004 at 10:03 am
I also rebuilt my indexes first. Perhaps that made a difference.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
June 25, 2004 at 12:30 pm
Thank you for the reference. I'll try the following in the job, as suggested in the article.
SET ARITHABORT ON
SET QUOTED_IDENTIFIER ON
EXECUTE master.dbo.xp_sqlmaint N'-PlanID ....
-Randy
It's not a bug -...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
June 24, 2004 at 5:22 pm
Viewing 15 posts - 136 through 150 (of 252 total)