Viewing 15 posts - 511 through 525 (of 557 total)
opc.three (1/3/2013)
The clustered indexes you chose for ClientOrder and ClientLine are not ever-increasing
I am sorry I was not clear with my description. I meant that the indexes are ever increasing...
January 3, 2013 at 11:23 am
sanket kokane (12/7/2012)
Do you mean Clustered Index ?
Yes,
(Yes 'adding' or 'removing' a clustered index).
(Or even doing a simple update off one field over the whole table).
Ben
At this moment I...
December 7, 2012 at 5:27 am
Thank you for the reference to this article. This is what I was looking for.
With google I did...
October 29, 2012 at 11:22 am
GilaMonster (10/26/2012)
October 26, 2012 at 6:59 am
Thanks Michael L.John,
I saved that script, it's usefull.
(For my purpose, it only gives the first occurencen of a string and I want the occurence where the field is compared. So...
October 11, 2012 at 9:35 am
deepkt (10/11/2012)
Hi ,You can also use below queries :
SELECT DISTINCT OBJECT_NAME(id) FROM SYSCOMMENTS WHERE text like '%search key%'
SELECT ROUTINE_NAME, ROUTINE_TYPE FROM INFORMATION_SCHEMA.ROUTINES where ROUTINE_DEFINITION like'%search key%'
I did not use Routines,...
October 11, 2012 at 7:53 am
A small change See in the code.
(My reason for this change change is: The essential part of the code is only written once, so it is smaller, clearer and with...
October 8, 2012 at 2:02 pm
Thanks Artoo22 and GSquared,
Tried the XML but this result in error, as described by GSquared. (this looked promising to me).
If there are no problems with functions and operations like REPLACE,...
October 8, 2012 at 8:52 am
GSquared (10/8/2012)
The problem will be the UI, not varchar(max) nor replace().SSMS, for example, will cut off at 8k characters, when it's displaying the data.
Thanks,
Now I only have to build...
October 8, 2012 at 8:01 am
Hello all,
Because I goofed a bit in my previous solution here the worked out code.
It's a solution which only used simple replaces, not efficient (lots of updates).
ben brugman
-- Ben Brugman
--...
October 5, 2012 at 8:52 am
bitbucket-25253 (10/5/2012)
October 5, 2012 at 8:12 am
Sqlfrenzy (10/5/2012)
you can use a version control tool for it.
Thanks for your anwser.
To my knowledge (I know VSS and TFS) version control tools can only store versions of files. At...
October 5, 2012 at 7:14 am
With a large amount of replaces this can be done.
Problem is that the number of replaces is very large.
So I'll show the concept but not the code, because the code...
October 5, 2012 at 6:49 am
With a large amount of replaces this can be done.
Problem is that the number of replaces is very large.
So I'll show the concept but not the code, because the code...
October 5, 2012 at 6:36 am
ScottPletcher (9/17/2012)
September 17, 2012 at 2:38 pm
Viewing 15 posts - 511 through 525 (of 557 total)