opc.three (9/27/2011)

---

Did you use an INT for your identity column? Try it with BIGINT. I have a theory that since a RID is 8 bytes that using a BIGINT...

There are two problems I can see...

Firstly, the XPATH is not quite right, and secondly, the namespace is not required.

If you could provide sample data in an easily consumed format...

opc.three (9/26/2011)

---

@mm Something occurred to me, you may still have heavy fragmentation from the continuous addition of new rows and the deleting of existing rows over time. Here is what...

Thanks for the info.

My understanding is that you only get forwarding entries if an update changes the size of the row such that it won't fit in the existing physical...

The issue here is the conversion. Try the sample below to see a working version.

You need to explicitly grab the correct number of bytes from the context_info() result before converting...

Hi,

I also have to work with a third part OLTP that uses all heaps (It sounds just like yours - historically coming from C-ISAM), and was just wondering what is...

angelnjj (9/21/2011)

---

THANK YOU! This worked like a dream with a few tweaks specific to our environment. Placed in an execute process task in SSIS referencing the .bat file...

Now that Tom has resurrected this, I had a look and the only answer that is possible is the last as the so-called correct answer will not provide 100GB of...

Here is one way to tackle the problem - not yet including the weekend aspect....

IF OBJECT_ID('tempdb..#tagged') IS NOT NULL

DROP TABLE #tagged

IF OBJECT_ID('tempdb..#tagged') IS NOT NULL

DROP TABLE #counted

;WITH MySampleData (TheDate,TheValue)

AS

(

SELECT CONVERT(DATETIME,'20100101'),'-1'...

GilaMonster (9/10/2011)

---

You're missing my point. We were talking nested transactions, not savepoints

No matter how many open transactions there are, a ROLLBACK TRANSACTION always rolls back to the outermost transaction. If...

I can't believe I am questioning you Gail, but doesn't that statement need an exception clause for saved transactions?

For...

SELECT CONVERT(datetime,@YourDateAsString,103)

the 103 tells it to use the format DD/MM/YYYY

Depending on what you are trying to do, you can make use of SHIFT I think.

Something like

SET filename=$1

SHIFT

SET something=$1

SHIFT

SET somethingelse=$1

Each time you use SHIFT it drops $1 and shifts all...

You are most welcome.

Do bear in mind the SET NOCOUNT ON; thing when writing SPs to be called from .NET as well -...

I haven't had to do this before, but here are some bits I knocked up to try and help...

First, grab a copy of md5sum.exe from the Unix Utils project :...