sqlloginpermissions.blogspot.com
sql login permissions: Long wait times for simple SQL on 2005
http://sqlloginpermissions.blogspot.com/2012/03/long-wait-times-for-simple-sql-on-2005.html
Friday, March 30, 2012. Long wait times for simple SQL on 2005. I have an existing application deployed on many SQL 2000 servers running without issue. We installed SQL 2005 (8 way DualCore) and the most simple trivial SQL statements are taking an extreme amount of time (e.g. an identical query in 2000 took 10 ms is taking a couple of minutes in 2005). The data in the tables being queried are very small (low row count 400; and low row size 1k). Can you include more details on the queries. PAGE ORIENTATIO...
sqlloginpermissions.blogspot.com
sql login permissions: Long time for flush IDES
http://sqlloginpermissions.blogspot.com/2012/03/long-time-for-flush-ides.html
Friday, March 30, 2012. Long time for flush IDES. I notice, sometimes, spikes in transaction time on production database. Usual. Transaction time is 30 ms, but sometimes its go up to 100-400 ms. When I look. Into backup of log files (I use Log Explorer), to see whats happened during. That transactions, I see what most of time was spend for "flush IDES". Operation. The operation do some changes in sysindexes table - what it change. Turned off autoupdate statistics option, create statistic option, and torn.
sqlloginpermissions.blogspot.com
sql login permissions: Long text column not accepting
http://sqlloginpermissions.blogspot.com/2012/03/long-text-column-not-accepting.html
Friday, March 30, 2012. Long text column not accepting. I am very new in SQL server. I created a table where one column is varchar(8000). But when I am trying to insert value from enterprise manager this column cann't accept a long text value. I counted that its' capacity is 1012 charecters. I have tried a lot but don't know how to solve this. I really need help from you. Pls help. What's the total length of your record? Thanx friends. From Query Analyzer it worked. And how large is "very large"? Long ti...
sqlloginpermissions.blogspot.com
sql login permissions: Long time for flush IDES
http://sqlloginpermissions.blogspot.com/2012/03/long-time-for-flush-ides_30.html
Friday, March 30, 2012. Long time for flush IDES. I notice, sometimes, spikes in transaction time on production database. Usual. Transaction time is 30 ms, but sometimes its go up to 100-400 ms. When I look. Into backup of log files (I use Log Explorer), to see whats happened during. That transactions, I see what most of time was spend for "flush IDES". Operation. The operation do some changes in sysindexes table - what it change. Turned off autoupdate statistics option, create statistic option, and torn.
sqlloginpermissions.blogspot.com
sql login permissions: long transaction
http://sqlloginpermissions.blogspot.com/2012/03/long-transaction.html
Friday, March 30, 2012. I am still not very proficient in SQLServer. So apology if the. We have a script to clean old unwanted data. It basically deletes. All rows which are more than 2 weeks old. It deletes data from. 33 tables and the number of rows in each table runs into few millions. What I see in the script (not written by me :-) ) is that all data is. Deleted within a single BEGIN TRANSACTION and COMMIT TRANSACTION. As. I have background in informix, such an action in Informix may result. As you p...
sqlloginpermissions.blogspot.com
sql login permissions: Long text
http://sqlloginpermissions.blogspot.com/2012/03/long-text_30.html
Friday, March 30, 2012. I have written a UDF that calls itself and nests its operation. The output. Is a varchar value in XML format. But sometimes the XML is more than 8000. Characters and varchar is small for that. It is not possible to use text. Data type. What can I do? Any help would be greatly appreciated,. LeilaCan you form the XML using FOR XML instead of your own recursive UDF? Http:/ www.sqljunkies.com/weblog/amachanic. Leila" leilas@.hotpop.com wrote in message. Data type. What can I do? Is a ...
sqllocaldata.blogspot.com
sql local data: Locking
http://sqllocaldata.blogspot.com/2012/03/locking_4792.html
Friday, March 30, 2012. I have set the Isolation Level to Read Uncommitted but the tables are still. Locked after i have run a select in Query Analyzer, can anyone explain why. Can you provide more details? Hoe did you set the isolation level. Can you reproduce this from two. Connection in query analyzer? Tibor Karaszi, SQL Server MVP. Http:/ www.karaszi.com/sqlserver/default.asp. Http:/ www.solidqualitylearning.com/. Http:/ www.sqlug.se/. News:eGpQzej$EHA.2572@.tk2msftngp13.phx.gbl. Clive Godden" clive&...
sqllocaldata.blogspot.com
sql local data: locking
http://sqllocaldata.blogspot.com/2012/03/locking_7790.html
Friday, March 30, 2012. How does SS2000 lock by default for a select, update and delete statement. Is it row level, page, table? It depends. Default is row level, but optimizer may escalate it to page. Or table level locking if it see fit. You can force it to stay at row. Level by using query hints. Check query hints in BOL. How does SS2000 lock by default for a select, update and delete statement. Is it row level, page, table? Eric is correct but I want to make one slight comment. SQL Server never.
sqllocaldata.blogspot.com
sql local data: Locking
http://sqllocaldata.blogspot.com/2012/03/locking_2466.html
Friday, March 30, 2012. Can anyone point me to a doc that describes what the default locking levels. Were across different versions of SQL, i.e. row vs. page vs. table, going. All the way back to version 4.2, and what the circumstances would have been. When SQL decides what to use over the other? Guess versions 4.2 and 6.x were. Page-locking no matter what if I remember correctly, but want to make sure. Before I tell my colleagues rubbish. Thanks in advance,. Andrew J. Kelly SQL MVP. Thanks in advance,.