Viewing 15 posts - 17,281 through 17,295 (of 22,214 total)
I agree with Clive and Lynn, especially Lynn. If you're really planning on making a career out of SQL Server, $50 for the developer's edition, which has everything, is a...
June 7, 2009 at 5:13 am
Lynn Pettis (6/6/2009)
Anyone with more knowledge or information in this area, please hop in and add your 2 cents worth.
Gail & Paul got on the Algebrizer before I could.
June 7, 2009 at 4:36 am
PaulB (6/5/2009)
Grant Fritchey (6/4/2009)A little more flexibility than bit, but then it has a little more flexibility than bit.
not sure if this is a circular reference or quantum-logic 😀
Yes.
June 5, 2009 at 2:53 pm
Lynn Pettis (6/5/2009)
Here is another OMG moment.
Oh wow. That's a first for me. He is right though. Almost any question can be answered by the suggestion to go and read...
June 5, 2009 at 2:52 pm
It's like said before. It could be so many things. Especially with the indexes you have. I suspect page splits are going to be pretty expensive. So some inserts will...
June 5, 2009 at 2:50 pm
Oh, and the ID column doesn't need to be included with the covering index since it's the clustered key. The key values in a clustered index are always available within...
June 5, 2009 at 1:14 pm
This index, IX_StudentServices_StID_R_DU_PID_SeID_L_GS_FD_D_SC, and this index, Indx_StudentID, are basically the same because the leading edge, the first column is the same. You really don't need the second index.
That's not getting...
June 5, 2009 at 1:12 pm
Bob Hovious (6/5/2009)
A bit of humor for those of you who own dice with more than six sides.
Excellent. When they're funny, they're really funny.
June 5, 2009 at 8:55 am
If it's just time, it could be contention, blocking, that made it run longer the second time than the third. It could be that the second time required a page...
June 5, 2009 at 7:54 am
Adding an index will allow the COUNT process to find something with fewer pages than the entire table. Otherwise, you have to do a table scan, every time, no options.
June 5, 2009 at 7:44 am
Please don't cross-post between the topics. Many of us read all the various groups and this just diffuses the conversation. Can I suggest that further comments go this thread:
http://www.sqlservercentral.com/Forums/Topic729538-357-1.aspx
June 5, 2009 at 7:42 am
I'd suggest books. First off, all the Inside SQL Server 2005 (or 2008) books are worth reading. Ross Mistry's book on 2008 Administration is good. Joe Sack's book on Transact-SQL...
June 5, 2009 at 6:54 am
It just sounds like a databse with two data files & two log files. Make sure, if you're restoring it to a new server, you get all four files into...
June 5, 2009 at 6:47 am
First, if you can post the actual execution plan instead of the estimated, it'll make a huge difference in trying to figure out what's going on.
Next, I'm not sure...
June 5, 2009 at 5:54 am
GSquared (6/4/2009)
June 4, 2009 at 1:37 pm
Viewing 15 posts - 17,281 through 17,295 (of 22,214 total)