hi there i was wondering same thing when i looked at total server memory i have 6 gig and the target is 52 Gig. Using 64 bit SQL 2005 Also getting...
Im following this as i cannot get the linked sever setup http://www.databasejournal.com/features/mssql/article.php/3691721 I have selected the be...
hmm interesting thread (So it works in run in query but then user cannot click the catalog as you get this xp_prop_oledb_provider error). Any cure...
Is there a way to get the index name followed by the column name and whether this column allows nulls Index_name column_name varchar not null....
Hi there everyone....I now finally got around to runninig some IO Tests using the SQLIO Stress tool Results are on...
Would you be so kind to post your IO Scripts that you have been using. Thanks
Im trying to figure out how to use the tool. I have documentation at hand i understand all the -K etc... sqlio -KW -S10 -Frandom -08 -b8 -LS -F...
Im trying to figure out how to use the tool. I have documentation sqlio -KW -S10 -Frandom -08 -b8 -LS -F Param.txt The param.txt is as follows...
i have just brought over 2000 SQL Db to SQL 2005 Db. If i was doing a backup and restore in sql 2000 from one sql server to another i would run this...
Right now im trying to get up my cluster for SQL as one of the LOG Database grew out of control. When i finally get up system. To clear out the LOG...
i ran your command SELECT 'update statistics' + ' ' + RTRIM(object_name(I.id)) + ' ' + RTRIM(name) /* DATALENGTH (statblob) size, STATS_DATE (I.id,...
Thats a good thread thank you
Thanks i think i revisit my settings, it has worked for a long time then all of sudden failed must be replicating more data Cheers
I got it working now i increased the timeout errors from 300 to 3000 that worked. I was wondering if i could do nic to nic rather than TCP/IP where...
We have two servers Clustered together for SQL 2000 We have replication from Each of the servers Does anyone know what protocol its using for...
Do you know how i can make the script that works now. perhaps a function so i can do select col1, function(col1) as ascii from table
Thanks very much. Now to bring in the col of table ET_CHRG which has COL1 NVARCHAR(100) COL2 NVARCHAR(100) to COL40 nvarchar(100) I can pass in...
im trying to display ascii value of my data in a table Set @ASCII_CONCAT_DISPLAY = @ASCII_CONCAT_DISPLAY + @ASCII_CONCAT This line is taking the...
Just check before i run this....Did you do the DROP CLEANBUFFERS. I have not done this on a production server before and not sure what it doing..(Is...
Nothing.....I tested today all servers reports etc from citrix, outside citrix direct to Server all is good now. Fun this finding nothing....
Separate names with a comma.
