Viewing 15 posts - 16 through 30 (of 262 total)
Or is there a way to avoid this.
Sure. Developers shouldn't change stored procedures. It is a DBA responsibility to accomodate multiple requests from developers.
November 20, 2008 at 6:29 am
It wasn't so much about SQL 7 as about using execute instead of sp_executesql.
Running multiple ad hoc queries, you have to make sure that dynamic sql is used properly...
November 19, 2008 at 5:08 am
Per MS: http://www.microsoft.com/technet/prodtechnol/sql/70/proddocs/diag/part3/75528c13.mspx?mfr=true
that is a result of:
1. Poor indexing.
2. High load.
Fast workaround would be to change a default value of QueryWait on server Advanced Properties from -1 to...
November 18, 2008 at 1:55 pm
Sure. Good luck and take a look on syntacs suggested in Garadin message. Not that old syntacs is not going to work, but since you are new to SQL server...
November 14, 2008 at 12:47 pm
Why did you concentrate on the SQL server parameters only?
What about your network traffic? Do you have a single network card on this box? What is the network speed?
November 14, 2008 at 12:40 pm
Remove single quotes from (('LR.CompCurrSales'-'LR.CompHistSales'/'LR.CompHistSales')*
You are working with the field values, not with the literals.
November 14, 2008 at 12:36 pm
How about using a port redirection?
Leave TCP at the default port configuration and then use a port redirection for the "corporate port".
Take a look on this third party rool:
November 11, 2008 at 7:25 am
If it's a MS Access, then go to a query tab; draw your query and use the pregenerated SQL statement in your code...
November 7, 2008 at 12:28 pm
This paper discusses the implementation of Change Data Capture in SQL Server 2008 and how it is superior to the traditional change tracking mechanisms in the context of data warehousing...
October 23, 2008 at 9:52 am
1. Add HDD space.
2. Turn your database recovery model to Bulk-Logged for the time of your UPDATE operation (if you are using large data types).
3. Follow Lynn's suggestion
October 23, 2008 at 9:36 am
set nocount on
declare @jobid uniqueidentifier
select @jobid = job_id from msdb..sysjobs_view where [name] = 'JobName'
CREATE TABLE #xp_results (job_id ...
October 23, 2008 at 7:52 am
1. Not enough space for backup. (Most usual).
2. Remote device failure (check the disk).
October 23, 2008 at 6:52 am
October 23, 2008 at 6:41 am
October 22, 2008 at 11:23 am
Viewing 15 posts - 16 through 30 (of 262 total)