Viewing 14 posts - 1 through 14 (of 14 total)
SQL 2008 BOL "ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/952595a6-cf1d-4ff5-8927-66f9090cf79d.htm". MS finally did something nice. It has it's limitations and place but doesn't everything. I use it quite a bit, but would really...
January 26, 2012 at 6:00 am
I recently was surprised to find importing a large number of wide rows it was faster to use a SSIS merge of two sorted inputs with a conditional split rather...
December 12, 2011 at 6:42 am
Not totaly clear about if you wanted to remove all spaces or just leading?? If you are tataly striping the characters just use a series of nested "REPLACE" statements.
DECLARE @str1...
December 27, 2010 at 2:07 pm
What about a simple "SUBSTRING" & "PATINDEX"
DECLARE @str1 VARCHAR(100), @str2 VARCHAR(100), @str3 VARCHAR(100)
SET @str1 = 'hello | world | I love sql server'
SET @str2 = '| '+@str1
SET @str3 =...
December 27, 2010 at 1:53 pm
I have not seen this solution in the above list. Not fancy, but performs the initial request to delete duplicate rows leaving the initial entry, with minimal resource impact (especialy...
November 2, 2009 at 7:16 am
The orginal request was to purge the system of "duplicate" rows. Some rows are duplicated and some are not. Additionaly some names lie Terry may be either a...
October 30, 2009 at 7:23 am
-- Create table
CREATE TABLE dbo.xSource (Name VARCHAR(50), Age TINYINT, Sex CHAR(1))
INSERT INTO xSource VALUES ('Stephen', 43, 'M')
INSERT INTO xSource VALUES ('Stephen', 43, 'M')
INSERT INTO xSource VALUES ('Stephen', 43, 'M')
INSERT INTO...
October 30, 2009 at 6:51 am
DECLARE @FRUIT TABLE (
id SMALLINT,
name VARCHAR(10)
)
INSERT INTO @FRUIT (id, name)
SELECT TOP 100 PERCENT id, name FROM (VALUES (101, 'Apple'), (102, 'Banana'), (103, 'Orange'), (104, 'Melon'), (105, 'Grape')) X (id, name)
SELECT...
October 14, 2009 at 2:53 pm
I greatly appreciate your help on my conundrum. I used Toad with Oracle (Nice) but it looks like it has a large footprint also. I had a copy...
June 18, 2009 at 10:15 am
Maybe I have misunderstood the roll of SQLCMD? What I have read is that it is a fabulous tool to run a SQL script from a command line, but...
June 18, 2009 at 6:17 am
The problem is a need to closely monitor multiple servers jobs running custom applications and performance. This is accomplished easily by TSQL scripts, then when an issue is found...
June 17, 2009 at 3:55 pm
I stopped using the DD because when visualizing the DB and you link or make a change to the diagram it actually makes the change in the DB tables. ...
May 19, 2009 at 7:13 am
I agree with the consensus above that I love to help others, for very selfish reasons, I expand my knowledge, but it is a drag when people ask to do...
November 25, 2008 at 2:21 pm
Appreciate the article greatly. I have been working with SQL for a while and have built some nice tools for routine task, but have never been able to share...
November 25, 2008 at 11:50 am
Viewing 14 posts - 1 through 14 (of 14 total)