Viewing 15 posts - 46,456 through 46,470 (of 49,552 total)
Slawek (5/21/2008)
You are definitely software ortodox 🙂
No, we've just done a fair bit of performance tuning in the past and know where the issues usually lie and where the improvements...
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 21, 2008 at 5:49 am
As far as I can see, aa is just an alias for the openXML in the first query. It won't last longer than the execution of the first query. Hence,...
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 21, 2008 at 2:38 am
Clustered indexes should (imho) be as narrow as possible. From what you've said, I'd second Jeff and go for a cluster on A on just the ID. You can 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
May 21, 2008 at 12:49 am
Create indexes after the bcp/Bulk insert. That way they won't interfere with the load, but will be present when you're querying the table later.
As always, test carefully to ensure that...
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 21, 2008 at 12:33 am
veenagireesha (5/20/2008)
But when I tried ti insert into records..It not convertedto uppecase at all...Isn't it possible this way ?
A default just sets the value of the column if 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
May 21, 2008 at 12:27 am
Jeff Moden (5/20/2008)
The bat I kept at my desk was the "hardware training aid".
I have one of them too, though it's a calendar mailing tube. A...
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 21, 2008 at 12:26 am
Glad to hear it.
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 21, 2008 at 12:23 am
Jeff Moden (5/20/2008)
Setup profiler to page, call, email, and throw rocks at the hardware team everytime a query takes longer than a certain time to execute... you sleep. 😛
Unfortunatly 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
May 21, 2008 at 12:23 am
What we're saying is that you should only do hardware fixes if you know it's a hardware bottleneck, and you've already optimised the queries as much as possible and tuned...
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 21, 2008 at 12:10 am
GSquared (5/20/2008)
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 20, 2008 at 12:57 pm
Can you post the execution plans please. You can right-click on the exec plan, save it as a .sqlplan file, zip and attach to the post. (assuming SQL 2005)
Somewhere I...
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 20, 2008 at 12:48 pm
That's a big proc... Hmmm...
Run it in the proc and as a query, and have a look at the execution plan of each, and the results of statistics IO.
Are...
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 20, 2008 at 12:13 pm
Marios Philippopoulos (5/20/2008)
Thank you for the response, that makes sense.
Don't these tables need their stats updated though, just like user tables?
I see that some of them have not been...
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 20, 2008 at 12:05 pm
I've seen that with web pages before. Very irritating.
With stored procs, as soon as the proc is modified, or any object that the proc depends on is modified, the cached...
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 20, 2008 at 11:55 am
Post the proc definition please.
I am thinking parameter sniffing....
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 20, 2008 at 11:46 am
Viewing 15 posts - 46,456 through 46,470 (of 49,552 total)