It sounds like you guys haven't worked much with 3rd-party data vendors and their data. If you had, you'd appreciate how big an issue this is. Widespread use of a...

GilaMonster (12/13/2010)

---

It's backing up the changed extents, but like full backups it'll need enough of the tran log to ensure a consistent restore, however I don't think dfalso was talking...

Representing the non-standard SQL Server folks if I may, SHRINKing is very needed and valuable in our situation (databases not attached to applications). Our data is for analysis, so I'm...

Craig Farrell (11/11/2010)

---

Haven't seen that before, dfalso, except when I'm getting different defaults off my procedure declaration.

I know you're trying to keep the code to a reasonable length here, but...

I looked into writing CLR stored procedures and aggregate functions a few months back. For me, the problem was not enough integration, actually. What I mean by that is that...

Hi, thanks for the article.

In reading this and other articles that show how to use XML for string tasks, they all provide examples using variables. I'm looking to parse...

So now, what's the minimum number of rows guaranteed to be in master's syscolumns?

Jeff Moden (6/28/2008)

---

dfalso (6/27/2008)

---

In order to be truly safe, dynamic sql is needed, unless we could write a CTE with an input variable that governs the amount of recursion...

Jeff Moden (6/27/2008)

---

dfalso (6/27/2008)

---

Not to quibble about it, but you do need dynamic SQL if you need more than 11,000 but don't know how much more. Right? In other words,...

Not to quibble about it, but you do need dynamic SQL if you need more than 11,000 but don't know how much more. Right? In other words, if your upper...

If you...

David Jackson (6/27/2008)

---

Insert this into the top of the script

--===== Conditionally drop

IF OBJECT_ID('dbo.Tally') IS NOT NULL

...

Just an observation, but I believe most XQuery commands need string literals for their parameters, not strings (so no variables). So if you know the schema structure and are querying...

I'd add that if you *know* your data will fit in a nvarchar(50) - and future data as well - it's good to keep it that small if you want...

Jeff Moden (4/17/2008)

---

Sorry folks... dunno how I missed this one.

Antonio... I sure do appreciate the attention to detail you put into the tests you did and the reports that followed....