Viewing 15 posts - 46,261 through 46,275 (of 49,552 total)
I'm still not understanding the reason for the detach. If your security is set up properly, a detached database is no more secure than an attached one.
Still....
You're probably getting...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 11, 2008 at 5:08 am
UDBNT (6/11/2008)
Not sure on the validity of (nolock) on a table where you are deleting data?
The hint will be ignored. Deletes have to lock exclusivly, lock hints or no lock...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 11, 2008 at 5:06 am
Be patient. We're not paid to answer questions here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 11, 2008 at 5:05 am
Index definitions?
Has the total number of rows in the table changed since this worked properly?
Are your indexes fragmented? Are the statistics out of date?
I'm not asking just to be a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 11, 2008 at 5:00 am
how many rows is that delete likely to affect?
What indexes do you have on the 2 tables?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 11, 2008 at 2:56 am
Dave (6/10/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 11, 2008 at 1:25 am
Try DBCC UpdateUsage
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2008 at 1:08 pm
Please don't cross post. It wastes people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to
http://www.sqlservercentral.com/Forums/Topic514754-8-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2008 at 1:07 pm
riga1966 (6/10/2008)
What is this Table 'Worktable'?
Is it because it's SQL 2005?
It's a temp table created and used by the query processor to store portions of the result set during processing....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2008 at 12:14 pm
Firstly, I would suggest you take the people responsible for that absurd standard out and shoot them repeatedly. 😉 :hehe:
Seriously now...
How active is the db in question? (transactions/sec)
Is it more...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2008 at 12:08 pm
It can, but then you have all the downsides of dynamic SQL. (permissions, proc cache growth, possible SQL injection)
For something like this, probably 2 procs is easier. For something like...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2008 at 12:01 pm
So you want something like this?
Customer Avg
1234 -2
2345 0.33
9999 ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2008 at 9:07 am
There's no 2000 equivalent for that. Your query checks the plan cache and retrieves the reads and writes for queries that have run in the past whos plans are still...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2008 at 9:04 am
Probably IO_Completion or Async_IO_Completion
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2008 at 8:59 am
Most likely you have a mixture of badly written queries and inadequate indexes. There's no quick fix for this. If it's as critical as you say, you may be best...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2008 at 8:55 am
Viewing 15 posts - 46,261 through 46,275 (of 49,552 total)