Viewing 15 posts - 1,921 through 1,935 (of 5,590 total)
Jeff Moden (1/12/2011)
January 12, 2011 at 6:48 pm
Stefan Krzywicki (1/12/2011)
I'm just outside Boston, we're certainly snowed in here.
How much did you get?
Grant / Adam - how much did you'll get?
January 12, 2011 at 5:14 pm
Double-posted. Direct all responses to this thread where it is already answered
January 12, 2011 at 5:06 pm
SELECT ID,
[64] = MAX(CASE WHEN UnknownColumnName = 64 THEN AnotherUnknownColumnName ELSE NULL END),
[65] = MAX(CASE WHEN...
January 12, 2011 at 4:54 pm
Tom Bakerman (1/12/2011)
Wayne,Can you provide more explanation on this part of the query:
TYPE).value('.','varchar(max)')
Tom,
Put an Ampersand (&), Less than (<) or Greater than (>) in your data, and see...
January 12, 2011 at 1:17 pm
jwmott (1/12/2011)
Thanks. It looks like it does exactly what I need. I would like to learn more about how this works. Got any good reference sources to recommend?
I'm...
January 12, 2011 at 10:57 am
How's this?
-- See how this starts off with a table and data in it?
-- If you had provided us the data in this format,
-- it would have made...
January 12, 2011 at 10:34 am
If it's a sql login, script out the login from the secondary server, and apply it to the primary. Then build your user, and delete the login from the primary.
It...
January 12, 2011 at 10:19 am
Grant Fritchey (1/12/2011)
January 12, 2011 at 10:15 am
Matt, Jason - thanks!
January 12, 2011 at 10:11 am
JJ B (1/12/2011)
January 12, 2011 at 10:10 am
itsjustme (1/12/2011)
either way works, I tried with move option and created a sql agent job to automate the backup\restore jobs.
Cool, thanks!
January 12, 2011 at 9:12 am
itsjustme (1/12/2011)
Thank you very much! that really worked... just adding the text in single quotes and defining '.mdf' and '.ldf' to variables really worked...
Just so I can learn from this...
January 12, 2011 at 8:55 am
For those building delimited strings with
FOR XML PATH(''),TYPE).value('.','varchar(max)')
See this post for a tweak that improves performance by a factor of 6 (on my test data... maybe more for you!)
January 12, 2011 at 8:31 am
Mark-101232 (1/12/2011)
Changingvalue('.','varchar(max)'),1,1,'')
to
value('(./text())[1]','varchar(max)'),1,1,'')
appears to give a better query plan
Thanks for the information... I'll have to test this out.
Edit: WOW! What a difference! Identical...
January 12, 2011 at 8:15 am
Viewing 15 posts - 1,921 through 1,935 (of 5,590 total)