Viewing 15 posts - 42,991 through 43,005 (of 49,552 total)
Bear in mind that a san doesn't automatically make things fast. To quote a friend, 'There's no magic san dust'
Even with a san (or especially with a san) you need...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2008 at 9:46 am
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2008 at 12:32 am
Try jumpstart TV. They should have something.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2008 at 6:59 pm
Viewing 15 posts - 42,991 through 43,005 (of 49,552 total)