Viewing 15 posts - 7,366 through 7,380 (of 7,597 total)
written an SP that uses a table that doesn't exist
I think your best chance is to try the following DMVs:
sys.dm_sql_referenced_entities
sys.dm_sql_referencing_entities
Other than that, I don't of anything else within SQL...
June 18, 2012 at 10:39 am
wonder why this isn't tracked in the catalog.
I suspect it was to keep down overhead.
MS could theoretically have logged tons of things like that in SQL, which would be...
June 18, 2012 at 10:33 am
UPDATE #Worked
SET
Tag = 1,
@UseIt = A.Student
FROM #Worked A (UPDLOCK)
INNER JOIN
(
SELECT TOP...
June 14, 2012 at 12:44 pm
Typically non-clustered indexes are not needed here, since you specify columnA in (virtually) all queries, in a reasonably narrow range.
Of course sometimes they do help specific queries, so you could...
June 14, 2012 at 9:10 am
Why not just add a column in the table for the "old" id column?
It's only 4 more bytes, and you'd then be able to reference that column in...
June 13, 2012 at 4:48 pm
Cluster by columnA (date/datetime) only.
That will keep the clustering key short but still restrict the number of rows a query must read and evaluate.
Sometimes additional column(s) are appropriate for the...
June 13, 2012 at 4:40 pm
I wouldn't expect it to change the space available at all, so I'm guessing other activity reduced the space available in the table.
Just to be sure, you did use an...
June 11, 2012 at 12:22 pm
I'm not horribly against the idea of dropping the FK, but maybe I'm not fully understanding the advantage of doing so. How does deleting the parent records first improve performance?
It's...
June 8, 2012 at 2:26 pm
Then why even have the constraint at all then. If all inserts/updates and deletes are done under controlled access methods (ie SPs) and ad-hoc access to the database is not...
June 8, 2012 at 12:23 pm
Might not be a good idea if inserts are expected while also doing the deletes.
Perhaps, if you really normally do INSERTs that would violate the constraint. Hopefully that's extremely...
June 8, 2012 at 9:40 am
I think the point sturner was making was that your order of deletion would violate the foreign key constraint.
That's a good point; yes, I wasn't sure if indeed such a...
June 8, 2012 at 9:28 am
Should I be looking at tuning the fill factor in this situation? Higher or lower than "stock"?
Yes, it can be very applicable to non-clus indexes.
You would lower the fillfactor,...
June 8, 2012 at 9:25 am
That wouldn't work if there were FK from the license_message_value table id --> license_message table.
I reversed the order of the table deletes for performance. By doing the controlling (in...
June 7, 2012 at 8:12 am
If I understand correctly, the license_message table has a:
clus index (/PK) on license_message_id
nonclus index on archive_date
<other nonclus...
June 6, 2012 at 3:44 pm
Here's my version (everybody's got their own version :-)). It provides MB totals for each table, each table and all its indexes, total number of indexes per table and...
June 5, 2012 at 10:43 am
Viewing 15 posts - 7,366 through 7,380 (of 7,597 total)