Search results for query: *

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

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

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

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?

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.

Client written application using SQL Server was designed to be on local servers at each facility. Instead of individual local facility servers, each of the sixteen facilities has its own database on the corporate SQL Server cluster. All of the .mdf and .ldf files are on a SAN. Should there be a...

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.

Client written application using SQL Server was designed to be on local servers at each facility. Instead of individual local facility servers, each of the sixteen facilities has its own database on the corporate SQL Server cluster. All of the .mdf and .ldf files are on a SAN. Should there be...