Viewing 15 posts - 46,276 through 46,290 (of 49,552 total)
Why do you want to detach the database when you close the app?
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:41 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic514284-145-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 8:40 am
Can you give us the expected output for the given sample data please?
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:34 am
Could you post the query that doesn't work on SQL 2000?
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 9, 2008 at 3:12 pm
I won't call that perfect. Your elapsed time is still way higher than your CPU time.
Run the query in 1 window of management studio, in the other query sys.dm_exec_requests and...
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 9, 2008 at 3:10 pm
Word of advice from someone who's been there. SQL 2000 does not play nice on Itaniums. I strongly recommend you consider upgrading to SQL 2005. It's a lot, lot 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 9, 2008 at 3:03 pm
GSquared is right. I'm going through that exercise at the moment with a number of tables. You'll have to create a new table with the textimage where you want it,...
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 9, 2008 at 2:55 pm
In general, the time difference between CPU time and elapsed time is the time that the worker executing that query spent waiting.
It may have been waiting for IO to be...
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 9, 2008 at 2:24 pm
I seem to recall that the bcp puts a read lock on the tables. Can't remember if it's a table lock or if it locks pages at a time. The...
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 9, 2008 at 1:39 pm
I had the 'pleasure' of working with a jdbc app a while back. From what I recall there is some property of the jdbc driver that determines whether things are...
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 9, 2008 at 1:17 pm
I don't believe you can. SSIS packages are designed to run as scheduled jobs independent of users.
You may be able to write a small front end app that asks for...
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 9, 2008 at 1:14 pm
You don't need an extended procedure for that. You should also not be considering writing extended procs unless you have a very good grasp of C++. It's waaay easy to...
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 9, 2008 at 1:02 pm
Set up a profiler trace with the events you want. The default template is mostly good (though you may want to check TextData for either RPC completed or SQLBatch Completed....
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 9, 2008 at 12:54 pm
You've run into a classic case of parameter sniffing (or more accurately, the lack thereof). See this article[/url] for some details on the cause.
Recommendation: Split into 2 stored procs. Pass...
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 9, 2008 at 12:49 pm
I don't have the time right now to do a full analysis, but one thing I noticed from the exec plan is that the row estimates are off. Way off.
Estimated...
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 4, 2008 at 2:42 am
Viewing 15 posts - 46,276 through 46,290 (of 49,552 total)