But Somehow i am again where i was before when i create the function using same statements Example: Create Function fnTest123() Returns varchar(255) As Begin declare @SQL nvarchar(4000) declare @Params nvarchar(4000) declare @name varchar(255) select @SQL = 'Select @nm = name from sysobjects where id = 1' select @Params = '@nm varchar(255) output' EXECUTE sp_executesql […]
2003-12-15
2 reads
You can use a powerful but little-known technique, namely a running update with variables: DECLARE @Sales DECIMAL(10,2), @MV DECIMAL(10,2) SELECT @Sales = 0, @MV = 0 UPDATE Table1 SET @MV = MV = CASE WHEN nDay = 1 THEN Sales ELSE 0.8*@MV + 0.2*Sales END, @Sales = Sales You do need a clustered index on […]
2003-12-11
Does this happen everytime? I'd run profiler in the background and see what is actually completing. This runs a number of commands. You can also just run sp_who2 from QA and avoid running this in EM. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-08
We feel the issue is that SQL Server doesn't recognize SID History as other resources do. I think there is something that can be installed on SQL Server that makes it AD aware. Does anyone know what this contains? Edited by - Lee Forst on 11/26/2003 1:31:16 PM
2003-11-26
Did your network folks block UDP/1434 per chance? K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/
2003-11-21
2 reads
I would post Oracle related questions here http://www.LazyDBA.com . They maintain a mailing list oracledba@lazydba.com which is quite active. Frank http://www.insidesql.de http://www.familienzirkus.de
2003-11-21
1 reads
Here's a PROC I 've used to output <8K files. Create Procedure SyExport8KBlobToTextFile_sp (@Blob varchar(8000) = NULL ,@OutPutFile varchar(256) = NULL) as if @Blob + @OutPutFile is NULL begin print ' ******* Procedure SyExport8KBlobToTextFile_sp ***** Creates a file with the passed text data Parameters: @Blob Less than 8K long string of text @OutPutFile Full UNC […]
2003-11-20
What does your SR DBA think an 'ADMIN DBA' job is? From the title, it almost sounds like this is an 'administrative' job. Documentation type things. -SQLBill
2003-11-19
1 reads
I doubt it is a DNS problem check your protocol is it named pipes or tcp? Does the application only support WINS? osql -L will only list servers on the same subnet will not always return all servers. It only picks up servers "Broadcasting on the network" as well. Take a look at the method […]
2003-11-19
Does it work if you use the IP address instead of the name? If so, you probably have a DNS server problem. -SQLBill
2003-11-19
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers