Viewing 15 posts - 42,961 through 42,975 (of 49,566 total)
prakash.gr (11/26/2008)
i do agree with your points. but my frontend is not critical like banking application where inconsistency effcts adversely.
I don't know many apps where missing a bunch of rows...
November 26, 2008 at 9:38 am
You can't use a variable in an in clause like that. The in has to either be literals or a subquery.
Two options:
1) Dynamic SQL with all of its downsides and...
November 26, 2008 at 9:29 am
User_name and session_user are nondeterministic functions, as are most similar security functions. They can return different results when called with the same parameters. As such, they may not be part...
November 26, 2008 at 9:24 am
Why can't you change the compatibility level?
November 26, 2008 at 9:12 am
Tables, by definition, don't have an order. Position of rows within a table is a meaningless concept. The way the rows are stored physically on disk (which is what you...
November 26, 2008 at 9:07 am
5 seconds with google will get you this:
November 26, 2008 at 8:35 am
Magy (11/26/2008)
November 26, 2008 at 8:27 am
Yeah, that looks like the 'falling off a cliff' behaviour that Bob Ward described. I'll hunt for an article and drop him a mail if I can't find it.
November 26, 2008 at 8:18 am
Elisabeth Rédei (11/26/2008)
Make sure you don't have the "Lock Pages in Memory" user right set for the SQL Server startup account.
Standard edition ignores that setting.
November 26, 2008 at 8:12 am
I'm not asking about SQL's working set. The message says that's getting reduced. I asked about the total working set of all processes on the server. If that's showing a...
November 26, 2008 at 8:07 am
MarkusB (11/25/2008)
It will consider all queries which qan since the last time SQL Server started.
Not quite. It will consider all queries whose execution plans are still in cache. As soon...
November 26, 2008 at 7:59 am
Magy (11/25/2008)
Im sorry...I'm using SQL Server 2000...what is sp_stmtcompleted?
It's a profiler event. Under the Stored Procedures group. It traces each statement within a proc. It can get intensive so make...
November 26, 2008 at 7:55 am
kotlas7 (11/25/2008)
can we put the database in recovery mode after taking the tail backup in sql server 2000?
Sure. Add the NoRecovery option to the log backup statement along with no_truncate.
The...
November 26, 2008 at 7:49 am
I don't understand exactly what you're saying.
If you have space constraints, get more space. Repeatedly shrinking the dataabse and log (and having them grow again) will cause index fragmentation, internal...
November 26, 2008 at 7:46 am
Sure. Tonnes
Try these for starters:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx
November 26, 2008 at 7:45 am
Viewing 15 posts - 42,961 through 42,975 (of 49,566 total)