Viewing 15 posts - 35,461 through 35,475 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2009 at 9:05 am
Grant Fritchey (12/5/2009)
I still want to set up some tests. need time.
I haven't got too much on my schedule next week. I'm sure I can find a couple hours.
I think...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2009 at 9:02 am
Viewing 15 posts - 35,461 through 35,475 (of 49,552 total)