Viewing 15 posts - 616 through 630 (of 1,131 total)
Related my be the post titled ;701 "insufficient System Memory"' at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=344369
SQL = Scarcely Qualifies as a Language
July 9, 2007 at 1:50 pm
Actually, I stand corrected. There is a MS blog on the SQL Storage Engine that has some insight and part of the blog is posted below. Looks like the logic of...
SQL = Scarcely Qualifies as a Language
July 9, 2007 at 1:31 pm
Based on the SQL posted, non-clustered indicies are being defragemented twice - one when the clustered index is defragemented, which also rebuilds the non-clustered indicies, and then again if it was...
SQL = Scarcely Qualifies as a Language
July 8, 2007 at 2:56 am
IBM x3950 with 16 Dual Core 3Ghz CPUs and 32Gb of memory with average, maximum and minimum durations in milliseconds from 10 executions:
SQL Server 2000:
SQL = Scarcely Qualifies as a Language
July 7, 2007 at 9:05 pm
"Can you not use the DTS Dynamic Properties task to assign the gv value from the INI file?"
Yes the package does contain a Dynamic Properties, but the INI file...
SQL = Scarcely Qualifies as a Language
July 7, 2007 at 7:44 pm
Do not know if this approach would work for your requirments, but you use DTS.
1. Install the DTS run time where the "night operators" have access.
2. Create a DTS package,...
SQL = Scarcely Qualifies as a Language
June 30, 2007 at 4:19 pm
Just to let you know, none of the approaches suggested will work!
You can grant execute on xp_cmdshell but the internal code of xp_cmdshell will return an error if the invoker...
SQL = Scarcely Qualifies as a Language
June 30, 2007 at 1:13 pm
Your solution appears to be convoluted - selects nested within selects are not good.
create table Exports2001
(Districtinteger not null
,Teritoryinteger not null
, stat_monthinteger not null
, all_val_month integer not null
, constraint Exports2001_P primary...
SQL = Scarcely Qualifies as a Language
June 28, 2007 at 3:54 pm
There is a bug in Task Manager that applies to Windows 2000 and 2003, where the amount of memory used by a process is not correctly reported in all cases.
Also,...
SQL = Scarcely Qualifies as a Language
June 28, 2007 at 1:49 pm
'Your statement that 'A login with msdb database role TargetServer, can view any job.' was a great eye oener. How have I missed this tidbit? "
Because it is not...
SQL = Scarcely Qualifies as a Language
June 27, 2007 at 6:55 pm
Please provide DDL and sample data as described at http://www.aspfaq.com/etiquette.asp?id=5006
"The obsolete date will be the last time that recipe was used before the recipe changed"
This is not clear and without...
SQL = Scarcely Qualifies as a Language
June 26, 2007 at 10:58 pm
"I hope this is a simple one to answer."
Unfortunately, it is not a simple answer.
Here are some of the rules that apply to SQL Server 2000 jobs. These rules...
SQL = Scarcely Qualifies as a Language
June 26, 2007 at 10:18 pm
"When to script"
EM definitely for Jobs, DTS, log shipping and replication.
I have worked with Sybase or SQL Server since 1993 (inter-mixed with some Oracle), before there were...
SQL = Scarcely Qualifies as a Language
June 23, 2007 at 2:47 pm
"What FTP softwares can restart?
Most will restart, just check the manual before buying.
If using the internet or for sensitive information, try Sterling Commerce or Tumbleweed as they do encryption.
"Why not...
SQL = Scarcely Qualifies as a Language
June 23, 2007 at 2:38 pm
Do you want to configure once and then distribute ?
The Client Network configuration is in the registry at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
SQL = Scarcely Qualifies as a Language
June 23, 2007 at 11:44 am
Viewing 15 posts - 616 through 630 (of 1,131 total)