Viewing 8 posts - 1 through 8 (of 8 total)
That is a great suggestion too, Steven. By the way, is schema binding of views a feature that is specific to SQL Server, or do other SQL database types provide...
November 15, 2012 at 2:11 pm
Both of your answers make all kinds of sense (and even more so after I looked up what EAV and DRI stand for), and I wish I had thought of...
November 13, 2012 at 10:55 am
The database I am working with is part of a data warehouse made available for research teams, so there are some limits to what I can do with adding indexes...
September 7, 2012 at 7:13 pm
The .sqlplan files for the queries that I put in the first message are attached.
MainDocumentAndAddendaActualPlan.sqlplan is from the first query
MainDocumentAndDiagnosesActualPlan.sqlplan is from the second query
MainDocumentAddendaAndDiagnosesEstimatedPlan.sqlplan is from the third query
MainDocumentAndAddendaIntoTempTableActualPlan.sqlplan...
September 7, 2012 at 4:54 pm
The select statement without hints and the select statement without sorting or hints both ran slightly faster than the original one. The new query that you sent me ran a...
August 27, 2012 at 6:59 pm
I can't obtain the indexes and keys because I am working with a view to a table that I can't access. That view has 95 columns, and I am using...
August 27, 2012 at 1:33 pm
Here are two more query execution plans. SingleQueryExecutionPlanWithoutHints.sqlplan is the same query as before, but with the NoLock and FAST 1 hints removed. SingleQueryExecutionPlanWithDiagTempTable.sqlplan is for the requested query in...
August 27, 2012 at 1:21 pm
A couple of query execution plan files are attached. The one for the query I am using is called SingleQueryExecutionPlan.sqlplan. It shows 99% of the cost assigned to one sort...
August 25, 2012 at 10:35 pm
Viewing 8 posts - 1 through 8 (of 8 total)