Viewing 15 posts - 15,046 through 15,060 (of 49,552 total)
It's whereever the SQL Server binary files (exe and dlls) are.
Why?
December 29, 2012 at 2:13 am
You may be interested to know that SQL Azure (or whatever it's called this week), does not allow heaps.
December 29, 2012 at 2:11 am
hakim.ali (12/28/2012)
If it were an index, then why would the database scan every record in a heap when you were searching for something?
SQL only scans if you haven't got...
December 28, 2012 at 12:48 pm
patrickmcginnis59 (12/28/2012)
GilaMonster (12/28/2012)
patrickmcginnis59 (12/28/2012)
I suspect theres a mechanism already in place to efficiently index a heap, ie., whatever passes for the row id.
The RID is nothing more than an...
December 28, 2012 at 12:47 pm
patrickmcginnis59 (12/28/2012)
I suspect theres a mechanism already in place to efficiently index a heap, ie., whatever passes for the row id.
The RID is nothing more than an 8-byte combination...
December 28, 2012 at 12:10 pm
Test them and see?
Alternately, maybe ask on an Oracle forum where you're more likely to get an answer.
December 28, 2012 at 3:50 am
sqlnaive (12/28/2012)
Apart from that I've used DBCC SHOWCONTIG and DBCC INDEXDEFRAG as and when required.
Both of those were deprecated 7 years ago, are included only for backward compatibility with SQL...
December 28, 2012 at 3:39 am
Don't fuss with the way SQL stores data. It's not your decision, it's up to the database engine (its one of the requirements of a relational database system)
With larger tables,...
December 28, 2012 at 2:20 am
Bhuvnesh (12/28/2012)
So here the chosen plan is the stored plan (stored at the time of previous runs) ?
Huh? I already said that the optimiser will not return the previous cached...
December 28, 2012 at 2:17 am
Error's pretty clear. When using a union, intersect or except all the queries must have the same number of columns
December 27, 2012 at 11:06 am
hakim.ali (12/27/2012)
December 27, 2012 at 10:30 am
tz.bahrami (12/27/2012)
And for nested relationships can we define an attribute as OId and use it in a select query...
December 27, 2012 at 10:08 am
ALTER VIEW <view name>
AS
<select statement here>
GO
December 27, 2012 at 10:05 am
hakkie42 (12/24/2012)
Ok, so in other words you're saying a clustered index means that the physical data is stored in index order, so e.g. binary searches are possible.
Actually not. That's not...
December 27, 2012 at 5:44 am
Bhuvnesh (12/27/2012)
will this option also return value when first time exec plan get created ?
Yes
is this option gives the value of 'reason for early termination' when query...
December 27, 2012 at 5:13 am
Viewing 15 posts - 15,046 through 15,060 (of 49,552 total)