Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic608988-359-1.aspx

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic608988-359-1.aspx

<Sigh>

You can generate a trace script from profiler. All you'll need to do with the script is set an end time and a file name. Script to a fast drive...

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...

I don't know many apps where missing a bunch of rows...

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...

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...

Why can't you change the compatibility level?

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...

5 seconds with google will get you this:

http://www.microsoft.com/learning/mcp/certifications.mspx

Magy (11/26/2008)

---

Gail, I'm in SQL profiler, and I ran it while executing the stored proc. Is there anything I should be looking for besides stmtCompleted? I see a...

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.

Standard edition ignores that setting.

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...