Viewing 15 posts - 3,526 through 3,540 (of 7,429 total)
No middle ground for me sorry. Even thou item 2 is non-critical and can stand to be down for a month you will still have to fend off customer complaints...
January 21, 2003 at 5:10 am
DBCC PAGE is what I use. Then just a lot of time figuring the data out.
January 20, 2003 at 3:36 pm
If you are talking about the pubs DB which contains publisher, book and author info. It is installed by default unless you do a custom install and remove it from...
January 20, 2003 at 9:49 am
But again there is no logical order to the data. The key to a cluster should always be the logical order. A datetime is good because you want the data...
January 20, 2003 at 7:13 am
Because the value produced for a uniqueidentifier is not sequential and data would be randomly inserted in the table.
For example run
SELECT NEWID()
several times and you will see the order will...
January 20, 2003 at 6:42 am
Any specific issue you have in mind. ALl in the fix list seemed to test out fine along with revisions made thru 1 and 2. But I did find some...
January 20, 2003 at 6:39 am
Generally it is the person who normally barks about these things that is the one who fouls things up in groups I have worked with. However, 90% of the time...
January 20, 2003 at 6:07 am
Nope just throwing things out that could push the Row width larger that 8K which an Order By generates a Temp work table in tempDB in many cases and it...
January 20, 2003 at 5:57 am
Unfortunately I think this is commonly misunderstood or the engine has never worked right if the few pieces in BOL that say NULL values are ok is right. But I...
January 19, 2003 at 5:54 pm
Ok, just going a little extreme here in your work. Wat you need is to SUM the hours and group by the person and project. Like so...
SELECT [Name], Project, SUM(Hours)...
January 19, 2003 at 6:34 am
Here you go. It states why as well. The only thing thing is it has not been updated to include SQL Server 2000 but 2000 has the same issue as...
January 19, 2003 at 6:27 am
If deleting a large chunk of data from a table every index will play a factor as each row disappears the indexes are updated. Many time it will help performance...
January 18, 2003 at 7:52 am
Ok, then DISTINCT is finding rows that duplicate in value and is removing them. This is why you are seeing a smaller number.
Consider a table with a column for char(1)...
January 17, 2003 at 8:27 pm
Actually there are several overheads which are added. See this thread for additional related comments.
January 17, 2003 at 8:23 pm
There is supposed to be an update BOL included with some additonal changes as well. I haven't had a chance to check but that was listed to be coming. Can...
January 17, 2003 at 7:13 pm
Viewing 15 posts - 3,526 through 3,540 (of 7,429 total)