RE: copy DTS jobs between servers
I would be happy to try your solution, but I don't understand it. Guess I'm not advanced enough. Would you resubmit it in layman's terms. "I hope you enjoy your retirement as much as I will."
2003-06-04
1 reads
Lock and Connection Management
RE: Assign a variable value based on conditions
As a check to see whether you are in the if statements you could put in print statements in the different if conditions to see whether the code actually enters the if statements. Also, are you declaring @percent as decimal or int? If it is int (or tinyint etc) you will get 0. Jeremy
2003-06-04
RE: Trouble: Stored Procedure Taking Too Long
quote: Is the SQL built dynamically? I miss spoke above. In addition to passing the procedure dynamic global temp table names, I am also passing it various parameters for WHERE clauses. I replaced the dynamic global temp tables with static temp tables. did not help.
2003-05-30
1 reads
Blocking Notification
This script will send a mail whenever it detects a Blocking process. You need SQL Mail configured on this server in order to use or you can specify the pager number @company.comEx:- 1234567789@Skytel.com
2003-05-29
1,772 reads
RE: SQL server does not exist or access denied
i didn't re-install anything for it to get working when it happened for me. have you tried reconfiguring the client network utility?
2003-05-23
RE: Is NULL comparison slow?
hmmm, What is the difference? Speed? Your solution gives about a 30ms decrease in time taken. AND (I.ErrorID >= @ErrNumStart OR @ErrNumStart = 0) -- Slow option AND (CASE WHEN I.ErrorID >= @ErrNumStart OR @ErrNumStart Is Null THEN 1 ELSE 0 END) = 1 -- fast option. Why would there be a difference? Your option […]
2003-05-19
RE: trimming trailing spaces and zeros from a string
Alternatively, try a user defined function: create function dbo.fn_RemoveTrailingZeros ( @string varchar(25) ) returns varchar(25) as begin declare @loop char(1) set @loop = 'Y' while @loop = 'Y' begin if right(@string,1) not in ('0','.') begin set @loop = 'N' end else set @string = left(@string,len(@string)-1) end return (@string) end go select dbo.fn_RemoveTrailingZeros('123456.7890') select dbo.fn_RemoveTrailingZeros('123.000') Jeremy
2003-05-19
Script to kill the top blocker and report what it was doing.
This script identifies the blocking locks at the top of the blocking chain and kills them. Specifically, it reports what the top blocking spids are doing, kills them, waits three seconds and then reports on current blocking status. If you have a situation where single connections are causing a huge blocking chain and you want […]
2003-05-12
2,949 reads
RE: MQSeries Interface
if everything else isn't an option for you (writing extended stored procedures), you can reside to use the MQSeries-Client automation interface (MQAX200.DLL) and the MSSQL functions to access automation objects (sp_oacreate, sp_oagetproperty, sp_oasetproperty, sp_oamethod). For info on programming the interface, check the red book available at ibm for free (pdf). can also send it to […]
2003-05-12
1 reads
Restrict simultaneous access to resources
This set of procedures allow you to control simultaneous access to any resource you are using. It mimics the behaviour of a Semaphore in programming.A typical problem where you need this, is when you have a computational intensive procedure you only want to be started a limited number of times.First, add a record to the […]
2003-05-07
267 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers