Viewing 15 posts - 15,736 through 15,750 (of 49,552 total)
Jason-299789 (11/9/2012)
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
November 9, 2012 at 8:59 am
The backup is roughly the size of the data within the database. When restored, the dataase is recreated exactly *** it was at time of backup. Hence if a database...
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
November 9, 2012 at 8:52 am
SQLSACT (11/9/2012)
I'm trying to understand what happens to clean pages in the buffer pool (when a select statement brings pages into the buffer pool).
What happens to the pages once 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
November 9, 2012 at 8:42 am
Self-study is possible. As for your chances, no way to answer that, don't know what your knowledge is like. You should have some experience, the exam assumes a couple years...
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
November 8, 2012 at 10:56 pm
jyothimercy (11/8/2012)
Pls send dumps link for increasing the knowledge
I take it you didn't read (or just ignored) my comments above. Using dumps is cheating and using them or supplying them...
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
November 8, 2012 at 10:55 pm
No, but you probably want to ensure that you don't have VLF fragmentation and that there;s sufficient IO bandwidth.
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
November 8, 2012 at 8:10 pm
panwar.jt (11/8/2012)
So why it is called that Include column does not increase non-cluster index size......
Where is that stated?
Include columns won't increase the size of the index key (they're not part...
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
November 8, 2012 at 7:56 pm
MyDoggieJessie (11/8/2012)
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
November 8, 2012 at 7:54 pm
Perfectly normal.What SQL has to do at startup is to open each database and run recovery on it. You can't prevent it, it's a required process.
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
November 8, 2012 at 7:51 pm
Nope. All that's in the log is the user id. The transaction log is not an audit log. Rollbacks and database recovery do not require any information on the login,...
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
November 8, 2012 at 3:28 pm
Evil Kraig F (11/8/2012)
Rebuilding an index drops the index and creates a new one. In doing this, fragmentation is removed, disk space is reclaimed by compacting...
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
November 8, 2012 at 3:26 pm
http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx
http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.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
November 8, 2012 at 3:11 pm
Restricted mode
Shut the app down
Disable logins
several ways.
The reason why not single user is that the single user doesn;t have to be you. If the app gets it, there's trouble.
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
November 8, 2012 at 3:10 pm
Please don't cross post. It just results in people answering already answered questions.
Alspo asked at http://www.sqlservercentral.com/Forums/Topic1382719-1526-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
November 8, 2012 at 3:06 pm
0x01 as a user sid is DBO, that's the user mapped to all sysadmin logins, sa and any other member of the sysadmin role. The log does not contain login...
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
November 8, 2012 at 3:05 pm
Viewing 15 posts - 15,736 through 15,750 (of 49,552 total)