Viewing 15 posts - 16 through 30 (of 60 total)
Very good content. Help me a lot especially in debugging and printing reports directly from store procedures.
One question. Is the method sp_OAXXXXX create security issues, such as the person need...
May 4, 2004 at 6:55 pm
Do you configure Query Analyzer to play wave sound when complete query batch? Check it out.
Go to Tools -> Options -> Results -> Click at the option "When Query Batch...
April 27, 2004 at 12:08 am
I am not quite agree with MikeyMikey for the second reason regarding the temp table. It will not overwrire the temp table because another new temp table will be create for...
April 25, 2004 at 1:15 am
Dynamic SQL will be slower than static SQL, but this performance issue is solved by using sp_executesql instead just use EXEC. sp_executesql will avoid recompile in the store procedure. Check...
April 22, 2004 at 9:17 pm
Hi srqanqu,
I have one suggestion. You can pass the name of the table to the store procedure. Inside the procedure you will query the table using simple SQL statement!
For example:
April 22, 2004 at 6:27 pm
Avoid create trigger just because you want to populate the updates to the similar table at another server. Use replication feature instead. If the table do not have the same...
April 22, 2004 at 6:11 pm
Hi ambrose_sql,
I'm not very understand what is the meaning of the part in green color:
CREATE TRIGGER insert_into_emp ON emp
FOR INSERT,UPDATE,DELETE
AS
SET...
April 22, 2004 at 2:17 am
Use function either user-defined-function or system function may cause the query analyzer do not use indexes (if any) when doing queries for deletion. If not counting on performance, then Bert's...
April 15, 2004 at 3:16 am
Peter, try to use this statement:
DELETE FROM TableX x
WHERE x.DateFields < dateadd(dd,-21,convert(varchar(8), getdate(),112))
With this statement, you can solve Grasshooper's problem with time.
You can reschedule the job to run daily...
April 15, 2004 at 1:52 am
Bulk insert will request a lot of space in transaction log when using Full Recovery method. If your server's hardrive is limited, better to move the insert files' bulk insert...
April 15, 2004 at 1:31 am
Tyang, you should not kill all processes that have status 'sleeping'! Some is using by SQL Server itself and used only when some events triggered.
If you insist to kill the...
April 15, 2004 at 12:52 am
Andre, I think you should listen to the SQL Server's advice to run the program when the server is not busy with updates. Try to reschedule the DTS to run...
April 15, 2004 at 12:44 am
Please notice that xp_cmdshell only receive command string with varchar(255) or nvarchar(4000) only. Do not put command string longer that the specify length or it will truncated without any warnings.
April 14, 2004 at 12:24 am
If you are using local temporary table, SQL Server will automatically add the timestamp (the time temp table created) at the back of the orginal table name. Try to avoid...
February 19, 2004 at 8:16 pm
Check your data, whether there are any invalid numeric data, such as invalid characters (for numeric), such as space (behind or in-front), comma etc. Try to use LTRIM() and RTRIM().
February 16, 2004 at 6:10 pm
Viewing 15 posts - 16 through 30 (of 60 total)