Viewing 15 posts - 11,086 through 11,100 (of 14,953 total)
I've done a lot of work on audit logging. (Even wrote articles on it for this site.) Clustered indexes based on the insert sequence can definitely help with...
February 6, 2009 at 11:39 am
There's a prevalidate option on most items. You can turn that off. I've had to do so few times when a few too many properties were variable-dependent.
February 6, 2009 at 11:31 am
Are you trying to turn an existing column into an identity, or to add an identity column (new column) to a table?
Adding one is easy:
alter table dbo.MyTable
add ID int identity;
February 6, 2009 at 7:44 am
I think you can achieve the functionality more easily with the HierarchyID datatype in SQL 2008. Check out these articles, see if they have what you need:
February 6, 2009 at 7:42 am
Chris Morris (2/6/2009)
Grant Fritchey (2/6/2009)
February 6, 2009 at 7:30 am
Chris Morris (2/6/2009)
GSquared (2/6/2009)
February 6, 2009 at 7:09 am
I use a trace for that.
The views only hold onto data for procs that have been cached, and flush and reload every time the execution plan changes. That means...
February 6, 2009 at 7:02 am
You can maintain referential integrity through your own code in whatever manner suits your requirements the best. You can't have foreign keys that reference a different database, whether on...
February 6, 2009 at 6:58 am
Again with the SQL being the database. It's not a valid equality statement. Select != set-multiply. If that's all you're saying, that's fine. SQL is not...
February 6, 2009 at 6:55 am
Iay amay uenflay inay igpay atlinay. And speak/write attrocious Spanish. My French is worse than my Spanish. My English is abysmal, but I speak extremely fluent American.
February 6, 2009 at 6:36 am
Bob Hovious (2/5/2009)
So my question here would be do you assume worst case that it's going to be hit really hard and go for the tabular method and take a...
February 6, 2009 at 6:31 am
One solution, probably a good one, in that case would be to set up a single master database with the common data (as you proposed), then have the other copies...
February 5, 2009 at 3:11 pm
Nope. It's going to be one insert statement per table.
February 5, 2009 at 3:01 pm
Do different people connect to the database with different credentials, or do they use a web page that passes a single set of credentials? (The later is much more...
February 5, 2009 at 3:00 pm
Viewing 15 posts - 11,086 through 11,100 (of 14,953 total)