odanwada (5/19/2011)

---

I dont know exactly why my manager is asking like that.. but he strictly told that do not use SPROCS, Cursors or Temp Tables...

I think my manager wants the...

Must be that the procedure was created with a different schema as owner.

Take a look at the RML Utilities from Microsoft. You can set up a work load and automate the replay of that workload or use a trace file and automate...

Another option is to skip the trace entirely and pull the data from cache using dynamic management objects. Selecting from sys.dm_exec_query_stats will show you aggregate information about a query and...

You can set this up pretty easily by using SQL Agent. You can query for the processes that are in place using sys.dm_exec_requests. With that you can get the session...

But, the first time you move a database onto a new server, there's nothing of that database in cache. At best you're looking at memory pressure that is exposed when...

No, that was...

I didn't even know Hyperbac could be set to compress trace files. Cool!

By the way, rollover is supposed to give you a series of files, so that was working as...

Robert Pepin (5/18/2011)

---

We have been working with the Red Gate Data compare product for several weeks now and is the product that we are having issues with. We are...

I would not lay out the database by the transactions defined. Instead I would to set up standard database normalization, taking it out to 3rd normal form. It's a good...

Why the restriction to not use a stored procedure? A stored procedure is just a wrapper on a query, and you're going to have to write a query no matter...

One thing you don't have is rollover on the files enabled:

exec @rc = sp_trace_create @TraceID output, 0, @OutputFileName, @MaxFileSize, @EndTime

That should get changed to this:

exec @rc = sp_trace_create @TraceID output,...

There is no gui from SQL Server. It's worse than that. If you launch from SSMS, you're going to have a brain dead version of PowerShell. Better to launch it...

Is this for data export? You don't have any kind of where clause at all. You're likely to see nothing but table scans from a query like that, and based...

Just remember that the Profiler gui is good for browsing the data later. Don't use it to monitor the server. Capture the data with a server-side trace.

If you really...