Incidentally, once you've created your new filegroup, there is an alternative for moving your table to the new filegroup. Simply create a clustered index on that table - your can...

Typically, I've resolved this problem in the past using one of two solutions. Both solutions have their positives and negatives, and you'll find people that will agree with them or...

Yes, I can see how your current design would be inefficient. Well, there is documentation in Books Online about the bitwise operators and how they work. They will be most...

Hmmm. All I can speculate is this:

I might speculate that when you compile the stored procedure it essentially has no information on the specific values that are being used in...

When calling your stored procedure, are you providing arguments that are used as variables in the query statements inside of your stored procedure? When extracting the contents of your stored...

Any other information on bitwise operators besides what? What information do you have or have you read so far?

Could you provide a little more information about your data? Are you...

Hawg,

I've run into this problem, too, in my ASP.NET applications. You might try adding/changing a couple of settings in the web.config file for your Web application; the settings are:

<authentication mode="Windows"...

Ah, I see. You have created a bit of a conundrum for yourself by not explicitly naming your foreign keys; SQL Server, of course, provides its own automatic name for...

Couldn't you just drop the constraint and use ALTER TABLE to add the constraint back in with the specified constraint name (this is what EM does if you add cascading...

There is definitely the concern that developers will be more likely to ignore set-based solutions with the advent of the CLR in Yukon. On the other hand, there's nothing to...

Nevermind then. 🙂 Glad you've resolved it.

Matthew Burr

Edited by - mdburr on 10/14/2002 09:46:42 AM

Just for kicks, in Query Analyzer, navigate to the database where these tables reside, and execute the following script, but before doing so, replace the text between the single quotes...

Alternatively, check out "INSTEAD OF" triggers. You can place these on views - even views that are not partitioned views - and they will operate on INSERT, UPDATE, or DELETE...

Tom,

In response to your question about views physically storing data, your understanding about views being like "telescopes" is correct for traditional views, but indexed views are different. An index is...

I can only provide my proverbial "two cents"; I won't claim it's authoritative. First, I believe that Yukon supports the Common Language Runtime (CLR) introduced as a fundamental piece of...