Viewing 15 posts - 12,196 through 12,210 (of 14,953 total)
The license and limit is per CPU, not per core, so 2 quad-cores can be licensed and used as 2 CPUs. Microsoft is reviewing that as more and more...
- 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
August 27, 2008 at 7:52 am
The rules for incrementing need to be defined.
What condition causes AAA1001 to increase to AAB1002? The number part, in your example, seems to go up by one each row....
- 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
August 27, 2008 at 7:46 am
You can avoid a cursor.
Create a temp table with the ID, Prod, Date and Status from the main table, and two extra columns, SetStart and SetEnd, both bit data type.
Then...
- 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
August 27, 2008 at 7:43 am
Those three characteristics aren't persisted, because they only apply to the command being run on the index, not to the index itself. They're run-time options that have no affect...
- 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
August 27, 2008 at 7:27 am
It sounds like you're having the usual "parameter sniffing" problem. Look that phrase up, there are ways to test for it and solve it, both on this site 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
August 27, 2008 at 7:21 am
Depending on the application, I believe you can set those in your connection manager, rather than having to set them for each insert.
Also, if you use stored procs for 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
August 27, 2008 at 7:16 am
If you really do mean PL/SQL, you'll have to try an Oracle forum. This one is for Microsoft SQL.
- 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
August 27, 2008 at 7:13 am
How about something like this:
create view FuelLog
as
with CTE (Row, FuelLogID, VehicleID, Date, FuelQty, EndingOdometer) as
(select row_number() over (partition by VehicleID order by Date),
FuelLogID, VehicleID, Date, FuelQty, EndingOdometer
from dbo.FuelLog)
select c1.FuelLogID, c1.VehicleID,...
- 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
August 27, 2008 at 7:10 am
Per Microsoft, Standard Edition can use as much RAM as the OS will give it.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
- 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
August 27, 2008 at 7:04 am
Intermediate steps are the way to go.
Step 1: Do Something; on Failure go to Step 2; on Success go to Step 3
Step 2: E-mail to report failure for Step 1;...
- 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
August 27, 2008 at 7:02 am
I think I've had to enable RPC to get DTC to work, in similar situations. It was a few years ago, so I don't remember all the details, but...
- 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
August 26, 2008 at 11:03 am
I've been in life-or-death situations a few times, and it does put DBA emergencies into perspective. Having been held at knife-point by muggers kind of makes a crashed hard...
- 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
August 26, 2008 at 10:55 am
Print does cut off after a certain point. You might be able to change it to select (instead of print) and output to a file or to text. ...
- 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
August 22, 2008 at 10:51 am
The Xeon may be reporting itself to SQL as 4 CPUs instead of 4 cores on 1 CPU. I'm not sure how all of that works, inside SQL.
- 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
August 22, 2008 at 10:49 am
Microsoft recommends a few steps when upgrading from 2000 to 2005 for any database. The upgrade wizard should tell you what you need to change. Make sure 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
August 22, 2008 at 10:45 am
Viewing 15 posts - 12,196 through 12,210 (of 14,953 total)