Recent content by mjhessler

How does red-gate "SQL Data compare" compare with Apex SQL Diff? Has anyone tried both or know why one might be better than the other? I want to know my options before I recommend a purchase. I haven't try either of them yet.

Does anyone have an opinion on specific “data comparison tools”? We are looking for something to use in our test or dev environments that will be able to compare snapshots of the data in a 14 gig SQL SERVER database before verse after a test event. There are 545 tables in the db. We have...

Our concern is with 14 gig database on SQL Server 2000

Does anyone have an opinion on specific “data comparison tools”? We are looking for something to use in our test or dev environments that will be able to compare snaps shots of the data in a database before verse after a test event. We have been able to record and compare data in specific...

I recommend all reports use stored procedures instead of having SQL statements in Crystal. Is anyone aware of a good way to export SQL statements in Crystal. We have over a thousand legancy Crystal reports to convert to stored procedures.

How do I select the EventInfo value from DBCC INPUTBUFFER (SPID) into @EventInfo? DECLARE @spid int DECLARE @EventInfo nvarchar(255) SELECT [USER_NAME()] = USER_NAME() ,[HOST_NAME ()] = HOST_NAME() ,[host_id()] = host_id() ,[SYSTEM_USER] = SYSTEM_USER ,[app_name()] = app_name() ,[@@spid] =...

What can be done to have a trigger return the SqlCommand or sql statements responsible for the change? I am using app_name() and host_name() and am hoping to learn of a similar function that will give the T-SQL code/statements/commands. I have checked all of the stored procedures, but they...

Need to capture start/end datetime, user name and stored procedure name for every time any non-system stored procedure runs for a specific DB on a server. Also need to do the same for Crystal Reports not using stored procedures. Can this be done without a purchase third party package such...

In reasearching "SQL Coefficient" I found that Quest purchased them.

I have successfully used Quest Performance Analysis tool to find and correct problems at a client location. I also used Idrea tool successfully but perferred the tracking in time feature from Quest. You could try it on a free trial and see if you you drill down on the problem. That's what I'm...

I have successfully used Quest Performance Analysis tool but wanted to hear from other SQL DBA’s and developers this time. I am working as the DBA with a new client that is in need of a Performance monitoring software package. Does anyone have any experience with any 3rd-Party monitoring...

Performance monitoring tools I have successfully used Quest Performance Analysis tool but wanted to hear from other SQL DBA’s and developers this time. I am with a new client that is in need of a Performance monitoring software package. Does anyone have any experience with any 3rd-Party...

I'm at a new client who is running Diskeeper on the SAN that has both the SQL data mdf and log ldf files. Does any one have any experience good or bad with Diskeeper running against open SQL files?

In this case queries DO NOT span databases, ie facilities. Each one is a stand alone and any data used by all facility databases exists in each. The amount of data stored would be less with the common database, but the traffic would not be distributed. It should be noted that these databases are...

Does using a SAN for SQL Server data and log files invalidate the "Best Practice" of having .mdf and .ldf files on separate storage arrays? I would be interested in hearing from everyone who knows if there is a new "Best Practice" concerning SQL .mdf and .ldf files & SAN.