Viewing 15 posts - 27,586 through 27,600 (of 49,552 total)
Data cache and plan cache are not synchronised. Clearing one does not clear the other, removing pages from one does not remove pages from the other.
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
March 1, 2011 at 4:14 pm
Interview question? Homework?
sysobjects is deprecated, included only for backward compat, should not be used any longer, will be removed from a future version.
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
February 28, 2011 at 10:49 pm
In SQL 2005 and above, the inserted and deleted tables are materialised from the row version store in TempDB, not the transaction log. Hence they do not cause log reads...
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
February 28, 2011 at 10:46 pm
Do you know that the query is paralleling? Do you know that the paralleling is inappropriate? Do you know that it is causing a problem?
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
February 28, 2011 at 10:43 pm
Yes, it will, because SSMS recreates the entire table with a limited timeout.
Make the change in the designer but instead of clicking save, generate the script and run it from...
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
February 28, 2011 at 5:38 pm
You can never update an identity column. Identity insert allows you to insert an explicit value into it, but there is no similar option to allow updates.
To remove the identity...
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
February 28, 2011 at 4:51 pm
Brandie Tarvin (2/28/2011)
Just to be clear, we're still talking only about code here, right? And data encryption is still a necessary, and valid, business process, depending on what's being encrypted
Data...
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
February 28, 2011 at 10:50 am
Please post new questions in a new thread. Thanks
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
February 28, 2011 at 10:48 am
The plan cache is part of the buffer pool sharing with the data cache and a few other things. The mem-to-leave (non-paged memory) is for memory allocations not in 8k...
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
February 28, 2011 at 10:46 am
Please post a thread in the data corruption forum and include the complete output from a CheckDB with no_infomsgs, all_errormsgs.
Check the SQL error log from the time that checkDB runs,...
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
February 27, 2011 at 6:06 pm
Raghavender (2/26/2011)
If this table only resides on...
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
February 27, 2011 at 10:52 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/Topic1070069-5-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
February 26, 2011 at 4:43 pm
PaulB-TheOneAndOnly (2/26/2011)
if SS2K5 then take a look at "alter database for attach_rebuild_log"if SS2K then take a look at "dbcc rebuild_log"
attach_rebuild_log only works if the DB was cleanly shut down. Otherwise...
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
February 26, 2011 at 4:39 pm
See the process here for hack-attaching the database and repairing it. http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
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
February 26, 2011 at 4:39 pm
None of the above.
CheckDB checks for database corruption, and it's a very CPU and IO intensive process. Run that and you will degrade performance. Same with index rebuilds.
If a query...
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
February 26, 2011 at 4:35 pm
Viewing 15 posts - 27,586 through 27,600 (of 49,552 total)