Viewing 15 posts - 43,006 through 43,020 (of 49,566 total)
Amit Gupta (11/20/2008)
You should delete log file 1st then backup and then restorehmmmmm....
No, no, no, no!
The transaction log is not an optional file that can be deleted without causing problems....
November 23, 2008 at 9:43 am
Grant Fritchey (11/23/2008)
Actually, pretty desperate, the deadlock chapter comes up in two weeks! You may see me attempting to answer a few of the deadlock posts as they come up.
If...
November 23, 2008 at 9:36 am
Grant Fritchey (11/23/2008)
Actually, I'm feeling a bit snarky this morning. I'll finish my comments over there.
Likewise, as my reply to the thread Jeff called out shows. I'll blame it on...
November 23, 2008 at 9:31 am
When a checkpoint occurs or when the lazy writer kicks in due to memory pressure. It could be immediately after the change was made, or it could be several minutes...
November 23, 2008 at 12:43 am
No, I can't.
The optimiser's changed so queries the previously ran in one way may run in another way after upgrade. Sometimes that causes errors like conversion. There's no way to...
November 23, 2008 at 12:32 am
Try jumpstart TV. They should have something.
November 22, 2008 at 11:53 pm
Why? What purpose are you trying to get that information for?
If you don't need it exact, query sys.dm_db_index_physical_stats for that table, use the detailed option, check the avg_record_size_in_bytes column and...
November 22, 2008 at 11:47 pm
You should not be using the profiler gui to monitor a busy production server. Especially not very frequent events like the lock aquired. At best you'll kill your machine, at...
November 22, 2008 at 11:37 pm
Jeff Moden (11/22/2008)
Is that true, Gail? Is there a book out there with your good name in it as a co-author?
Co-author, no. I've contributed to a book project, that's...
November 22, 2008 at 11:22 pm
Queries that work on 2000 but throw errors on 2005, either due to syntax that's now invalid or changes to the optimiser is the main one I've seen.
Another fun one...
November 22, 2008 at 11:21 pm
Have you run the upgrade advisor? Has it found any potential problems? Have you tested your app and database completely on SQL 2005?
November 22, 2008 at 11:04 pm
A general network error means that the connection has been suddenly and forcefully closed, and not by the application. Basically, the app tries to communicate over a channel that no...
November 22, 2008 at 7:15 pm
In 2005, the options are a comma-delinited list or an xml document or similar. Messy, I know. In 2008 you can use a table-valued parameter.
November 22, 2008 at 7:05 pm
Jack Corbett (11/22/2008)
That would be great to have. Certainly will reduce my time on-line. Look forward to seeing it somewhere.
I didn't write it. I found it somewhere online. Can't...
November 22, 2008 at 6:59 pm
Jeff Moden (11/22/2008)
But none of us has written a book like some of the good folks we know. 😉
And he's writing another one. A full, published dead-tree book...
November 22, 2008 at 6:14 pm
Viewing 15 posts - 43,006 through 43,020 (of 49,566 total)