Viewing 15 posts - 631 through 645 (of 2,463 total)
GilaMonster (12/27/2012)
Bhuvnesh (12/27/2012)
what i think is optimizer will take time to generate plan regardless of time boundation.You would be thinking incorrectly then. Google: optimiser 'reason for early termination'
will this...
December 27, 2012 at 5:04 am
Check the sql error log too
December 27, 2012 at 2:49 am
GilaMonster (12/26/2012)
The optimiser is not allowed (in most cases) to spend minutes optimising a query.
Not allowed means? what i think is optimizer will take time to generate plan...
December 27, 2012 at 2:42 am
It looks like somebody had played with it. have anybody changed its path ?
post its result
use tempdb
go
sp_helpfile
go
you need to ensure the underlying file or file path for...
December 27, 2012 at 2:37 am
Saggy (12/26/2012)
Logshipping , Mirroring and Replication operate at which level sql server instance level or database level
database level
Saggy (12/26/2012)
December 27, 2012 at 2:31 am
one for thing , i cant tell how it will behave from performance perspective.
December 27, 2012 at 2:27 am
you need to create an metadata table (say... customer_id, table name , column_name )which wil contain column list per customer level (assuming every customer will have definite columns list )...
December 27, 2012 at 2:26 am
CELKO (12/26/2012)
FROM (SELECT order_nbr FROM Orders
EXCEPT
SELECT order_nbr FROM Order_details)
...
December 26, 2012 at 11:57 pm
Apology as i had hours-longed lunch 😛 .
Bhuvnesh (12/26/2012)
i will come back on this after my lunch again (may be with some stats 😀 )
So i did the test...
December 26, 2012 at 11:46 pm
David Benoit (11/30/2012)
We deploy database changes separately from code changes and allow for a layer of abstraction.
For this we have started using ALTER TABLE approach insead of TMP..INSERT approach...
December 26, 2012 at 4:17 am
Eric M Russell (11/13/2012)
Practically all of the really large databases I've worked with in the past could have benefitted from better normalization and data type usage.
on the contrary ,...
December 26, 2012 at 4:06 am
this is elementary example of "difference between not exists and left join with null filter" so i dont think you will get any kind of difference in "execution plan"...
December 26, 2012 at 1:38 am
Golfer22 (12/25/2012)
Does sys.dm_db_missing_index_details have information that results in "missing indexes" from ad hoc queries that have been ran once?
Also check About the Missing Indexes Feature.
December 26, 2012 at 12:40 am
Golfer22 (12/25/2012)
Even though the resource database is read-only, it is updated by SQL Server, right?
Yes
Golfer22 (12/25/2012)
December 26, 2012 at 12:36 am
Viewing 15 posts - 631 through 645 (of 2,463 total)