Viewing 15 posts - 17,266 through 17,280 (of 22,206 total)
SCOPE_IDENTITY is not going to be affected negatively or positively by being called within a transaction. I would recommend the transaction though, just because it's a better way to manage...
June 8, 2009 at 7:55 am
And run consistency checks before you backup the database so that in the future you'll know that the backup was taken from a well structured db.
June 8, 2009 at 7:48 am
I'm just a bit confused by the situation. Did you have the database in full recovery but you were NOT running log backups? That could explain the excessive size of...
June 8, 2009 at 7:47 am
3 copies of the db on the same server just doesn't make any sense. If they're worried about corruption or loss, then all three on the server are exposed the...
June 8, 2009 at 7:40 am
If it can't access the folder, it's because of security. SQL Server runs under a different context than when you connect to it. Just because you can access the share...
June 8, 2009 at 7:37 am
What about using Performance Monitor to capture user connections all day long? It's the very best way I know to do this.
June 8, 2009 at 7:34 am
Good article.
You could have carried it a bit further. Including RESTORE VERIFYONLY as a part and parcel of your backup routines adds to the overall confidence you have in your...
June 8, 2009 at 5:36 am
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
Viewing 15 posts - 17,266 through 17,280 (of 22,206 total)