Viewing 15 posts - 17,296 through 17,310 (of 49,552 total)
There are still some spelling mistakes and strange grammar in there.
"Experience monitoring and fine-tuning SQL Server system performance."
Should be
"Experienced in monitoring and fine-tuning SQL Server system performance."
"Prepare for and upgrade...
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
July 31, 2012 at 7:10 pm
Depends. Why are you considering partitioning?
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
July 31, 2012 at 6:59 pm
Obtain from somewhere a list of all banks (another database, government info, etc), then use SSIS fuzzy lookup.
Without that list of all banks, that's impossible to solve automatically. How would...
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
July 31, 2012 at 4:33 pm
Books Online -> extended events, or read over Jonathan Kehayias's blog
A very quick google search turned up:
http://msdn.microsoft.com/en-us/library/bb630282.aspx
http://msdn.microsoft.com/en-us/library/dd822788%28v=sql.100%29.aspx
and of particular relevance
http://www.sqlskills.com/BLOGS/PAUL/post/Getting-historical-deadlock-info-using-extended-events.aspx
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
July 31, 2012 at 3:14 pm
No need for a trace. On SQL 2008 deadlock graphs are written into the extended events system health session.
Post the deadlock graph here, we can give you some suggestions 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
July 31, 2012 at 3:03 pm
Update in chunks, maybe 50 000 rows at a time.
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
July 31, 2012 at 2:40 pm
GilaMonster (7/31/2012)
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
July 31, 2012 at 2:40 pm
Jayanth_Kurup (7/31/2012)
If you have the option you should plan for a piece meal restore.
How is that going to save on recovery time? Or total time to restore the entire database?
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
July 31, 2012 at 2:39 pm
You'll just have to wait. Most likely the log is severely fragmented (lots of VLFs) and the recovery portion of the restore takes forever as a result.
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
July 31, 2012 at 2:13 pm
Indianrock (7/31/2012)
WHILE (1 = 1)
BEGIN
BEGIN TRANSACTION
UPDATE TOP (1000) [Order Details]
SET ...
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
July 31, 2012 at 2:12 pm
Evil Kraig F (7/31/2012)
Ugh, sick for a week blows. I miss anything of import since last Tuesday?
Vacation! Mine! (no, you're not invited 🙂 )
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
July 31, 2012 at 2:10 pm
Premature optimisation is the process of making design decisions or modifications based on assumed performance improvement without testing, benchmarking and verifying the change.
"Foreign keys are slow so I won't create...
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
July 31, 2012 at 2:04 pm
sestell1 (7/31/2012)
Setting the database to SIMPLE recovery model will minimize the amount of logging done
Won't help here. Updates are fully logged in all recovery models. A single update uses the...
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
July 31, 2012 at 2:00 pm
What was the exact restore statement that you ran?
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
July 31, 2012 at 1:49 pm
If you don't mind the database being transactionally inconsistent at best, completely inaccessible at worst, sure, go right ahead. Just make sure you have backups because you will run into...
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
July 31, 2012 at 1:49 pm
Viewing 15 posts - 17,296 through 17,310 (of 49,552 total)