Viewing 15 posts - 31,936 through 31,950 (of 49,552 total)
Restore never runs a checkDB automatically. What you're likely seeing is a message in the error log that states
CHECKDB for database 'Testing' finished without errors on 2010-05-24 06:44:53.317 (local time).
Do...
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
July 8, 2010 at 4:00 am
There will not be R2 exams.
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
July 8, 2010 at 2:58 am
SQLServer-Training.com (7/8/2010)
Now Sure, how this post is being included in daily news letters that too after two years. Old post should not republished.
It's because there are new 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
July 8, 2010 at 2:56 am
r.casteres (7/8/2010)
To get all the chances on my side, can you send me your summary, resumé, anything that helped you to pass the exam.
How would my resume help you...
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
July 8, 2010 at 2:51 am
Gianluca Sartori (7/8/2010)
Alvin Ramard (7/7/2010)
Exec dbcc TimeWarp @Date = '1976-09-01'AH-AAAH!!! So, you're trying to get rid of me!
I wasn't even a light in the eyes of my parents...:w00t:
My thoughts exactly,...
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
July 8, 2010 at 2:49 am
9 million rows shouldn't be that hard to deal with if there are appropriate indexes and well-written SQL. Please post query, table definitions, index definitions and execution plan, as per...
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
July 8, 2010 at 2:47 am
scott.pletcher (7/7/2010)
I have tested DENY, even up to db_owner, and it works (interesting that it worked even for db_owner).
Yes, but sysadmins (and by that I mean only members of 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
July 7, 2010 at 9:52 am
Mike John (7/7/2010)
If the collations match and the data is really the same then I would start to suspect a corruption somewhere,
Corruption (if you're talking actual data page corruption) would...
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
July 7, 2010 at 9:45 am
How many rows?
Try download something like SQLDataCompare (Redgate) demo and use it to verify that the data in the two tables really is absolutely identical.
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
July 7, 2010 at 9:43 am
scott.pletcher (7/7/2010)
DENY overrides GRANTs and will still prevent DELETE from that table, unless a user override/context switch has occured (such as "EXEC AS").
Or the user is sysadmin.
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
July 7, 2010 at 9:41 am
http://msdn.microsoft.com/en-us/library/ms188338%28SQL.90%29.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
July 7, 2010 at 9:36 am
Take a look through this article - http://www.sqlservercentral.com/articles/64582/
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
July 7, 2010 at 8:56 am
Please post your question in a new thread and include details such as the query, table definition and index definitions.
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
July 7, 2010 at 8:53 am
If the record of the change has already been dropped from the default trace (which only contains 5 files of 20MB each), no.
If you wish to track this kind...
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
July 7, 2010 at 6:30 am
Maybe start with this series: http://www.sqlservercentral.com/articles/Indexing/68439/
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
July 6, 2010 at 11:54 pm
Viewing 15 posts - 31,936 through 31,950 (of 49,552 total)