If those three are used in every query, is it possible to set them as the clustered index? Since that's included in every non-clustered index, it might speed things...

The main problems with cascading deletes, at least in my experience, are the limitations on multiple chains hitting the same table, and issues with triggers that weren't designed correctly.

On the...

SSIS is based on the default instance. I ran into a major bug with that a little while back, since Workgroup Edition doesn't support SSIS, but Standard does, and...

The problem with "checking for valid SQL" in the parameter string, is this:

http://www.mywebpage.com/subpage.aspx?id=1

Many coders will take the 1 and use string concatenation to add that to the Where clause of...

andrew gothard (8/12/2008)

---

Well - usually in QA once it's written. Prototype in MS - then you get that sinking feeling when a colleague comes up to you baffled that...

On the question about scan density, the answer is, "yes". Just worry about the fragmentation data in the new view.

There isn't a way, in SQL, to generate a non-repeating random number, following the constraints you've called for. You can sort of do it with newid(), but you've already...

Can you post a sample of the row data, especially the data where it's giving you the wrong count? (Best, if possible, would be a copy-and-paste from the actual...

Actually, the thing about sp_ causing SQL to look in Master first, is true, per Microsoft. If you have some source that knows more about the internal workings of...

In case it matters, make sure the columns that aren't part of the Where clause or Join clauses (if any) are only Included in the index, not part of the...

I've seen this kind of recursive cursor call before. Not the same situation, but quite similar.

It worked just fine, on very, very small data sets. Was a couple...

You can set For XML as Path or Explicit instead of Auto. Path might do what you need, I'm not sure. Explicit allows you to define how you...

Here's one way to do it:

create table #T (

Feature varchar(50),

[Text] varchar(50),

DestinationID int)

insert into #T (Feature, [Text], DestinationID)

select 'Location','Rhodes', 1 union all

select 'Weather','The weather in Rhodes', 1 union all

select 'Beaches','The beaches...

This specific attack is new, but the technique is not.

There was a question of the day on this site a month or two ago that was on this subject.

Actually, this looks like the question of the day from yesterday. Why re-post it here?