Viewing 15 posts - 29,866 through 29,880 (of 49,552 total)
If there is absolutely no data loss allowed under any circumstances, then a maintenance plan, no matter what is in it, is not sufficient. You'll need a substantial DR plan,...
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
October 19, 2010 at 1:25 am
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
October 18, 2010 at 3:13 pm
upstart (10/18/2010)
Because a cursor is an actual object inside the database engine, ...
Copy-paste from http://blogs.techrepublic.com.com/datacenter/?p=1741
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
October 18, 2010 at 1:48 pm
upstart (10/18/2010)
After running DBCC SHRINKFILE once, one it again with the 'Truncate Only' option and you should have your log file back down to a manageable size.
The truncate only option...
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
October 18, 2010 at 1:39 pm
Craig Farrell (10/18/2010)
It can be a lot more complex than that but start there. 🙂
Kalen Delaney did a talk for the 24 hours of PASS earlier this year titled...
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
October 18, 2010 at 1:31 pm
chris.s.powell (10/18/2010)
Will the .ldf return to the initial size of 2MB after all transaction have completed?
No and honestly that's the last thing that you want to happen. Growing the 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
October 18, 2010 at 1:29 pm
Craig Farrell (10/18/2010)
To go back to our earlier discussion on bad drivers in random places, apparently hit'n'runs are universal.
I nearly got side-swiped into a concrete barrier this morning,...
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
October 18, 2010 at 1:21 pm
chris.s.powell (10/18/2010)
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
October 18, 2010 at 1:21 pm
sturner (10/18/2010)
just increment a value in a table whenever the function is executed.
Functions are not allowed to cause side-effects. They cannot insert, update or delete from permanent or temporary tables.
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
October 18, 2010 at 12:37 pm
GSquared (10/18/2010)
The error quoted indicated the problem was with the log file.
Correct. However the error indicates that the database was not cleanly shut down (all committed transactions written...
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
October 18, 2010 at 12:31 pm
YTZ (10/18/2010)
..... SQL Server unclean shutdowm. ......
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
October 18, 2010 at 12:25 pm
GSquared (10/18/2010)
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
October 18, 2010 at 12:23 pm
Personal preference, probably not. Looks a little too wide for my tastes for a clustered index.
Check some of the queries doing the lookups, are they selecting majority of the columns...
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
October 18, 2010 at 12:21 pm
Please post new questions in a new thread
Thanks
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
October 18, 2010 at 12:14 pm
There's probably nothing wrong with the job. Not all performance problems go away with a stats update. You may well have a combination of poor indexing and poorly written queries.
Check...
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
October 18, 2010 at 8:08 am
Viewing 15 posts - 29,866 through 29,880 (of 49,552 total)