Viewing 15 posts - 1 through 15 (of 19 total)
I do have one question that I never resolved in my own mind - how does MAXDOP work with HyperThreaded CPU's?
If, for instance, on a Dual-Xeon/P-IV system, SQL Server thinks...
June 23, 2004 at 2:19 am
I think rather than everyone chipping in there, somebody should make that the next article topic!
I remember in the MCP study guide for SQL database & design, there was a...
June 17, 2004 at 3:13 am
One article I read on this topic (quite some time ago) is regarding the latency of the connection. Even though you may be connected through a Gigabit LAN, with a...
June 16, 2004 at 1:09 am
A good article. I think one small oversight is the use of "Covering Indexes" - if I am using the correct term.
The concept is using a composite index to return columns...
June 16, 2004 at 1:00 am
and then you can create a compound key of two bigint fields. that's a lot of unique values, but i'm sure you've already considered that!
May 14, 2004 at 2:53 am
Yep again, I attempted a single user mode restore and it went belly up because it didn't like the fact that the user database weren't where they were expected. ...
June 25, 2003 at 8:17 pm
Yep, they'll both have the same name. In the event of disaster recovery I would plan for Server B to have the same name as Server A.
I just had...
June 25, 2003 at 6:48 pm
Microsoft to the rescue!
After modifying my script to determine the maximum Timestamp value in the database, I ran
Select @@DBTS
to show what the current timestamp value is for the database. ...
May 26, 2003 at 1:10 am
I seem to have isolated the problem. One of the other developers said the problem came up again so I checked it out in more detail... this time with...
May 20, 2003 at 9:48 pm
Timestamps are unique across an entire database, that I'm quite sure of.
*scratches head*
To be honest I can't remember the database having to be restored at any point in the last...
May 15, 2003 at 7:08 pm
I've managed to pull an old backup.
I'm a little disappointed I didn't get more commment on this issue.
It's actually quite interesting, since the two records in question were written around...
May 14, 2003 at 2:35 am
Shame it happened on a production system, as I couldn't resolve it at my leisure. We had to manually update the record to force the Timestamp value to update...
May 13, 2003 at 2:37 am
Remember the 90-10 rule. 90% of the code runs only 10% of the time, and 10% of the code runs 90% of the time.
Why sacrifice readability for a piece...
May 5, 2003 at 9:03 pm
I didn't realise that SQL Standard couldn't handle 2GB properly? I was always under the impression that it could easily address up to 4GB?
And what in particular regarding SAN's...
April 30, 2003 at 7:15 pm
One thing to note in using Set RowCount is that I have seen a lot of examples where people set it at the top of a stored procedure and then...
April 3, 2003 at 8:25 pm
Viewing 15 posts - 1 through 15 (of 19 total)