Viewing 15 posts - 16 through 30 (of 182 total)
DO NOT USE VMWARE FOR PRODUCTION SERVERS! It is great for reducing cost of development and qa servers but if you value your career you will not let them put you...
June 28, 2007 at 6:04 pm
To address this issue for developers I have created a unique column in the table that fall in this criteria that are application freindly unlike a numeric id. So oncle the...
June 28, 2007 at 5:58 pm
Yes, in Oracle and DB2. Try "SELECT * FROM SAGITTA..<SCHEMANAME>.STAFF"
June 28, 2007 at 5:25 pm
Registry!
EM uses xp_instance_regwrite and xp_instance_regread to get and modify these settings.
November 30, 2006 at 8:06 am
When the log shipping job was built it would of comaplined should the db not be in stand by mode. The "first_file_000000000000.trn" file is just a place holder in the...
November 29, 2006 at 7:27 am
I know the original post is bulky, but it works perfect and is large due to the formating requirments. I recommend either puting this in a function or use a...
November 28, 2006 at 9:44 am
This article talks about sp_ and procedure cache and the impact.
http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp
November 28, 2006 at 9:34 am
I want to point out that run_time is an int and when a job runs one second after midnight the value will be 1 in the column causing the other...
November 28, 2006 at 9:15 am
On a side not I would also review using "sp_" when writing user procedures as far as a small cost in performance with contect switching, proc cache hit ratio, etc...
November 28, 2006 at 9:04 am
Right, but if you know what driver the connection is using you can find out if it is the driver has a bug or an updated version then update the...
November 28, 2006 at 8:34 am
Select
Top 1 SubString(Convert(Char(4), DatePart(year, Convert(
November 28, 2006 at 8:30 am
The file on the primary data server is being written or in use by another program. I would look and see if the tran log backup job is still writing...
November 28, 2006 at 7:57 am
What is the driver you are using? I would review this first.
November 28, 2006 at 7:47 am
Ok, set statistic IO on and showplan and post the output. After that you can specify the columns needed and then re-run the SQL with statistic IO on and we can...
March 6, 2006 at 8:17 pm
Do you need all columns from all thirteen tables returned. This could be potentialy an enormous amount of data if VarChar(8000), text, ntext and images are present.
I would start by...
March 6, 2006 at 3:02 pm
Viewing 15 posts - 16 through 30 (of 182 total)