Viewing 15 posts - 61 through 75 (of 154 total)
sorry, my sql server is 2008 R2
December 9, 2020 at 1:48 am
1. Not generally available. If an index was created by adding a PRIMARY KEY constraint, sys.objects would have the create time of that index.
2. Yes. For example: SELECT t.name...
December 9, 2020 at 1:38 am
This may get you some of what you want.
SELECT
SS.name SchemaName,
ST.name TableName,
ISNULL(SI.name, '') IndexName,
SI.type_desc IndexType,
IUS.user_updates,
IUS.user_seeks,
IUS.user_scans,
IUS.user_lookups,
SSI.rowcnt,
SSI.rowmodctr,
IUS.last_user_seek,
IUS.last_user_scan,...
December 9, 2020 at 1:01 am
Ant-Green , Thank you for your kind help!
December 8, 2020 at 9:14 am
well noted, thank you Ant-Green!
December 8, 2020 at 3:43 am
The things you mention don't typically cause the crazy increase you speak of. And I just told you a "good way" to find it so someone can...
December 1, 2020 at 1:11 am
The things you mention don't typically cause the crazy increase you speak of. And I just told you a "good way" to find it so someone can fix it....
November 30, 2020 at 2:49 am
Crazy increases in size are normally due to a query that has one or more "accidental Cross Joins" in the form of "Many-to-Many" results. They typically contain a DISTINCT...
November 30, 2020 at 12:53 am
For best overall performance, it's extremely likely that you need to change the clustering index on the table to be ( OrderID, ItemID ). Especially if the table is...
November 27, 2020 at 6:31 am
I think I can help with that one.
IDX1 would have the 3 columns with the data ordered by OrderID, then ItemID, and finally Status. If there were more columns...
November 27, 2020 at 4:51 am
Yes, you can drop IDX1; IDX12 can cover all queries that would use IDX1.
thank you !
if I create the following on the table , could you please tell the...
November 26, 2020 at 12:38 pm
Waiting for locks is normal in SQL Server (or any other relational db).
Whether the waits are excessive is a different q.
Since you've provided no details, to reduce bad effects...
November 19, 2020 at 12:58 am
Locks are a required part of SQL Server. You wouldn't want 2 queries updating a single piece of data at the exact same time. Much better for them to...
November 19, 2020 at 12:46 am
Thank you Adi Cohn for your kind help!
November 16, 2020 at 1:16 pm
It will show you details only on plans that exist in the query cache. As soon as a query plan is being deleted from the query plan, you won't...
November 16, 2020 at 12:30 am
Viewing 15 posts - 61 through 75 (of 154 total)