Viewing 15 posts - 27,016 through 27,030 (of 49,552 total)
boredom
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 28, 2011 at 9:46 am
Please note: 3 year old thread.
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 28, 2011 at 9:40 am
TheSQLGuru (3/28/2011)
The official term is "Intra-Query Parallel Thread Deadlocks", coined in 2008 by Bart Duncan. http://blogs.msdn.com/b/bartd/archive/2008/09/24/today-s-annoyingly-unwieldy-term-intra-query-parallel-thread-deadlocks.aspx
Isn't that a single session deadlocking itself?
A deadlock between multiple sessions on a single...
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 28, 2011 at 9:39 am
Looks like it'll work, however see my and Jeff's previous posts.
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 28, 2011 at 9:12 am
just make sure you know what nolock does first. It's not just about dirty 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
March 28, 2011 at 9:05 am
Oh, and by the way, what you have there is not a good table design. If it were me, I'd drop that persisted column, drop the identity column, then in...
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 28, 2011 at 8:33 am
shifty1981 (3/28/2011)
Ok then. Later on when it goes to write it, will it update each file in parallel or sequentially? And how much later on?
Depends on the underlying disk architecture,...
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 28, 2011 at 8:31 am
Open up Books Online and read up on SQL Agent and jobs.
While you're there, read up about backups and integrity checks. SQL databases can go corrupt too, and backups 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
March 28, 2011 at 8:21 am
It gets added to the index immediately, but that's in memory only. SQL will write the changed pages back to disk later on, not as part of the transaction.
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 28, 2011 at 8:19 am
Sachin Nandanwar (3/28/2011)
Truncation is the process of marking the inactive VLF's as active
marking active VLFs as inactive.
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 28, 2011 at 8:14 am
Go ask your DBA to create a SQL Agent job, schedule it for midnight daily and ask him to add that single line of code in the job step (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
March 28, 2011 at 8:08 am
Brandie Tarvin (3/28/2011)
We're assuming ID is the column that needs resetting. But given the structure of the rest of the table, that's quite likely.
It is, look at the OP's revised...
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 28, 2011 at 7:56 am
Jeff Moden (3/28/2011)
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 28, 2011 at 7:53 am
The updates to the indexes are done in memory. The query processor doesn't write directly to disk.
It'll be sequential, but to pages in memory, not to the disk.
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 28, 2011 at 7:52 am
That's actually very simple.
Set up a SQL Agent job scheduled to run at midnight. The job step needs a single line of T-SQL
DBCC CHECKIDENT (CALLS, RESEED, 0)
Needless to say, this...
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 28, 2011 at 7:39 am
Viewing 15 posts - 27,016 through 27,030 (of 49,552 total)