Topics
Started by
Posts
Last post
Hi guys, I'm checking sys.dm_db_index_usage_stats with the script below to find unused and rarley u…
5 replies
if we have two table A(colA1,colA2,colA3) and B(colB1,colB2,colB3) table A join with B colA1=colB2 …
8 replies
Hello Everyone, I have got this Sql View that is running slowly. It takes two(2) hours or more to r…
17 replies
Hi guys! I tried looking for missing index and I used this query: select * from sys.dm_db_missing_…
5 replies
I had a sql statement which ran on a hefty sql 2005 box at a remote location that looks at some dat…
10 replies
Let say I have two tables, TableA, Col1(P) Col2 TableB, Col3(P) Col1(F) Col4 Which one of the follo…
4 replies
I have Db table containing following number of records, Table data, BusinessData bdf = 13335713 Sub…
32 replies
Hi Friends, I have problem with window application. i want to develope the window app…
1 replies
Hi all I have a stored procedure that uses a cursor based on a set of clientid's. It's currently d…
5 replies
Here is the part of the query that it taking too long (temp tables involved run in few seconds whic…
10 replies
2 replies
Hello, I have a query that I run against a View to get product Sellers and count of products for ea…
11 replies
My new company has a vendor app that is having major blocking problems. I arrived at the new job …
9 replies
Hi All, is there a way to identify which queries actually use a specific index? I have a table with…
1 replies
Hi, Currently, we have 25GB database in PROD with 150+ tables. But, there are few tables (say 5 - 1…
1 replies
Viewing 15 topics - 901 through 915 (of 3,249 total)
You must be logged in to create new topics.