Matt Cherwin (1/28/2009)

---

The one bright side to this is it helps support my position that all SQL Server instances in the firm should at least fall under my purview in...

You need to take shorter lunch breaks. 😀

SELECT * FROM TableName

Do you have a clean backup? One without the corruption?

If you do, then you can...

Why don't you use temp tables? Then there's no worries about locking (only your process has access) and you don't need to worry about dynamic names.

In the future, please post...

I'm not sure what you're asking. Could you give more detail please?

Are you asking for the reasons why we might create a clustered index or a nonclustered index?

Why, oh why are you still helping him?

Steve Jones - Editor (1/28/2009)[hr "whether its transaction log backups, and XML indexes or whizbang fiber-optic laser beam assemblers." that were copied word for word, and these aren't phrases you...

Basically what happened there is that you had transactional replication set up (somehow), but the log reader wasn't running and never had run. Hence tran log entries that were marked...

clperez271172 (1/28/2009)

---

select sj.name, dts.name, command,sj.date_modified,sjd.last_run_date

from msdb..sysjobs sj

join msdb..sysjobsteps sjs on sj.job_id = sjs.job_id

join msdb..sysjobservers sjd on sjs.job_id =sjd.job_id

LEFT OUTER JOIN msdb..sysdtspackages dts on sjs.command LIKE '%'+cast(id as varchar(100))+'%'

where command like...

One difference is in the reusability of the plans.

With ad-hoc sql, the text has to match precisely (including whitespace) before an existing plan will be reused. The following two generate...

smeet.sinha (1/28/2009)

---

Don't u think that would be great if Microsoft would have considered this.

What are the underlying issues with the MS SQL architecture i dont know. But that would be...

DBADave (1/28/2009)

---

If I understand plan cache (and I still may be missing some things), the formulas above pertain to how SQL Server determines at what level plan cache will be...

If you'd said in your...

That link's got nothing to do with index algorithms. It's talking about how the execution plan shows a clustered index seek.

Try these two:

Clustered...