Viewing 15 posts - 19,936 through 19,950 (of 22,202 total)
There probably is a vanishingly small performance hit for that, yes. However, all the other issues around writing are so intensive, that little tiny blip where the query engine rearranges...
July 17, 2008 at 6:52 am
That's not against what I said at all. That's what I've been trying to suggest. Thanks for stating it in a different way.
July 17, 2008 at 5:59 am
When data changed, a given row would be versioned, but not all rows or all tables. Also, the "version" was not a moment-by-moment creation. They would work on a given...
July 17, 2008 at 5:56 am
Maybe I'm old fashioned (or just old), but I've always felt that one of the principal duties you have is supporting those around you to the best of your ability....
July 17, 2008 at 5:50 am
What do the execution plans look like? Maybe it's not using the uniqueidentifier at all?
July 17, 2008 at 5:22 am
OK.
WHILE (@StartDate < @StopDate)
BEGIN
SET @StartDate = DATEADD(month,1,@StartDate)
SET @EndDate = DATEADD(day,-1,DATEADD(month,1,@StartDate))
...
July 16, 2008 at 12:34 pm
Yes, it is possible for the most part to build the data structure, tables, primary keys, foreign keys, and clustered indexes without having an application. Writing all the views and...
July 16, 2008 at 11:33 am
The problem is, even if you order the SELECT statement when doing the inserts, when you next SELECT from the table, you're not guaranteed the order it comes back in....
July 16, 2008 at 9:19 am
The testing I've seen and read about suggests that, by and large, uniqueidentifiers are poor choices for indexes, especially clustered indexes, because of their width. I've also seen testing that...
July 16, 2008 at 8:17 am
And that, of course, is the absolute strongest argument for using nothing but artificial keys. But, even so, there are business definitions that can allow for the use of natural...
July 16, 2008 at 7:57 am
Almost all the time, it's better to allow SQL Server to control the locking scheme in your queries. There are exceptions to this, but the exceptions should be exceptional.
It sounds...
July 16, 2008 at 4:46 am
Check this in the Books Online for details:
DBCC CHECKIDENT(TableName,RESEED,1)
July 16, 2008 at 4:41 am
Since all the work is being done on the server, how many different settings are likely to come out?
What they want to do, if I'm reading this correctly, is get...
July 16, 2008 at 4:34 am
We had to track versions over time, so we created a version table, put a key for it in every other table and then did nothing but inserts into all...
July 15, 2008 at 11:31 am
Viewing 15 posts - 19,936 through 19,950 (of 22,202 total)