Viewing 15 posts - 35,986 through 36,000 (of 49,558 total)
Heading home, finally. Wow, I'm tired after this week.
Offline til tuesday (flights, sleep, installing new ADSL equipment)
November 8, 2009 at 8:33 am
Take a full backup.
Why are you truncating and shrinking the log?
November 7, 2009 at 9:26 pm
Chandhini (11/7/2009)
I have 10,000 records in a table.What would be the degree (depth) of the B-tree?.
Not enough information. Depends on the definition of the index in question and the...
November 7, 2009 at 9:25 pm
jocampo (11/7/2009)
November 7, 2009 at 9:19 pm
Please read through this: http://www.sqlservercentral.com/articles/64582/
November 7, 2009 at 11:02 am
jocampo (11/7/2009)
we ran that on dev environment and I captured that info ...
How? If you pulled it later out of the plan cache it won't have the run-time information and...
November 7, 2009 at 10:55 am
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.
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...
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...
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...
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
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...
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...
November 6, 2009 at 2:53 pm
Parameter sniffing?
Stale statistics?
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...
November 6, 2009 at 12:21 pm
Viewing 15 posts - 35,986 through 36,000 (of 49,558 total)