Viewing 15 posts - 6,481 through 6,495 (of 49,552 total)
Can you post the complete definition of ComputerAssetMgt.dbo.uspSaveTest please? Also all definition and all indexes for the table ComputerAssetMgt.asset.tblAssetSoftware
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 8, 2015 at 9:18 am
GilaMonster (3/6/2015)
Then turn traceflag 1222 on, see if you can get the deadlock to reoccur and post the deadlock graph (written to the error log) 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
March 6, 2015 at 3:37 pm
Start by removing the nolock hints (they allow duplicate data and missing rows). Then turn traceflag 1222 on, see if you can get the deadlock to reoccur and post 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
March 6, 2015 at 3:22 pm
ramyours2003 (3/5/2015)
from one of my colleague he said by changing the compatibility mode while restoring the backup from sql 2014 to sql 2012
Then he's either lying or he never...
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 6, 2015 at 2:57 am
ramyours2003 (3/5/2015)
I heard it is possible to restore the SQL 2014 db backup to lower version of sql server (2012,2008r2)
It's not possible. It's never been possible. Databases cannot be restored...
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 6, 2015 at 2:56 am
Can you post sample data and exactly what you want as results?
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 6, 2015 at 2:51 am
Brandie Tarvin (3/1/2015)
He changed the schedule to pick up starting tomorrow (3/2/2015)
Starting three years ago tomorrow, you mean? 🙂
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 3, 2015 at 2:25 pm
Yes, they run fine, I run SQL 2008 R2 on a Win 7 machine (SQL client and server) and both 2008 R2 and 2012 on another Win 7 machine.
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 3, 2015 at 1:56 pm
peter.roothans (3/3/2015)
Hello Gail,Thanks for clarifying that. Now I wonder whether you can have two versions of the same page in a datafile?
No. A page's page number*8kb is it's offset...
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 3, 2015 at 1:50 pm
Index hints aren't likely to help here.
Have you considered full-text indexing?
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 3, 2015 at 9:48 am
The only time a snapshot offloads the work is when it's used in conjunction with database mirroring. You can create a snapshot of the mirror database and report off that,...
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 3, 2015 at 9:48 am
Nitpick: It's Mr Spock, not Dr.
I'm more of a Next Generation/DS9 person, my mother's the one who loves classic Star Trek.
It was the movies, mainly Wrath of Kahn and Voyage...
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 3, 2015 at 9:43 am
peter.roothans (3/3/2015)
I guess SQL Server can not write those pages to the data files since they are all part of a transaction that has not been committed yet.
You guess...
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 3, 2015 at 9:41 am
HookSqlDba7 (2/27/2015)
master - contains all system-wide information.
msdb - holds information...
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 2, 2015 at 11:38 am
It wouldn't have been the backup. Backups don't make data changes, they definitely don't fire DML triggers
Check the job, make sure no one's added another step that goes and updates...
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 2, 2015 at 5:53 am
Viewing 15 posts - 6,481 through 6,495 (of 49,552 total)