Viewing 15 posts - 35,986 through 36,000 (of 49,552 total)
CirquedeSQLeil (11/6/2009)
Now for some light reading over the weekend.
Light reading it ain't. I have 2 copies in my luggage, must weigh a couple kg in total.
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
November 6, 2009 at 11:03 pm
I don't understand what controls the rows that you want. Do you want the top 4 records, the top some other, unique values by some column, or something else.
Please read...
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
November 6, 2009 at 10:56 pm
Only if all other columns are part of aggregate expressions. The query you have there is not valid. This would be.
SELECT col1, max(col2), Max(col3)
FROM TableA
GROUP BY col1
Think about it. You're...
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
November 6, 2009 at 4:04 pm
Bob Hovious 24601 (11/6/2009)
I'm part of the group listening to Itzik Ben-Gan talk about tuning
Sitting in post-con on unstructured and semi-structured data. Currently discussing full-text search. Not overly interested...
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
November 6, 2009 at 3:58 pm
Take a look at this article, and the ones that will be published next week for info on indexes
http://www.sqlservercentral.com/articles/Indexing/68439/
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
November 6, 2009 at 3:57 pm
It's part of the internals of SQL that controls query execution. You don't use it directly. SQL does.
Please download books online, read through it and then ask any questions 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
November 6, 2009 at 2:55 pm
ramadesai108 (11/6/2009)
What do i need to check/uncheck in Execution plan to set Full Table Scan OFF?
LOL. Performance tuning would be easy if one could do that.
What he's suggesting you 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
November 6, 2009 at 2:53 pm
Parameter sniffing?
Stale statistics?
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
November 6, 2009 at 2:50 pm
Steve Jones - Editor (11/6/2009)
Grant, see if someone will post an NDA summary in the newsgroups. Would be nice for those of us stuck in the trees.
Mail Ed and ask...
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
November 6, 2009 at 12:21 pm
jocampo (11/6/2009)
Why a composite and not three different Indexes?
Because a 3-column index means that SQL can do a seek on all three columns in one go. 3 individual index means...
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
November 6, 2009 at 10:22 am
Look in the SQL error log.
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
November 6, 2009 at 10:07 am
jcrawf02 (11/6/2009)
Geek of the Week is too uppity to mingle in person, eh?:-P
His high eliteness is busy taking notes on the session content. 😉
It sounds from the blogging like there...
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
November 6, 2009 at 10:07 am
Excellent. 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
November 6, 2009 at 9:46 am
GSquared (11/6/2009)
If I'm not mistaken, PASS was Mon-Thu, right?
Mon-Fri. Main conference was Tues-Thurs, pre-con on monday, post-con on friday.
Grant says Hi.
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
November 6, 2009 at 9:45 am
Inner join, no. Left/right join, they're two different queries with two different results, so performance isn't the issue....
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
November 6, 2009 at 12:43 am
Viewing 15 posts - 35,986 through 36,000 (of 49,552 total)