Viewing 15 posts - 43,246 through 43,260 (of 49,569 total)
I would strongly suggest that you schedule the log backups to run at a regular interval (hourly is good) rather than basing it on the log's file size. The point...
November 10, 2008 at 11:25 am
Karl Klingler (11/7/2008)
let's say you
rename the old log file,
then restore the db, diff and log backups
stop sql server
rename the new log file
rename the old log file to its...
November 10, 2008 at 11:22 am
Patrick Russell (11/10/2008)
November 10, 2008 at 10:43 am
Marker (11/10/2008)
November 10, 2008 at 10:33 am
Lynn Pettis (11/10/2008)
Knowing Gail, I'm sure she has the queries you need to identify long running transactions. I'd have to do some research for those.
On SQL 2000 the only...
November 10, 2008 at 10:29 am
Garadin (11/10/2008)
Correlated subqueries CAN (I believe the optimizer sometimes converts them to joins / derived tables for you) be run Row by Row, which is very slow.
More correctly,...
November 10, 2008 at 10:28 am
Loner (11/10/2008)
The tempdb is set to automatically grow by 10% and unrestricted file grow.
What's the initial size? If you're using TempDB heavily, it must be changed from the default (2MB?)...
November 10, 2008 at 9:46 am
Firstly, read through these two articles:
http://www.sqlservercentral.com/articles/64582/
http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
What recovery model is this DB in (I'm guessing full) and how often do you backup the transaction log?
What is considered acceptable data loss for...
November 10, 2008 at 9:38 am
Can you post the query, the table with index definitions and the execution plan without the hint (saved as a .sqlplan file, zipped and attached to your post.)
November 10, 2008 at 9:27 am
See if you can open the file in a text editor. I've seen MySQL 'backups' in the past been nothing more than scripts to create and populate the DB. They...
November 10, 2008 at 9:26 am
TheSQLGuru (11/10/2008)
Gail, your index choices and join choices were 'too good'! 🙂
I was trying to see how many sorts I could get in a single query. Answer,...
November 10, 2008 at 9:15 am
Seeing the code makes all the difference. It's not technically parameter sniffing.
That form of catch-all query does not perform well. Firstly the optimiser can't make accurate predictions with all of...
November 10, 2008 at 9:13 am
Patrick Russell (11/7/2008)
November 10, 2008 at 6:22 am
Any indexes on those tables?
Is the distinct necessary?
November 10, 2008 at 6:20 am
Viewing 15 posts - 43,246 through 43,260 (of 49,569 total)