Viewing 15 posts - 25,651 through 25,665 (of 49,552 total)
forsqlserver (6/6/2011)
In the architecure given by manish Relational engine is not visible.Where is it?
There's no such component. The entire thing put together is a relational database system.
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 8, 2011 at 4:07 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/Topic1121580-266-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 8, 2011 at 4:05 am
That's not a corruption stack dump. Something's causing access violations (reads of parts of memory that aren't permitted)
Make sure you're up on patches, if the problem persists, call Microsoft CSS....
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 8, 2011 at 4:03 am
What do the new stack dumps say?
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 8, 2011 at 3:40 am
The entire point of an index is to reduce the amount of data that needs to be read to locate rows. Hence any suitable index will reduce the logical (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 8, 2011 at 3:39 am
Phil Parkin (6/8/2011)
GilaMonster (6/8/2011)
All indexes, if they can be used, reduce the IO cost for queries. That's the whole point...
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 8, 2011 at 2:53 am
The clustered index does not force physical storage order of data.
All indexes, if they can be used, reduce the IO cost for queries. That's the whole point of an index.
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 8, 2011 at 2:12 am
Syed Jahanzaib Bin hassan (6/8/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
June 8, 2011 at 2:09 am
Session ID as in the session process identifier on SQL Server? The one that you see in sys.dm_exec_requests and similar DMVs?
If so, you can return a session's SPID -...
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 7, 2011 at 11:49 pm
kwoznica (6/7/2011)
Would it then be safe to say that as long as a database is in full recovery mode it can be used for replication?
No.
Recovery model and replication have...
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 7, 2011 at 11:47 pm
forsqlserver (6/7/2011)
Please satisfy me..
With regard to what?
GSquared and Lowell have already answered your question. There is no replacement for AWE, there does not need to be a replacement for AWE....
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 7, 2011 at 11:46 pm
Fal (6/7/2011)
GSquared (6/7/2011)
Stefan Krzywicki (6/7/2011)
GSquared (6/7/2011)
GilaMonster (6/7/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
June 7, 2011 at 11:39 pm
Yup. There is 0 benefit to multiple log file. Ever.
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 7, 2011 at 2:58 pm
PageLatch != PageIOLatch. The former is contention on the allocation pages. The latter is IO contention.
For IO contention you want to split the files, but not in the same way....
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 7, 2011 at 2:20 pm
Digs (6/7/2011)
phew...lucky I asked:w00t:so I should
DBCC SHRINKFILE (MyDB,10);
?
Why Shrink??????
Have you done some archiving operation that has massively reduced the size of the database, size you won't be reusing?...
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 7, 2011 at 2:16 pm
Viewing 15 posts - 25,651 through 25,665 (of 49,552 total)