Viewing 15 posts - 20,386 through 20,400 (of 49,552 total)
Roy Ernest (2/10/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
February 11, 2012 at 3:32 am
Doesn't make the slightest difference, the way the columns are specified in the create table is not necessarily the way they are stored on the page, and the order of...
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
February 10, 2012 at 3:33 pm
MCTS SQL 2008 developer (Exam 70-433), MCITP SQL 2008 developer (Exam 70-451)
MCTS SQL 2008 administrator (Exam 70-432), MCITP SQL 2008 administrator (Exam 70-450)
And don't underestimate those MCM 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
February 10, 2012 at 2:49 pm
One thing not to do...
Tuesday morning: 2 hour 'strategy' meeting with developers (actually a glorified progress and task allocation meeting)
Thursday afternoon: 4 hour departmental progress meeting (including dev team)
Yes, 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
February 10, 2012 at 2:42 pm
If you start SQL Server in single user mode, than any member of Local Administrators is a sysadmin and then you can connect (I'd suggest SQLCMD not SSMS) and add...
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
February 10, 2012 at 2:10 pm
Koen Verbeeck (2/9/2012)
Let me see, where did I put my magic wand?
Actually, in this specific case....
Magic wand for this query: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
February 10, 2012 at 12:50 pm
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here if...
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
February 10, 2012 at 12:45 pm
mjbkm (2/10/2012)
It isn't even anything I need to install. It is just code that "informs" me -...
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
February 10, 2012 at 12:44 pm
Rowles (2/10/2012)
So a huge insert into would be given a single LSN?
No.
Each log record has it's own LSN, a log record would be a single row of the insert or...
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
February 10, 2012 at 12:17 pm
pdanes (2/10/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
February 10, 2012 at 12:01 pm
http://sqlinthewild.co.za/index.php/2011/06/21/are-all-updates-split-into-delete-insert/
Yes, update can cause page splits in 2 situations
1 - The update grows the row (variable length column increases or null value becomes not null) and there is not...
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
February 10, 2012 at 11:59 am
You might also want to take a look through this: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
Not much of backups, but a lot of other stuff.
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
February 10, 2012 at 10:30 am
Yes. A backup is an online operation, it takes no locks and it will not block normal user activity.
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
February 10, 2012 at 9:32 am
The fact that it's read-only is not what affects its presence/absence in a diff backup. A read-write filegroup that's had no changes since the last full backup also won't get...
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
February 10, 2012 at 9:29 am
aaa-322853 (2/10/2012)
Am I correct in thinking that if you mark a file group as read only then these file groups would be excluded from the relevant backups?
No. It'll be 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
February 10, 2012 at 8:15 am
Viewing 15 posts - 20,386 through 20,400 (of 49,552 total)