You might want to give the query below a try, although it will output a given row only once, even if it would have matched multiple conditions in the original...

Wow, that's a lot of used log space.

Make sure you are taking proper log backups and/or that you don't have an old...

For databases with a significant number of transactions, I would expect differential backups to speed up the restores somewhat. My reasoning is that applying tran logs requires that every...

What you really need to do first is add the best clustered index to both tables. Then and only then do you add other, non-clustered, covering indexes if they...

If there's a NULL in the "NOT IN" list, no rows will be excluded, so you may be seeing rows -- including without leading zeros -- that you didn't expect...

ALTER TRIGGER triggerDeleted

ON [table_name]

AFTER DELETE NOT FOR REPLICATION

AS

SET NOCOUNT ON;

DECLARE @sql nvarchar(max);

SET @sql = (SELECT

'EXEC [procedure_name] ' + CAST(ID AS varchar(10)) + ', '...

You're welcome! At least you don't need to change much of 3500 lines of code :-).

Sadly, you can't do that directly in SQL Server.

The only way to simulate that would be to use alias data types -- lots of aliases.

I think the issue may be that this format of query:

SELECT @variable = column FROM table WHERE ...

leaves the original value of @variable in place if a row is not...

Honestly, I'd probably kludge this one if possible.

See if you can add an optional flag as a parameter to the proc to indicate that the first result set is not...

Jeff Moden (6/6/2014)

---

rangu (6/6/2014)

---

Thanks Scott, for your valuable inputs and thoughts.

However I haven't got the answer yet, when exactly do we need to go for Table Partition and Page compression....

rangu (6/6/2014)

---

Thanks Scott, for your valuable inputs and thoughts.

However I haven't got the answer yet, when exactly do we need to go for Table Partition and Page compression. If this...

You can only have one clustered index, but the PK does not have to be the clustered index.

When time is available:

1) Drop the existing indexes (Edit: non-clustered first, clustered last)

2)...

Lynn Pettis (6/6/2014)

---

sqldriver (6/6/2014)

---

sql-lover (6/6/2014)

---

It is my understanding that an aggregate function has to check all values in the column. So an Index on that attribute may not help too...

Actually MIN() and MAX() could use an index, even a seek, if the index was keyed on all the GROUP BY columns in the proper order.