GilaMonster (11/14/2010)

---

Need to check. Was 7 levels + leaf, that I know, was not 2 million rows, that I also recall. May have had an include, can't recall. Was for...

SQLCLR script to delete old backup and log files (for example):

http://www.mssqltips.com/tip.asp?tip=1374

Sample data:

CREATE SCHEMA Property

CREATE TABLE Address

...

:w00t: NO! :w00t:

Not only is there a horrible implicit conversion (from zero...

Delete the row and then re-insert it with the correct identity value specified explicitly.

You will need SET IDENTITY_INSERT ON for that...

How? Using 900 byte keys, each (non-leaf) 8096-byte index page can contain...

vamshi.kotagiri (11/13/2010)

---

I have an identity column in a table with an incremental seed of 1 and starting with 1

I have inserted 5 rows where the last identity value would be...

Jeff Moden (11/14/2010)

---

Heh... OK... Now I get to pry the shoe out of my mouth. :blush: It looks like TF 610 does, in fact, help with converting fully...

Jeff Moden (11/14/2010)

---

I haven't looked at the article yet but BOL states that minimal logging will only work on a table with a clustered index if and only if the...

In the meantime, I knocked together a demo based on your example, which shows TF610 working as advertised:

-- REQUIRES 2008

-- USE A DATABASE IN SIMPLE OR BULK_LOGGED MODE

-- A suitable...

There are a couple of ways in which you might not get minimal logging in your example where ExpRow = B. Are you able to run that query (with...

How is casting binary or varbinary dependent on collation?

How does sys.fn_varbintohexstr...

sturner (11/11/2010)

---

actually there is such a builtin function: master.sys.fn_varbintohexsubstring()

I believe it will work fine for you... you would first cast your integer or decimal data to varbinary then hand it...

That article only applies to SQL Server versions up to 7.0 SP1!

GSquared (11/11/2010)

---

And that's why there need to be two different versions of null. One for "we don't know" and another for "we don't care". (Okay, really for "don't...