Viewing 15 posts - 8,071 through 8,085 (of 8,416 total)
Barry,
We posted together!
Script for online restore of a single read-write file in a filegroup:
http://msdn.microsoft.com/en-us/library/ms175532(SQL.90).aspx
edit:
Something I re-learned just now: a full file backup can form the base for differential file backups.
How...
May 1, 2009 at 5:47 pm
Michael Valentine Jones (5/1/2009)
Backup and restore by filegroup is just a way to spread out the...
May 1, 2009 at 5:40 pm
Hey Troy,
I think the article below will answer your questions. It will take a bit of reading, and if you have any specific questions afterward, please post back.
May 1, 2009 at 5:14 pm
Tao,
No; it just seems that way because the top N articles cover the top 80% of commonly-asked questions like this one about UDFs.
Paul
May 1, 2009 at 1:23 pm
Sleep is for people without deadlines 🙂
May 1, 2009 at 12:43 pm
Lynn Pettis (5/1/2009)
I think we just went full circle back to Paul's comment about it being intuitive.
Yeah but look how many posts we added!
May 1, 2009 at 12:33 pm
Lynn Pettis (5/1/2009)
So, denizens of The Thread, when do you think we'll hit 4,000 posts?
...I cannot teach him. The boy has no patience.
May 1, 2009 at 11:38 am
Jeff Moden (5/1/2009)
Ok... I've lost it... what are you measuring here? The code to gen 256 characters?
The 'A & B Cleaners' thing you posted.
It was a hyperbole-ic tangent.
May 1, 2009 at 11:35 am
Does the hack with FLOATs from DATETIMEs still work with DATETIME2?
May 1, 2009 at 9:55 am
Dear oh dear.
I have *just* realized the point of Lynn's solution!
It avoids the I/O on the custom tally table completely.
Not my finest moment.
Luckily it won't be available on the internet...
May 1, 2009 at 9:53 am
Lynn Pettis (5/1/2009)
TheSQLGuru (5/1/2009)
Flo, are you getting your reads from SET STATISTICS IO ON? IIRC UDFs don't report IO correctly in this manner. Try getting them with Profiler.
Depending...
May 1, 2009 at 9:51 am
Lynn Pettis (5/1/2009)
Ah, padawan, set-based solution to populate your table I created, hmm.Look for the good in the bad, you may see it.
Amusing!
Yes I did get that - but I...
May 1, 2009 at 9:48 am
Lynn,
I'm thinking that that TVF might be adapted to accept a string of characters to keep as a parameter.
Returning a set of characters to strip would allow Jeff's solution to...
May 1, 2009 at 9:32 am
Why not send him a link to this thread and allow him to respond directly?
May 1, 2009 at 9:09 am
:laugh:
I seem to be attracted to solutions which misuse the language somehow... :w00t:
May 1, 2009 at 8:29 am
Viewing 15 posts - 8,071 through 8,085 (of 8,416 total)