Viewing 15 posts - 2,416 through 2,430 (of 14,953 total)
GilaMonster (12/29/2011)
Stefan Krzywicki (12/29/2011)
I don't have room on my machine either.Two words: External harddrive.
Seriously, I've had to do that once or twice.
I've done that too.
Once had the backups for the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 9:55 am
Stefan Krzywicki (12/29/2011)
Grant Fritchey (12/29/2011)
GilaMonster (12/29/2011)
Grant Fritchey (12/27/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 9:31 am
Stefan Krzywicki (12/29/2011)
Dev (12/29/2011)
Dev (12/29/2011)
Stefan Krzywicki (12/29/2011)
GSquared (12/29/2011)
Dev (12/29/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 9:28 am
David Moutray (12/29/2011)
All of you are helping me by offering your...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 9:25 am
patrickmcginnis59 (12/29/2011)
Gianluca Sartori (12/28/2011)
With RCS enabled writers don't block readers. Is this the kind of concurrency issue you're trying to address?
As far as the dangers is concerned, you could...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 9:24 am
Stefan Krzywicki (12/29/2011)
GSquared (12/29/2011)
Dev (12/29/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 9:07 am
This is the kind of situation where full text indexing and a custom thesaurus file will come in very, very handy.
I've seen this kind of query many, many times, and...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 9:02 am
Dev (12/29/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 8:53 am
Updating Image type data is done via WriteText or UpdateText. It's not simple, but read the documentation and test a few samples and you'll get it.
Documentation is here: http://msdn.microsoft.com/en-us/library/ms187993.aspx
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 8:52 am
You can't directly run a UDF on another server like that.
Build a stored procedure on the remote server that does what you want. Run that instead.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 8:50 am
GilaMonster (12/29/2011)
Grant Fritchey (12/27/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 8:48 am
Michael Valentine Jones (12/29/2011)
GSquared (12/29/2011)
Michael Valentine Jones (12/28/2011)
GSquared (12/28/2011)
Michael Valentine Jones (12/28/2011)
GSquared (12/28/2011)
Michael Valentine Jones (12/28/2011)
If there...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 8:47 am
Might look like:
;with HierarchyCTE as
(select ID, NULL as ParentID, '000000' as Breadcrumb
from dbo.MyHierarchyTable
where ParentID is null
union all
select MyHierarchyTable.ID, MyHierarchyTable.ParentID, Breadcrumb...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 7:13 am
ben.rosato (12/29/2011)
There's not 1 stored procedure in the whole database either. NADA. There are a bunch of unused indexes though:-)
That's actually pretty normal. If you're using sp_prepexec,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 7:01 am
Dev (12/28/2011)
GSquared (12/28/2011)
Dev (12/28/2011)
GSquared (12/28/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 29, 2011 at 7:00 am
Viewing 15 posts - 2,416 through 2,430 (of 14,953 total)