Viewing 15 posts - 33,106 through 33,120 (of 49,552 total)
Grant Fritchey (5/3/2010)
GilaMonster (5/3/2010)
Grant Fritchey (5/3/2010)
Also, having four completely different queries inside the IF statement pretty much guarantees you're likely to see recompiles.
Why? SQL won't recompile when a different branch...
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
May 3, 2010 at 8:44 am
Grant Fritchey (5/3/2010)
Also, having four completely different queries inside the IF statement pretty much guarantees you're likely to see recompiles.
Why? SQL won't recompile when a different branch is taken. It'll...
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
May 3, 2010 at 8:27 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Why do you have DropCleanBuffers at the beginning? Is that just there for performance testing?
You may also be running...
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
May 3, 2010 at 8:19 am
ankur003 (5/3/2010)
I just tested some SPs and found that after using NOLOCK the execution time of the queries reduced from 35 to 31 secs approx....
Means there's likely some blocking...
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
May 3, 2010 at 7:34 am
So why does the client want you to do it if they know that you know almost nothing about databases? Better to get someone in who does.
From your requirements, there'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
May 3, 2010 at 7:11 am
Blog post on rebuilding master - http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/rebuild-master-and-restore-system-databa
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
May 3, 2010 at 6:20 am
Rebuild the master database. It's an option of the 2005 setup tool. You will lose all logins and server level permissions, you'll have to reattach all user databases, you'll lose...
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
May 3, 2010 at 6:12 am
If the file header is damaged, the database cannot be opened. That's one of the things that there's no workaround for.
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
May 3, 2010 at 1:06 am
Unfortunately , working on thesis != relaxing. Still break from forums was good and needed.
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
May 2, 2010 at 10:03 am
I am. Took a complete break for 2 weeks, posting just a little now. Down to 100 posts a month (from 700)
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
May 2, 2010 at 9:41 am
Why are you using a cursor in the first place? They are slow, slower than set-based operations in the vast majority of cases.
I can see that this is test code....
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
May 2, 2010 at 9:32 am
http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.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
May 2, 2010 at 9:28 am
Depends on the company. They are not industry-wide definitions.
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
May 2, 2010 at 2:23 am
Indeed. And reading SQL's transaction log is a really odd thing to ask in a class exercise. If the exercise just asks you to track data changes, it's pretty unlikely...
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
May 1, 2010 at 6:35 am
Please post the current execution plan of the query with OR? I suspect it may have to do with covering and number of records as it looks like it should...
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
April 30, 2010 at 12:36 am
Viewing 15 posts - 33,106 through 33,120 (of 49,552 total)