Viewing 15 posts - 17,776 through 17,790 (of 26,489 total)
SQL Iron Chef (12/21/2009)
You do know that the NOLOCK hint on the update is ignored, right?
December 21, 2009 at 1:54 pm
Forgetting your problem at the moment, let me get this straight; database using full recovery model, daily full backups, no transaction log backups? You do realize that the transaction...
December 21, 2009 at 1:53 pm
If it can be done transparently at the database level there may be a better chance of developers making use of the technology when it is needed without specialized coding.
December 21, 2009 at 1:34 pm
I could see developers writing client apps that using Compact and Express editions for holding data in flight locally. TDE may be necessary if those apps hold critical data,...
December 21, 2009 at 1:27 pm
Joe-420121 (12/21/2009)
2. The table is used 24 hours, and about 2000 users use it all the time.
3. When I use...
December 21, 2009 at 1:25 pm
rahulsony111 (12/21/2009)
cast(convert(varchar(8), getdate(), 112) as int)it didn't work for me man
Worked for me when I ran it in SSMS. What error did you get?
December 21, 2009 at 1:23 pm
Do you have any transaction log and/or differential backups between the previous full backup and this one that appears to be corrupt?
December 21, 2009 at 1:22 pm
CirquedeSQLeil (12/21/2009)
Given the updated information, the solution provided by Lynn is what you need.Curse you Lynn for beating me to the punch again 😉
Join me you may, comfortable in the...
December 21, 2009 at 1:20 pm
Possibly. What is the recover model of the database?
December 21, 2009 at 1:17 pm
Jack Corbett (12/21/2009)
Ah, I always forget about those odd ball time zones. Just like the one in Indiana that doesn't do DST. Good catch!
Well, at previous employer we...
December 21, 2009 at 1:11 pm
You may not want to hear this, but I think your backup file is hosed.
Do you have a previous backup file and differential/transaction log backup files?
December 21, 2009 at 1:07 pm
CirquedeSQLeil (12/21/2009)
Lynn Pettis (12/21/2009)
How many more ways can the same question be asked?http://www.sqlservercentral.com/Forums/Topic837454-148-1.aspx
http://www.sqlservercentral.com/Forums/Topic837318-148-1.aspx
http://www.sqlservercentral.com/Forums/Topic837385-338-1.aspx
Sounds like a riddle - are you plucking petals from a flower as you count the ways? ...
December 21, 2009 at 1:04 pm
Try this:
select
ID,
case when isnull(Date1,0) < isnull(Date2,0) then Date2 else Date1 end as TheDate
from
dbo.mytable;
December 21, 2009 at 1:00 pm
Jack Corbett (12/21/2009)
YOu could use the second suggestion, have a GMT offset column that is tinyint. So if your offset is 5 (EST) you'd...
December 21, 2009 at 12:56 pm
Viewing 15 posts - 17,776 through 17,790 (of 26,489 total)