Viewing 15 posts - 13,351 through 13,365 (of 14,953 total)
Jeff Moden (6/16/2008)
GSquared (6/16/2008)
I have some examples where hardware was a solution. See if you agree with them:
Yes... we did something similar at work... we changed from SQL Server...
- 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
June 17, 2008 at 6:53 am
On the performance, I'm trying to get the results right, then I'll mess with the speed. Once I know the right data is coming out, then it's time to...
- 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
June 16, 2008 at 3:17 pm
It's meant to be an inner join. Sorry about that.
- 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
June 16, 2008 at 3:11 pm
Piotr Rodak (6/16/2008)
- 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
June 16, 2008 at 3:08 pm
GilaMonster (6/16/2008)
GSquared (6/16/2008)
Say an airplane's navigation system. That must not give an incorrect result.
It depends on "incorrect". If, for example, precision exceedes accuracy, that's wasted effort.
Naturally. I probably should...
- 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
June 16, 2008 at 3:02 pm
Say an airplane's navigation system. That must not give an incorrect result.
It depends on "incorrect". If, for example, precision exceedes accuracy, that's wasted effort.
If an airplane's (or ship's) navigation...
- 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
June 16, 2008 at 1:00 pm
I do have an opinion on this subject, and it's got a basis in reality. There is a gradient scale of being right, with dead-wrong on one end 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
June 16, 2008 at 12:34 pm
Jeff Moden (6/15/2008)
I've never known hardware to be the solution to any performance problem... not ever.
I have some examples where hardware was a solution. See if you agree with...
- 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
June 16, 2008 at 12:07 pm
What I very specifically asked for is create scripts and insert statements.
For example:
create table T1 (
ID int identity primary key,
Col1 varchar(25),
constraint CK_Col1 check (col1 != '' or col1 is null))
go
insert...
- 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
June 16, 2008 at 8:34 am
Sorry for the delay in answering, I was out sick for a few days.
Here's what I meant by adding that one table back in to the query.
SELECT CHF.CONTACT_WID ,
COUNT(DISTINCT...
- 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
June 16, 2008 at 8:26 am
Change the formula to:
dateadd(day, -1 * datepart(day, ltrf.month_year), ltrf.month_year) + 1
That should do it.
- 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
June 16, 2008 at 8:16 am
Just an off-the-cuff guess, is Auto-Close turned on on that database?
- 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
June 16, 2008 at 8:04 am
Kevin (6/10/2008)
I have made use of MSDE and now SQL Express 2005 for an application, some details:
* Size of Databases between 30 - 150MB - yes MB
* ...
- 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
June 16, 2008 at 8:02 am
I disagree with all of the answers. The most correct answer is "Change the column to data type varchar(max) and use Update".
- 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
June 16, 2008 at 7:36 am
Can you extract the XML file into a flat table? A temp table or a real table, either one?
It looks to me like this proc is stepping through 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
June 10, 2008 at 2:17 pm
Viewing 15 posts - 13,351 through 13,365 (of 14,953 total)