Viewing 15 posts - 4,171 through 4,185 (of 7,502 total)
Like Gail said, because it is a big sproc, with multiple functionallities, it may be hard to "just optimize by reading it" and therefor it is better to split it...
January 9, 2009 at 5:18 am
- an update trigger is fired by an update event at object level (table/view) !
(so not only from your sprocs, but also by all other update statements !)
- one...
January 9, 2009 at 1:28 am
- loose the dynamic sql ( http://www.sommarskog.se/dynamic_sql.html )
- why are you using the hints with the delete statements you are executing ??
- don't comment (--) lines in your...
January 9, 2009 at 12:49 am
Mark (1/9/2009)
ALTER PROCEDURE [dbo].[sp_UpdatePlays]
-- Add the parameters for the stored procedure here
@username varchar(50)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
...
January 9, 2009 at 12:31 am
sampathsoft (1/8/2009)
...Want to do my own (in my sp)...
with regards to locking, in many cases this is not a good solution.
If you want to be ablosutely sure you don't update...
January 8, 2009 at 5:42 am
vikas bindra (1/8/2009)
I beleive sp_sendmail is not available in SQL server 2000. In 2000 you will have to use xp_sendmail.-Vikas Bindra
I'm sorry for the typo :blush: ..... didn't use it...
January 8, 2009 at 5:37 am
did you try this ?
CREATE TABLE #StaffTimeRecord
(
StartTime DATETIME
, EndTime DATETIME
)
GO
set nocount on
INSERT...
January 8, 2009 at 5:30 am
polo.csit (1/8/2009)
How to send the email throught the sql server 2000
please post in SQL2000 forum for SQL2000 questions.
Check out sp_sendmail
better even (because it uses smtp mail and no client is...
January 8, 2009 at 4:29 am
just a little side note:
If you are using SQLaccounts (non-windows accounts) for you database, you'll have to resync them with you new server.
You can migrate userid's and passwords using...
January 8, 2009 at 1:54 am
RBarryYoung (1/7/2009)
They sure don't say much about it though, do they?
Indeed, looks like a moment where a dba just quickly mumbles "and there was this little other thingy we fixed...
January 7, 2009 at 1:48 pm
jeffrey yao (1/7/2009)
WOW, that sounds a bug of sql server 2k5 itself. I am glad we have SP2 + CU10. 🙂
keep in mind, if you go to SP3, you must...
January 7, 2009 at 1:45 pm
Perry Whittle (1/7/2009)
ALZDBA (1/7/2009)
Truncation usually occurs after each checkpoint but can be delayed under some conditions
this is the key here, it should and generally does but there can be instances...
January 7, 2009 at 1:42 pm
What's your db collation ??
(case sensitive , accent sensitive, ... ??)
January 7, 2009 at 11:49 am
Perry Whittle (1/7/2009)
as i understood it, recovery interval option will make regular log truncations by issuing checkpoint, but in severe cases where transactions over run...
January 7, 2009 at 11:46 am
Viewing 15 posts - 4,171 through 4,185 (of 7,502 total)