Viewing 15 posts - 41,926 through 41,940 (of 49,562 total)
ALZDBA (1/7/2009)
However there may be a TEMPORARY bypass by using the startup parameter that has been provided for the "views with order by nolonger work" problem.
With one caveat:
From the kb...
January 7, 2009 at 12:56 am
You should leave those on unless you know exactly what turning them off will do, you're happy with the risks and you have some manual stats update job in place.
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
I...
January 7, 2009 at 12:14 am
Continued here - http://www.sqlservercentral.com/Forums/Topic631160-150-1.aspx
January 7, 2009 at 12:11 am
Bookmark lookups happen when SQL uses a nonclustered index to fetch rows and all of the columns that the query needs are not contained in the nonclustered index.
That clustering key...
January 7, 2009 at 12:05 am
tfifield (1/6/2009)
If all the data being fetched was in a covering index, would that guarantee the order?Todd Fifield
Once more with feeling...
The only way to absolutely guarantee an order is to...
January 7, 2009 at 12:02 am
Replication does not create indexes.
Please run the following for the table in question. What does it return?
SELECT object_name(id), name, INDEXPROPERTY(id, name, 'IsStatistics') FROM sysindexes
WHERE id = object_ID('Table Name')
January 7, 2009 at 12:01 am
madhu.arda (1/6/2009)
If I do DBCC TRACEON(1222,-1), the trace will be on for ever?
Until you turn it off (DBCC TRACEOFF(1222,-1)) or until the SQL service is restarted.
January 6, 2009 at 3:16 pm
Continued here - http://www.sqlservercentral.com/Forums/Topic630987-169-1.aspx
No more replies to this thread please.
January 6, 2009 at 2:53 pm
markmeiller (1/6/2009)
January 6, 2009 at 2:51 pm
This might help you
http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/
If you want to ensure that the data inserted has no time, you'll either need a trigger (which is the more complex and probably slower route), or...
January 6, 2009 at 2:44 pm
Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
The Information schema exists in 2000 as...
January 6, 2009 at 1:42 pm
A view doesn't store data. It's just a saved SQL statement. So, when you change the data in the table, it will immediately reflect in the view, just as it...
January 6, 2009 at 1:41 pm
GSquared (1/6/2009)
January 6, 2009 at 1:38 pm
madhu.arda (1/6/2009)
we need to add this trace file in sartup parameters in configuration manager or there is another way to do it?
DBCC TRACEON(1222,-1)
and I did not add the trace 1204...
January 6, 2009 at 1:37 pm
Franco_1 (1/6/2009)
In SQL Server Management Studio query pane, I had to actually pass in string values for it to work,...
January 6, 2009 at 1:25 pm
Viewing 15 posts - 41,926 through 41,940 (of 49,562 total)