Viewing 15 posts - 31 through 45 (of 68 total)
For those of us used to making data-marts
USE [Documents]
GO
/****** Object: StoredProcedure [dbo].[usp_GetTopN_MembershipType] Script Date: 9/10/2013 8:12:48 AM ******/
-- =============================================
-- Name:use_GetTopN_MembershipType
-- Description:Gets some number of...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 5, 2013 at 9:58 am
I'd like to do the same thing, but have not had any luck either, I'll follow this thread along to see if anyone has an answer to this - good...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 10, 2013 at 8:34 am
In the Color property of your text box, not in the Format property.
Please add your expression to the Color property of the text box, something like this
...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 27, 2013 at 8:29 am
Hi Steve - Kinda of a dirty trick changing the question...
The question posed at the front page sets mychar to varchar(10) which would fail the batch insert so 0 is...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 10:04 am
This seems so absurd that these attitudes would be fostered and expressed in this century. I think our world is better for the many technical contributions and perspectives, regardless of...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 28, 2013 at 10:05 am
I got a syntax error from the text on the second example.
Change the line
SELECT @mStrColumns = COALESCE(@mStrColumns + ', ', '') + '[' + CAST(SC.[NAME] AS VARCHAR(100) )...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 22, 2013 at 6:34 am
I see the folks at the top of the QOD (Gail, Steve etc) are listed as SSC Champions... but in their individual pages it's as you noted....
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 16, 2013 at 11:28 am
Not to oversimplify, but once the newest file is identified one option is to use script to copy it to a predetermined name like workfile.csv. Then when done, dispose or...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 11, 2013 at 8:42 am
Hi Jerry,
I appreciate this article not just for the technical elements but for the deductive reasoning that identifies the problem from the noise. This is a very good guide on...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 13, 2013 at 8:55 am
Likewise I appreciate Scott's comments. I see a lot of value in Derik's approach, this looks like 'diced onions' to me - thanks all 🙂
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 19, 2013 at 11:23 am
Nice work Hilda - I have fought that dragon too with embedded dates in large text fields.... I like your solution. Since I'm also a dot.net guy my approach is...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 17, 2013 at 9:08 am
Looks like the PIO's are not loaded - have you installed the Primary Interop Assemblies?
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 4:03 pm
I was looking at a similar problem and that is a smart solution Divya - thank you 🙂
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 14, 2012 at 9:18 am
Check the stats on the table.
Look at execution plan for bootlenecks/scans etc
Veryify order of Where parameters works to effectively
Check the indexes for existence and fragmentation.
Definitely pre calc the date comparision.
If...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 13, 2012 at 10:46 am
While easy for execs is a nice term, it doesn't address the real issue which is always - 'what makes that number and where did it come from?'. You...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 5, 2012 at 9:35 am
Viewing 15 posts - 31 through 45 (of 68 total)