Viewing 15 posts - 48,031 through 48,045 (of 49,552 total)
I've found table variables fine for <10 rows of data. Past that the lack of statistics and resulting poor cardinality estimate tends to stuff up the optimiser ten ways 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
December 14, 2007 at 9:01 am
If you look at the execution plan for that query, do you see an index scan or an index seek for the table INFO_LOG?
Edit: Looked a little closer
That's a rather...
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
December 14, 2007 at 8:58 am
Fortunately for my server (I found that in production), the data was such that the resulting string always was >7600 characters by that point.
Char/varchar aside, what's wrong with the SPACE...
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
December 13, 2007 at 11:26 am
Megha Yadav (12/13/2007)
TheSQLGuru (12/13/2007)
Do not use FASTFIRSTROW hint on a Primary Key access.But why do u say so ????
Because it's not necessary. If you're filtering with an equality on 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
December 13, 2007 at 10:55 am
icampbell (12/13/2007)
The view is not created from the table,The table is created from the view.
So what's view based on? Another table? Several tables?
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
December 13, 2007 at 10:34 am
Jeff Moden (12/13/2007)
Jeff, may I send that to my boss?
Sure... in fact, I'm honored :blush:.
Replied via PM. I don't want to hog this thread any more than 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
December 13, 2007 at 10:27 am
Grant, that's seriously impressive. How anyone can debug that for more than 2 min, I don't know.
Seeing Grant's reminded me of this little time bomb I found a couple years...
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
December 13, 2007 at 10:16 am
Please don't cross post. It fragments answers and wastes people's time. If you posted in the wrong forum, you should be able to delete the thread.
Continue here
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
December 13, 2007 at 5:05 am
Jeff, may I send that to my boss?
I've got a meeting with my boss on Monday. Will see what comes out of it. If it's OK, I'll drop you 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
December 13, 2007 at 1:51 am
The two are equivalent, but you should convert to the inner join format. The old style joins are deprecated in SQL 2005 and will not work in future editions.
Regarding 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
December 13, 2007 at 1:32 am
It doesn't usually matter which one was the victim when it comes to resolving deadlocks.
To stop them happening, you'll likely have to look at the code that 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
December 13, 2007 at 1:18 am
One of the best I saw at a previous company.
SELECT ... FROM SomeTable WHERE SomeColumn = @var and Status = 1 or status = 2
Just like that, no brackets. Even...
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
December 13, 2007 at 1:08 am
What error do you get?
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
December 13, 2007 at 12:49 am
Megha Yadav (12/12/2007)[hr
In this case the @tempUserID is being used in the next few queries. In this case there will be not even the seemingly less response time Am...
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
December 12, 2007 at 6:11 am
Generally statistics are automatically updated by SQL server. The only time it's necessary to update them manually is when the auto update is disabled (which it should never be) or...
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
December 12, 2007 at 5:59 am
Viewing 15 posts - 48,031 through 48,045 (of 49,552 total)