Viewing 15 posts - 46,291 through 46,305 (of 49,552 total)
It's how scalar functions show up in exec plans. Very irritating.
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
June 4, 2008 at 2:32 am
Please post the code of the view, the table and index definitions and the execution plan (in xml formal, zipped and attached to a post)
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
June 4, 2008 at 2:30 am
Change your app so that it does use stored procedures and restrict table access. You can check for key words, but it's not a sure thing. There are ways 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
June 3, 2008 at 6:52 am
One example he gave to me a while back on this subject concerned TOP and ROWCOUNT.
UDFs are my pet peeve in execution plans at the moment. I wish there was...
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
June 3, 2008 at 6:42 am
How many rows do the 2 queries return?
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
June 3, 2008 at 5:51 am
I've seen cases where the batch % is way off, but IME it hasn't been the norm. Maybe I'm just working with simpler queries
Generally I've found that odd joins (cross...
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
June 3, 2008 at 5:44 am
SQL Server Performance Tuning Distilled (by Sajal Dam) is a good book. It's for SQL 2000, not 2005, but is still a very worth while read. The principles of good...
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
June 3, 2008 at 5:37 am
Run a checkDB on that database, see if you have any other errors. How old is your most recent backup?
You said the databases were fine after the move off 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
June 3, 2008 at 4:51 am
george sibbald (6/3/2008)
so surely /3Gb switch ok up to 16GB RAM, remove for anything over that.:)
Nope. Even under 16GB you risk starving the kernal of memory.
Personally I would not...
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
June 3, 2008 at 1:28 am
Make sure the app is pointing at the right database.
Make sure that you don't have 2 copies of the procedure in different schemas
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
June 3, 2008 at 12:32 am
Select into isn't limited to coming from a single table. Imagine something like this (example from BOL)
SELECT c.FirstName, c.LastName, e.Title, a.AddressLine1, a.City, sp.Name AS Province, a.PostalCode
INTO dbo.EmployeeAddresses
FROM Person.Contact AS c
JOIN...
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
June 3, 2008 at 12:27 am
Profiler's not usually that heavy on a server, but it is a small load. Perhaps you could use server-side traces instead (Profiler will generate the scripts for you. Stick 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
June 3, 2008 at 12:14 am
Select ... into only creates and populates the table.
If you want indexes, constraints, primary key, triggers or anything else from the original table, you'll have to script them from...
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
June 3, 2008 at 12:11 am
Please don't cross post. You have an active topic for this question already.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic509461-9-1.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
June 3, 2008 at 12:09 am
Can you post the execution plan please, along with the table and index definitions? If you've ghanged the view please post the revised 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
June 3, 2008 at 12:06 am
Viewing 15 posts - 46,291 through 46,305 (of 49,552 total)