From an application stack perspective - I found JMeter very useful - mainly because it allows the developers to design test patterns. I...
Two others I have used - which are very useful , one is free and the other costs:
I've used on both DB2 and SQL Server
An execution plan is useful and also the DDL - with index information.
There's an email newsletter called Database weekly from sqlservercentral.com
Also , check the feed on http://www.sqlserver-dba.com
As a rule , after the data insert, but this will depend on : how often you do the build , how much data etc
Something like the following script will give you an execute statement , you can then pick and choose which procedures to allow execute rights...
I'm getting some conflicting information , regarding sql 2005 Standard Edition licensing for multi instancing.
If you have multiple instances of...
The statement I'm running from Query Analyzer is :
SELECT myCo1,myCol2 FROM myTable
INNER JOIN MyTable2 ON myTable.thecol = myTable2.thecol...
I'm troubleshooting a performance issue , Looking at Profiler - for the given statement, I'm getting the following figures , why would there...
I've tried adding OPTION (MAXDOP 1) and in fact it's a few milliseconds slower?
Thanks for your response , I've changed the duration times around , I posted incorrectly earlier . Please read first post again , thanks
I have a sql statement running on 2 different servers , and getting a performance disparity.
SERVER 1 - Windows 2003 Service Pack 1 , sql server...
Satya , I also forgot to mention - I've reset everything to 15 minutes and seem to run through the night OK. But I am still interested in any...
Every 5 minutes ,
SQL Server 2000 Enterprise Edition
At certain times of the day the transaction log files created are to large to be handled by the Log Shipping...
It is possible to apply some logic that commits transactions in batches. What sort of code are your running?
In SQL Books Online under DBCC SHOWCONTIG - there is a good script , that checks for levels of logical fragmentation - and only when it's a certain...
Firstly make sure you have a logon /user in the sql server who has proper permissions regarding the objects the app will access, such as stored...
Try the below for a static pivoting , :
CREATE TABLE #temp
(Product_ID VARCHAR(30) ,
CountryCode VARCHAR(30) ,
Does 'D:MUSERVERDBMUONLINE_DATA.MDF' exist?
Could you post the script or process - you are using to CREATE DATABASE?
Separate names with a comma.