Viewing 15 posts - 631 through 645 (of 2,462 total)
Check the sql error log too
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2012 at 2:31 am
one for thing , i cant tell how it will behave from performance perspective.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 )...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 27, 2012 at 2:26 am
CELKO (12/26/2012)
FROM (SELECT order_nbr FROM Orders
EXCEPT
SELECT order_nbr FROM Order_details)
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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"...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 26, 2012 at 1:38 am
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 26, 2012 at 12:56 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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 26, 2012 at 12:36 am
Is this a existing exec plan OR you created new one ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 26, 2012 at 12:31 am
Viewing 15 posts - 631 through 645 (of 2,462 total)