Viewing 15 posts - 7,066 through 7,080 (of 8,416 total)
PaulB (9/9/2009)You are correct once again.
It can't last 😀
PaulB (9/9/2009)Last but not least, in the Oracle world applying a function to a predicate column indexed by a normal index would...
September 9, 2009 at 7:16 am
KB (9/9/2009)
It has around 17 lacs of records.So i think it can be done through a simple update statement
Cool. What are 'lacs' though? :unsure:
September 9, 2009 at 7:13 am
Ian Scarlett (9/9/2009)
alter table dbo.myTable ADD fred int null CONSTRAINT DFx DEFAULT 0 with values, constraint TBx check(fred < id)
Almost, yes. But the DEFAULT...WITH VALUES is still the 'column...
September 9, 2009 at 7:12 am
KB (9/9/2009)
Is manual update(from NULL to 0), the only solution ?
There is rarely only one solution to any problem in SQL Server!
It might be easiest and as good as any...
September 9, 2009 at 7:07 am
PaulB,
:w00t: SQLPlus? ColSep? :w00t:
Wow that brought back some very old memories.
Is there a way to automate that process these days?
PaulW
September 9, 2009 at 7:03 am
September 9, 2009 at 7:00 am
That might have been a lead-up to:
SELECT DATEADD(DAY, (DATEDIFF(DAY, 0, CURRENT_TIMESTAMP)), 0)
You can use the CONVERT function with a style parameter to format the result.
You can also use CONVERT to...
September 9, 2009 at 6:54 am
Just to expand slightly on Jack's (very patient) comments:
One reason that fragmentation might not be fully removed is because the first 8 data pages for an object come from 'mixed...
September 9, 2009 at 6:50 am
farax_x (9/8/2009)
How can I edit noise words in SQL server 2008
In Management Studio, expand your database name, then Storage. There you will find full-text stop lists.
September 9, 2009 at 6:40 am
Shame about the lost post Ian. It is a sad reflection on this site that I automatically hit CTRL+A, CTRL+C before hitting the button!
Thanks for seeing what I was...
September 9, 2009 at 6:33 am
farax_x (9/8/2009)
select * from tblDocument where contains(docNo,'"/abc 123 \*"')
That exact example works fine for me in 2008.
September 9, 2009 at 6:26 am
Yikes Rog, that sounds like a bit of a nightmare.
Nevertheless, we all have to do stuff we'd rather not sometimes, so let's see...
Rather than try to do the work on...
September 9, 2009 at 5:37 am
Silverfox (9/9/2009)
Nice to know about the mirroring bit, thanks for that
It is a very cool feature. Not sure if we will ever use it (or notice it being used)...
September 9, 2009 at 5:30 am
This all seems like a very bad plan to me.
Perhaps if you say what it is you want to achieve by doing this update, we can point you to a...
September 9, 2009 at 5:28 am
Viewing 15 posts - 7,066 through 7,080 (of 8,416 total)