Viewing 15 posts - 43,426 through 43,440 (of 49,571 total)
😀
GOs break batches and hence variables declared before will be out of scope afterwards.
October 31, 2008 at 8:05 am
And if you're not learning from books, mentors or others when you are the senior DBA then either you know everything (which is unlikely) or you think you know everything.
The...
October 31, 2008 at 8:04 am
Garadin (10/31/2008)
Syntax issue.Use this instead:
select id, name, changedatefrom table1
where changedate > GETDATE()-5
Beware of the time portion of dates. That, if run now, would miss any entries with a time before...
October 31, 2008 at 8:02 am
The where clause must be a condition that returns true or false. Your is not. changedate-5 is simply a value, it's not a condition. It will return a date 5...
October 31, 2008 at 7:58 am
yulichka (10/31/2008)
recovery interval (min)03276700allow updates0100
.....
What's the question?
October 31, 2008 at 7:50 am
Jack Corbett (10/31/2008)
GilaMonster (10/31/2008)
I'll put the suggestion on the list. Currently I'm contemplating an article 'Help, my database is corrupt, what do I do?'
Pray your backups are good and restore?...
October 31, 2008 at 7:47 am
Can you fix the wrapping please?
Does creating the proc give the error, or running it?
I can create that without error on SQL 2008. Are you sure that's exactly what you're...
October 31, 2008 at 7:43 am
Jack Corbett (10/31/2008)
Very nice article Gail. Clear, concise, and to the point. Sounds like a follow-up on how the checkpoint and lazy writer work would be good.
Thanks. Glad...
October 31, 2008 at 7:36 am
Bob Bridges (10/31/2008)
October 31, 2008 at 7:35 am
Karrasko's Co. (10/31/2008)
What do you think about this method?
I think it won't do what you think it will. If you truncate the transaction log then you can neither take a...
October 31, 2008 at 7:33 am
Luke L (10/31/2008)
October 31, 2008 at 7:22 am
Chirag (10/31/2008)
Thank you Gail. That explains things clearly. So would the same apply to BLOB data. Would BLOB data be brought into memory and then modified?
Exactly the same. The query...
October 31, 2008 at 2:59 am
As far as I know, total is what it has and target is the value it's aiming for. If target is higher than total, then SQL will be acquiring more...
October 31, 2008 at 2:56 am
When the drive that they're on fails.
Model is not for DTS packages. Model is the template for creation of any other database (including tempDB when it gets recreated). MSDB is...
October 31, 2008 at 2:50 am
Books Online has a good section on what's new in 2005.
October 31, 2008 at 2:48 am
Viewing 15 posts - 43,426 through 43,440 (of 49,571 total)