Topics
Started by
Posts
Last post
Dear All, Is there a way to clear the missing index usage views. We worked during last period on in…
2 replies
create nonclustered index IX_ID on tbl1(col1,col2,col3) and create nonclustered index IX_ID on tbl1…
2 replies
Hi, For last one week (since a new application release), I have been seeing lot of SQL compilati…
3 replies
Ok, so I throw together some scripts to track down duplicate indexes. I found a few tables with dup…
3 replies
Folks, I could not find any material that answers my question. I have a very long query in which I …
1 replies
Ok, I have this stored procedure ALTER PROCEDURE [dbo].[TSL_CheckEmailAlreadyRegistered] -- The e…
3 replies
My team encountered one scenario, we created a SQL job via sql server agent to load data. And it is…
10 replies
Hi all, I've been trying to figure this one out for quite a while, but the query was always much to…
11 replies
I have a D drive and on this drive we only have all the mdf files. Every night at a certain time t…
5 replies
Here are the 3 steps i am running and final step is taking too long when trying to create a table a…
8 replies
We have 10 large 15 million+ row tables that all have 1 index(clustered) on a column called individ…
6 replies
Hi could anyone pls tell me the right blog for getting more information on index column order for …
1 replies
A system records a log record each time an email is sent by a user. We want to raise an alert when …
5 replies
I have a query, such as: Declare @From datetime, @To datetime Set @From = '2010-01-01' Set @To = '2…
22 replies
This was discussed a little bit on a different thread but I thought I'd present it here since I'm s…
25 replies
Viewing 15 topics - 1,126 through 1,140 (of 3,249 total)
You must be logged in to create new topics.