Shoot, I thought I had missed the book and I was waiting for the movie. Now you're telling me I will have to do more reading ? <grin> But seriously, I am eagerly waiting for the book to be released and will read it cover-to-cover.
2003-08-27
I would definitely recommend that you mirror drive 3. But I would also suggest that you mirror drive 1. Why have something like a drive failure take down your production system, drives are cheap.
2003-08-27
The book is (and has been) at the printer, as of last Friday they were due to ship to me this coming Friday. They've had some equipment problems that set us back a few weeks, if they ship on time we'll have an announcement up once they are here. This is the reason we didnt […]
2003-08-26
No, you'd need to compare each column. Comparing PKs is easy, but that won't tell you if all data is the same. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-08-26
quote: And beside all of this I would definitly recommend to upgrade to W2K or even W2K3. MS doesn't support any more NT4 (no patch, no nothing! The only exception was the patch #026 against the W32.Blaster worm). But in this specific case that one should not be the problem Actually, MS extended patch support […]
2003-08-25
1 reads
I guess you are looking for a AND in the query. Try this SELECT Student FROM TableA M WHERE EXISTS (SELECT 1 FROM TableA S1 WHERE S1.Student = M.Student AND S1.NumberOfTests >= 2 AND S1.Percent >= 30) AND M.NumberOfTests >= 1 AND M.Percent >= 40
2003-08-19
Cool, I'd like to hear how it works out. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-08-10
See http://support.microsoft.com/default.aspx?scid=kb;en-us;270119
2003-08-07
2 reads
The active users are mixed in with the inactive. Also the table is keyed on the Identity field. Are there any articles that provide information on the working of SQL Server. Thank-you.
2003-07-28
I missed answering your real question...both will work just fine as long as you are giving the correct data. When the CONVERT happens, your query is really: SELECT * FROM tblprojects WHERE insertedDate >= '01/01/03 00:00:00' AND insertedDate <= '04/30/03 00:00:00' SMALLDATETIME and DATETIME are ALWAYS a date AND time. So your query (whether you […]
2003-07-28
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers