Viewing 15 posts - 16 through 30 (of 65 total)
Alexander Kuznetsov (3/17/2011)
Hi Adam,The following sounds like a good reason: "tracks object evolution automatically".
Thanks for the answer.
AK
The only problem (re: object evolution) I've found is in SQL Server 2005 on...
March 17, 2011 at 1:27 pm
I have a presentation I've given a couple times related to metadata and extended properties:
http://code.google.com/p/caderoux/wiki/LeversAndTurtles
Using it to fine tune code generation so that code can be re-generated without...
March 17, 2011 at 10:02 am
Typically, we've relied on the profiler for this. It isn't the greatest, but if nothing shows up there over some time, we can consider renaming the table or making...
February 22, 2011 at 2:35 am
kenny-892481 (11/22/2010)but that doesn't mean that refactoring is necessarily any easier than if such an interface is not maintained.
Assuming that ease of validation and acceptance and confidence in quality =...
November 22, 2010 at 8:05 am
Thank you.
I'm so tired of explaining that the database has to have a well-defined perimeter of services which it exposes.
It's not so much that the ORM code generation is horrible,...
November 20, 2010 at 5:40 pm
I have successfully used http://autoaudit.codeplex.com/ for triggers and I've been happy. The particular system I used it in wasn't what I would call a high volume OLTP...
October 20, 2010 at 1:53 am
As far as auditing, I have used http://autoaudit.codeplex.com/ very successfully (code generated DML and DDL triggers). Its auditing approach is not individual archive tables, however, but a...
October 20, 2010 at 1:47 am
Yup. A team has to have people in different roles. All have some kind of value, and people aren't all paid the same - that's the way it...
August 25, 2010 at 10:26 pm
Jeff Moden (8/20/2010)
Cade Roux (8/20/2010)
Jeff Moden (8/20/2010)If you use SELECT INTO to build your Temp tables, you don't need to change the table structure... it just happens.
Are there limitations surrounding...
August 20, 2010 at 1:22 pm
Jeff Moden (8/20/2010)If you use SELECT INTO to build your Temp tables, you don't need to change the table structure... it just happens.
Are there limitations surrounding that? (besides just...
August 20, 2010 at 10:28 am
I scrolled through the discussion and I didn't see any mention that CTEs can be stacked. This makes some operations a lot easier to read and maintain (format appropriately...
August 20, 2010 at 7:47 am
I'm always here, but unfortunately I can't get anyone to pick up my TechEd tab.
Sometimes Bourbon Street really gets to be too much, and if you're tired of the food...
June 8, 2010 at 7:47 am
I'd like to see an full benchmarked example, with one source file, two ETLs into two competing models and sample queries against them. SSAS cubes, too if you like.
June 2, 2010 at 8:51 pm
We also use a date dimension with a human readable key and a time dimension with a human readable key. In some cases, the time dimension is not used...
June 1, 2010 at 10:28 am
Both SQL Server 2005/8, 2008 R2 and Oracle 10g R2 and 11g R1 and R2 participates in such transactions without resource manager in the Microsoft platform.
This can sometimes be a...
April 1, 2010 at 6:59 pm
Viewing 15 posts - 16 through 30 (of 65 total)