Viewing 15 posts - 7,081 through 7,095 (of 14,953 total)
I'm only fluent in American. I barely speak English. My French is beyond pathetic. I don't remember enough Classical Latin or Greek for it to be useful...
- 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
February 12, 2010 at 2:38 pm
CirquedeSQLeil (2/12/2010)
Alvin Ramard (2/12/2010)
CirquedeSQLeil (2/12/2010)
Alvin Ramard (2/12/2010)
CirquedeSQLeil (2/12/2010)
Alvin Ramard (2/12/2010)
- 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
February 12, 2010 at 2:29 pm
CirquedeSQLeil (2/12/2010)
"What is the most important data in the world?"
I think you could gain plenty of...
- 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
February 12, 2010 at 11:26 am
WayneS (2/12/2010)
[physic]Hmmm.... with Barry, Gail and Lynn involved, I sense an article in the future[/physic]
I'm not sure that's the tag you wanted, Wayne.
Dictionary definition: physic noun: a purging medicine;...
- 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
February 12, 2010 at 8:03 am
For me, it depends on the data loss policies of the company, and the ability to recover data.
For example, I used to manage a database that was just a tool...
- 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
February 12, 2010 at 6:10 am
The team version is best, but Visual Source Safe would probably work.
- 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
February 12, 2010 at 5:57 am
_UB (2/11/2010)
Be it VM or not, the ID must be unique. Even if the database is transferred...
- 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
February 11, 2010 at 1:40 pm
Try this:
select case (select serverproperty('engineedition'))
WHEN '1' THEN 'Personal/Desktop'
WHEN '2' THEN 'Standard/Workgroup'
WHEN '3' THEN 'Enterprise/Evaluation/Developer'
WHEN '4' THEN 'Express/Advanced Services/Embeded SQL'
ELSE
'Unknown EngineEdition'
END as Engine
- 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
February 11, 2010 at 10:25 am
Can't you set up source control and a check-out/in process for the reports? That's even better than just auditing, and not hard to set up.
- 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
February 11, 2010 at 10:04 am
I can't get it to work with the maxrecursion option in the view definition. Works if I query the view with that hint, but not in the view definition...
- 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
February 11, 2010 at 9:56 am
krypto69 (2/11/2010)
missing index dmv is what I was looking for..
Just be smart with that. It'll give you overlapping recommendations that end up being redundant in many cases.
- 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
February 11, 2010 at 9:44 am
Are you talking about the database engine tuning advisor?
- 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
February 11, 2010 at 8:50 am
_UB (2/11/2010)
I'll try to see, if I can explain our situation:
Our software will be installed at various locations in US. We need a way to uniquely identify...
- 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
February 11, 2010 at 8:42 am
"Best" is one of those fun words that doesn't have a real meaning. My favorite one of those is "soon".
- 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
February 11, 2010 at 8:35 am
Steve Jones - Editor (2/10/2010)
Nooooooooo, I was hoping not to manage anyone but myself.
On that goal, I'll have to say "fail". 🙂
What you have is the classic difference between "de...
- 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
February 10, 2010 at 2:58 pm
Viewing 15 posts - 7,081 through 7,095 (of 14,953 total)