Viewing 15 posts - 32,566 through 32,580 (of 39,740 total)
I think that still requires the space for the log to be created.
February 5, 2007 at 7:17 am
The * in "select *" actually gets resolved to particular columns when the view is created. It is not then bound to the table. Any changes to the table will...
February 5, 2007 at 7:10 am
Passport has other problems. Namely it's run by Microsoft, a software company, not a bank, and it didn't hide your information unless you gave it to Microsoft.
What I think would...
February 5, 2007 at 7:08 am
One good thing is I have seen that Google and Amazon have offered to help fund the search and send bodies to help. They also have people trying to analyze...
February 1, 2007 at 4:36 pm
When you change the system clock, it's within a moment that SQL Server makes the change internally. I'm not sure about users being unable to connect. I know I've done...
February 1, 2007 at 9:23 am
Jereme,
Thanks and yes. It's been corrected.
Also, the CG is calling off the search. A sad day.
January 31, 2007 at 5:56 pm
Mike you are correct, writers keep copyright and we ask for 90 days exclusive, but we don't come after you if you don't wait 90 days.
The line above is a...
January 31, 2007 at 9:31 am
He posts over here: http://blogs.msdn.com/psssql/
January 31, 2007 at 9:29 am
If you plan on contracting, all the references you can give will help. A $125 investment that lands you a couple hours work is worthwhile. Does this get you close...
January 31, 2007 at 9:28 am
Most people that answer actually see the changed threads, rather than checking all forums, so cross posting doesn't really help.
January 31, 2007 at 9:16 am
Depends on your server, but batches (if possible) allow you to commit sections of changes. If something happens with the transaction, like log filling, the whole thing rolls back.
I've often...
January 31, 2007 at 9:15 am
Go to teh server and check to see what the error log shows. It sounds like your server restarted and the database is rolling forward.
Chances are it's done by now.
January 31, 2007 at 9:14 am
A third party tool will allow you to generate the reversing entry if you still have the logs from a few days ago.
The problem is that other things outside the...
January 31, 2007 at 7:42 am
The problem is that you need to know the total # of columns to get the CASE to work properly. Or you have to cover all bases, like
select
CASE hour
WHEN...
January 31, 2007 at 7:40 am
Without seeing the code it's hard to know what is causing the delays. If there's lots of data, especially not indexed, it could be slow.
I'm not sure I'd do a...
January 31, 2007 at 7:36 am
Viewing 15 posts - 32,566 through 32,580 (of 39,740 total)