Viewing 15 posts - 42,946 through 42,960 (of 49,552 total)
You do get the cert, providing you have any prerequisites. You will have to wait a while for results.
That exam's not in beta though. It went through beta some months...
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
November 26, 2008 at 9:45 am
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...
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
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...
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
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...
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
November 26, 2008 at 9:24 am
Why can't you change the compatibility level?
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
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...
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
November 26, 2008 at 9:07 am
5 seconds with google will get you this:
http://www.microsoft.com/learning/mcp/certifications.mspx
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
November 26, 2008 at 8:35 am
Magy (11/26/2008)
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
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.
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
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.
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
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...
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
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...
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
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...
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
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...
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
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...
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
November 26, 2008 at 7:46 am
Viewing 15 posts - 42,946 through 42,960 (of 49,552 total)