Viewing 15 posts - 1,336 through 1,350 (of 14,953 total)
When you say you store the size, I'm assuming you mean something other than width and height. File size maybe?
If it's file size, then no, you can't calculate width...
- 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 25, 2012 at 10:06 am
The most likely problem is that the database is in Compatibility level 80 (or earlier). Check 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 25, 2012 at 7:23 am
It does depend a lot on what the auditors would consider an adequate level of monitoring.
Perhaps a server-side trace would be good enough. That would be pretty minimal level,...
- 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 25, 2012 at 7:22 am
Instead of doing it in the Where clause, do it with a Join.
select *
from Table1
inner join Table2
on Table1.Col1 like '%' + Table2.ColA + '%'
where Table1.Col2 = 'xx';
Like 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 25, 2012 at 7:16 am
I haven't worked with SQL 2000 in a while, but here's something that might help:
http://www.databasejournal.com/features/mssql/article.php/2196461/XML-and-SQL-2000-Part-1.htm
- 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 25, 2012 at 6:38 am
patrickmcginnis59 (6/18/2012)
GSquared (6/18/2012)
patrickmcginnis59 (6/18/2012)
Matt Miller (#4) (6/18/2012)
patrickmcginnis59 (6/18/2012)
The question isn't whether disparity exists, it's whether the ability to move along the income spectrum exists.
Everybody on the lower income...
- 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 22, 2012 at 10:01 am
If you mean login requests, you can do that through what's called a Login Trigger. Data on those is here: http://msdn.microsoft.com/en-us/library/bb326598.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
June 21, 2012 at 2:53 pm
If the only thing you're doing is inserts, I'd suggest Insert Select instead of Merge. That's usually faster.
However, on very large datasets, inserts can end up slow too, depending...
- 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 21, 2012 at 2:52 pm
You're welcome.
- 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 19, 2012 at 2:38 pm
Okay, given the clarifications provided, this isn't something SQL is good at, so it's going to be awkward to implement in it.
What you have to do build a recursive function...
- 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 19, 2012 at 12:49 pm
When that happens to me, it's usually either that the workstation I'm at is overloaded (check Task Manager), or some piece of the project I'm working on is being problematic...
- 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 19, 2012 at 12:28 pm
The easiest way to do this would be to consolidate the data into a single database, from all servers. Create a single table with a GUID column in 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 19, 2012 at 12:26 pm
Phil Parkin (6/19/2012)
Everyone who fought the Nazis, including internal rebels within Germany, took risks. The article doesn't say "Americans beat the Nazis", it says people who took risks did 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 19, 2012 at 12:20 pm
Are you looking for ANY combination of Items where the quantity = 10 (or whatever number), or per-item?
For example, if item 1000 has qty 6 and item 1001 has qty...
- 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 19, 2012 at 11:47 am
george sibbald (6/19/2012)
I wonder if the promotion of risk would be so enthusiastic now we know just how...
- 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 19, 2012 at 11:39 am
Viewing 15 posts - 1,336 through 1,350 (of 14,953 total)