Viewing 15 posts - 35,461 through 35,475 (of 49,553 total)
Grant Fritchey (12/7/2009)
CirquedeSQLeil (12/7/2009)
Extremely Urgent my Exam is only 1hr today.
Here's my IM address, just send me the questions and I'll plug in the answers... they'll all be 100% correct...
December 7, 2009 at 9:33 am
kiransuram19 (12/7/2009)
Can we force sql server to truncate log at my convience (using checkpoint...) at the earliest rather than sql server doing by its own?
Yes. In Simple recovery the...
December 7, 2009 at 9:29 am
Animal Magic (12/7/2009)
as far as i know there isnt an option to disable logging, except of course changing the RM to simple.
Changing the recovery model to Simple doesn't...
December 7, 2009 at 9:18 am
Grant Fritchey (12/7/2009)
Nah, I'm just peeved because of... well, read for yourself.
Oh man. Bob, I LOVE your reply to that thread. What I was thinking, but too polite to say.
December 7, 2009 at 8:26 am
Lynn Pettis (12/7/2009)
Bob Hovious 24601 (12/7/2009)
Now if they had said "Help me with this, please, Expert." that would have been another matter entirely. 😉
Maybe just a extra 2 or...
December 7, 2009 at 8:13 am
I'd say just include the username in the mail or a link to their profile. Link to their profile would be best. Nice easy way to reply to user without...
December 7, 2009 at 8:06 am
Hmmm. Just got email from random SSC member. Starts "Help me with this" then goes on for 2 pages. Looked like homework too.
Shift-Delete
December 7, 2009 at 7:48 am
Then you need to look at the cause of the problem, not the symptoms of the problem. Move as much as possible from dynamic SQL to normal stored procedures. Where...
December 7, 2009 at 12:47 am
Truncate Table requires very high permissions, just delete rights on the table is not enough. Check what rights are required (books online) and then make sure that no one has...
December 7, 2009 at 12:45 am
They are completely unrelated and do totally different things.
sp_updatestats runs a statistics update (using UPDATE STATISTICS) across all the statistics in the database where the underlying table has had at...
December 7, 2009 at 12:41 am
daniel.phone (12/5/2009)
Thanks GilaMonster. I have applied for an internship and I was asked the question by an HR person in email. Thats why I said it is urgent.
It's usually faster...
December 5, 2009 at 10:50 pm
There's really no need to start a new thread with exactly the same question that you asked yesterday.
No replies to this thread please. Asked and answered here: http://www.sqlservercentral.com/Forums/Topic829341-1291-1.aspx
December 5, 2009 at 10:44 pm
That should install on Windows XP, vista and all other desktop versions of windows. You just need to install the server components. When you get to the feature selection, make...
December 5, 2009 at 9:48 am
If you want your own server then you need to install the server components of SQL as well as the client. The client tools are just interfaces to work with...
December 5, 2009 at 9:40 am
If you only installed the client tools, there won't be a local server. It may be the default that SQL brings up, it's assuming that you installed a local server,...
December 5, 2009 at 9:05 am
Viewing 15 posts - 35,461 through 35,475 (of 49,553 total)