Viewing 15 posts - 17,266 through 17,280 (of 49,552 total)
http://ola.hallengren.com/versions.html
http://sqlfool.com/2011/06/index-defrag-script-v4-1/
No need to roll your own solution.
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
August 1, 2012 at 12:16 pm
Robert Heynen-454800 (8/1/2012)
Lesson learned...I thought by separating the temp table 2 statement in parenthesis, it was separated from the temp table 1 statement, and no alias would be needed...
If 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
August 1, 2012 at 10:12 am
Nothing to do with temp tables and not a bug.
A subquery (like with an IN) can reference any column in the tables inside the subquery or outside the subquery. Otherwise...
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
August 1, 2012 at 9:28 am
🙂
Can't you assign code to bugs, make bug notes in the checkin comments, etc?
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
August 1, 2012 at 8:34 am
It'll recover the model database, that's all. A restore statement run against a particular database cannot affect any other database on the server.
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
August 1, 2012 at 8:28 am
Boby B Jacob (8/1/2012)
Does SQL Server 2008 and higher version supports *= operator of Joins?
2008 does in 80 compat mode. 2012 does 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
August 1, 2012 at 8:27 am
Yes.
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
August 1, 2012 at 8:16 am
Providing that all the log backups since yesterday's backup have already been restored, yes. As I said, full backups do not truncate the transaction log.
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
August 1, 2012 at 8:15 am
Two words: Source control.
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
August 1, 2012 at 7:58 am
You may want to fix that setting.
Important:
In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that explicitly set the option to OFF...
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
August 1, 2012 at 7:49 am
Full backups do not truncate the transaction log.
Not sure why you would want to take hourly full backups...
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
August 1, 2012 at 7:48 am
Execution times look pretty comparable to me. Did you run the test multiple times and average the results?
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
August 1, 2012 at 7:47 am
vinod.saraswat (8/1/2012)
Can you put some light why it has happend (If you have any idea about it).
No (other than the theory on what an access violation is, which you can...
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
August 1, 2012 at 7:40 am
Run RESTORE DATABASE model WITH RECOVERY, then go and fix that maintenance plan. The 'backup the tail of the log' is for disaster scenarios
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
August 1, 2012 at 7:37 am
Don't understand the question.
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
August 1, 2012 at 7:34 am
Viewing 15 posts - 17,266 through 17,280 (of 49,552 total)