Viewing 15 posts - 8,086 through 8,100 (of 14,953 total)
The main place to use Simple recovery is in systems where either all data changes are through scheduled ETL processes, or systems where all data changes can be re-run for...
- 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
October 20, 2009 at 7:18 am
bas de zwart (10/20/2009)
- 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
October 20, 2009 at 7:08 am
Gift Peddie (10/19/2009)
Agree with Gift and Jeff on documentation and "passing the baton". Any project that's in a position where losing a person, either due to employment termination or accident/illness,...
- 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
October 20, 2009 at 7:04 am
ItalianOlgi (10/19/2009)
GSquared (10/16/2009)
ItalianOlgi (10/16/2009)
Hello,I have question:
What is index fragmentation? Why is important to keep it at or below 20%?
Because it tastes better that way.
(Others reading this thread, be aware 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
October 20, 2009 at 7:01 am
Right. So without some form of disaster recovery/prevention, it's looking like that one would result in potential data loss, and certainly removes the guarantee of integrity.
- 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
October 20, 2009 at 6:56 am
acarlson-861483 (10/19/2009)
jcrawf02 (10/19/2009)
Who'd pay for that? I can do that without any money at all.....:-P
I am constantly amazed by what people will buy or buy into. The movie "Idiocracy" does...
- 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
October 20, 2009 at 6:53 am
DateAdd month, if you're using the Arabic calendar or Chinese calendar, functions quite differently than if you're using the Gregorian calendar. All by itself, that makes the function non-deterministic.
Edit:...
- 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
October 19, 2009 at 8:49 am
bas de zwart (10/19/2009)
Works like a charm, I still haven't seen any technical reasons for this option to be here...
- 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
October 19, 2009 at 8:37 am
Agree with Peter on Pivot: totally useless function as implemented, would be useful if it didn't require hard-coding.
Agree with Gift and Jeff on documentation and "passing the baton". Any...
- 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
October 19, 2009 at 8:25 am
I prefer "tastes great" over "less filling". She's marginally better looking, in my opinion.
- 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
October 19, 2009 at 8:10 am
AD_MailingAddress.MobilePhone,
SD_Admission.SDAdmissionCD,
vs
ISNULL(AD_MailingAddress.Email,'') AS Email,
ISNULL(AD_MailingAddress.MobilePhone,'') AS MobilePhone,
That means the results will only be the same if neither of these columns is ever null. Regardless of syntactical structure, this means 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
October 19, 2009 at 7:58 am
create table dbo.CompCol (
ID int identity primary key,
MyField int,
MyDate as dateadd(hour, -5, dateadd(second, MyField, '1/1/1970')));
go
create index IDX_CompCol_MyDate on dbo.CompCol (MyDate);
Result:
Msg 2729, Level 16, State 1, Line 1
Column 'MyDate' in 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
October 19, 2009 at 7:56 am
Right. In that case, you'd use "Where left(Zip, 5) = '05123'", instead of "Where Zip = '05123'". That's why I referenced the Left() function.
If you do that kind...
- 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
October 16, 2009 at 3:04 pm
GilaMonster (10/16/2009)
GSquared (10/16/2009)
Of course, if that particular page was affected by some transaction in the lost file....
As far as I'm aware, it doesn't matter. With a missing log file, 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
October 16, 2009 at 2:55 pm
Is that T-SQL?
I ask, because the parentheses at the beginning of the From clause don't seem to encapsulate a derived table.
Another first-glance issue is all the Like statements that seem...
- 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
October 16, 2009 at 2:43 pm
Viewing 15 posts - 8,086 through 8,100 (of 14,953 total)