Well, you might not be able to, but if you use a stored procedure and match the parameters to the columns in terms of data type, you should be able...

But, you really don't want to shrink your log over & over. If you had one abnormal set of transactions that caused it to grow, maybe, but if it's because...

WayneS (9/30/2010)

---

Craig Farrell (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

Grant Fritchey (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

WayneS (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

GilaMonster (9/30/2010)

---

The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his...

pshaship (9/30/2010)

---

Hi,

I'm analyzing when exactly we required to perform Index defrag (Index reorg/rebuild) in SQL Server 2005 and I come across the article at mssqltips.com

http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/03/09/custom-index-defrag-rebuild-procedures.aspx

which says:

Generally you should include...

CirquedeSQLeil (9/30/2010)

---

Grant Fritchey (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

WayneS (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

GilaMonster (9/30/2010)

---

The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project. Since neither...

CirquedeSQLeil (9/30/2010)

---

WayneS (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

GilaMonster (9/30/2010)

---

The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project. Since neither developer is full...

I won't try to dissect the paging stuff. There are smarter guys than I am around here who can do that. But, I will point this out:

Where XML.value('(//BillNumber)[1]', 'varchar(10)')...

I asked around and the consensus seems to be that, because of filtered indexes and sparse columns, the number of indexes in support of larger tables using these new constructs...

If it still doesn't work, post back here. I'll try to see if I can get it to work too.

I couldn't agree more with Joe on this one. You're really bashing your fingers with a hammer.

While there are situations where breaking up statements and using a temp table can...

Express12 (9/30/2010)

---

In SQL 2008, how can I get the "plan_handle" value listed below returned as a radable value? (the actual plan name value)?

select top 5

sum(qs.total_worker_time) as total_cpu_time,

sum(qs.execution_count)...

It sounds like the DTA is not connecting to the right database. That would explain why it's getting that error.

According the Microsoft rep here[/url], you should only see the GO statements where they're required. Is that not true? Have you tried testing the script generated?

CirquedeSQLeil (9/30/2010)

---

WayneS (9/30/2010)

---

If he's in his...

jackimo (9/30/2010)

---

Thanks Grant,

I do understand that and the fact is in some cases we'll have to do a full scan. Do you think that storing the message in a...