Ronnie_Doggart (10/1/2010)

---

No its a table:

CREATE TABLE [dbo].[IMPORTINSTVERSION](

[INSTANCEID] [numeric](18, 0) NOT NULL,

[IMPORTNAME] [varchar](50) NOT NULL,

[IMPORTBUNDLEID] [numeric](18, 0) NOT NULL

)

The procedure does not generate the exceptions on other customer databases, just with...

You're right. Is IMPORTINSTVERSION a UDF possibly?

It's odd that such a simple, straight-forward proc is getting cache misses. Unless I'm missing something, that should be sitting in cache waiting for...

That's basically a hardware issue and means that your processors are maxed out. In terms of waits to monitor for a situation like this? CXPACKET & SOS_SCHEDULER_YIELD are indications of...

16954 is related to cursors. Do you have one within the procedure? If so, something is going south with it.

Not that I've noticed,...

Yeah, use the shrink file function, not shrink database.

The number of rows being returned is different, so the second plan is getting a seek and a key lookup instead of a scan. Personally, I wouldn't be happy with...

Yeah, it is a setting within SSMS that allows you to display varying amounts of large data fields (text, VARCHAR(MAX), etc.) but only up to a limit. Past, I think,...

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)')...