Viewing 15 posts - 12,751 through 12,765 (of 14,953 total)
Chris Hamam (7/18/2008)
Notice how there is no 'I' in TEAM?...
Personally, I hate that particular cliche. There's also no "we" in "success". There is an "i" in "win". ...
- 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
July 18, 2008 at 7:56 am
Good question. My answer for soft skills is Scientology. Very effective.
- 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
July 17, 2008 at 3:12 pm
The other thing to check, with the script in the job, is whether or not the job is running it in the right database. I can't count the number...
- 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
July 17, 2008 at 2:52 pm
The reasons you give for using a cursor are pretty much the exact reason to NOT use one.
In the specific problem given, I am willing to bet you a week's...
- 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
July 17, 2008 at 2:48 pm
Mazharuddin Ehsan (7/17/2008)
will be ineffective in case of ties.
DROP TABLE #Employees
CREATE TABLE #Employees (Emp_No INT, EName VARCHAR(5), Sal INT)
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
July 17, 2008 at 2:38 pm
It looks to me like you've already hit on the right solution. Someone else may have a better suggestion, but I'd go for it with 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
July 17, 2008 at 12:55 pm
Here's how I'd solve this:
Create a Numbers table.
Use that to create a Calendar table, with all dates in the range you're querying against.
Do a From-To self-join for each log table,...
- 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
July 17, 2008 at 12:53 pm
Jeff Moden (7/17/2008)
ALI (7/17/2008)
I did solve above issue and got stuck with other. As I have tight production deadlines, I am going for cursor in a stored...
- 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
July 17, 2008 at 12:32 pm
I recommend the nested Order By solution, here's why:
;with CTE (Row, Number) as
(select row_number() over (order by col2), col2
from dbo.sometable)
select *
from cte
where row = 2
/*
=================
Without Index
=================
SQL Server parse and compile...
- 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
July 17, 2008 at 12:20 pm
Is the "EffectiveDate" in PriceInstances the same as the "DateEntered" in the other three tables?
If so, and you have a DateEntered of 17 July 08 for ItemA, and a DateEntered...
- 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
July 17, 2008 at 12:08 pm
Yes, an update trigger will fire even if the update sets the data to the same thing as it was before.
You can handle that with a join between "inserted" 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
July 17, 2008 at 11:57 am
Is there anything else running on the server, or just Windows Server and 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
July 17, 2008 at 11:53 am
Books Online has step-by-step directions on how to turn on full text indexing. I recommend following those directions.
It can affect performance, but Books Online also has data on 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
July 17, 2008 at 11:04 am
Are you sure the service is stopping and not just databases set on auto-disconnect, or something like that?
And, if the service is stopping, do you have it set to auto-restart...
- 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
July 17, 2008 at 11:00 am
The advantage to separate filegroups is they can be on separate disks, if it's under a RAID configuration that allows that. If, for example, the whole database is on...
- 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
July 17, 2008 at 10:58 am
Viewing 15 posts - 12,751 through 12,765 (of 14,953 total)