Viewing 15 posts - 1 through 15 (of 19 total)
Yep, appreciate the real world examples as well. I have not worked much with partitioning and found that element very helpful.
June 7, 2010 at 11:12 am
Can you explain what the 3 min proc is doing? I think a lot of the comments above mine are leading towards checking to see that the...
May 17, 2010 at 6:19 am
For additional context...
We had specs gathered by BAs for a relatively new team of developers. The BA work was 6 months ahead of the developers. ...
June 16, 2009 at 8:48 am
My first suggestion is to create separate type tables. Yes, you can maintain a list of different types in one table, and you can create triggers to...
April 20, 2009 at 5:22 am
Whether you have 'used' a great deal of t-sql or not, you apparently have not been exposed to enough bad and good sql and the impact on a taxed database...
March 16, 2009 at 5:15 am
I do not have SQL Server 2000 to verify with...
In the create view statement the columns are being aliased.. It looks to me that the query designer is...
January 30, 2009 at 4:03 am
You can do this in one pass, however the legwork to get the data into a format for one pass and then decompose it inside the stored procedure is probably...
March 17, 2008 at 5:22 am
We had similar problems at a job I worked. Basically we had a third party software that the dev manager was impatient with the software producer. ...
March 17, 2008 at 4:40 am
Create PROCEDURE spTest (@id nvarchar(50),@_Name nvarchar(50))
AS
Select EmpID as @ID ,EmpName as @Name from DataBase
There is not enough information here to figure out what you are trying to do or why....
March 17, 2008 at 4:33 am
Try looking at this...
March 12, 2008 at 5:56 pm
Good morning, I would suggest a little different data model.
Since Assemblies contain other assemblies its a little awkward.
Plus the way you were joining products...
March 11, 2008 at 5:22 am
Personally I would create #return as a real table.
For each instance of sp1 you are running
EXEC ODS_VLD_Header 'ODQ_VLD_JCU07','Retail Customer Arabic Address Validation Job','NBKODSDB.dbo.BV_RETDCUST_CUSTADDR',
@LoadInstanceID output,@JobID output,@ODSTableID output.
If you return...
March 10, 2008 at 6:26 am
Here is a useful query off of Google. I modified to your needs to find the failed jobs.
SELECT
SJ.name 'JOB Name'
,'Run date : ' +
REPLACE(CONVERT(varchar,convert(datetime,convert(varchar,run_date)),102),'.','-')+' '+
SUBSTRING(RIGHT('000000'+CONVERT(varchar,run_time),6),1,2)+':'+SUBSTRING(RIGHT('000000'+CONVERT(varchar,run_time),6),3,2)+':'+SUBSTRING(RIGHT('000000'+CONVERT(varchar,run_time),6),5,2) 'Start Date...
March 10, 2008 at 5:58 am
Viewing 15 posts - 1 through 15 (of 19 total)