Viewing 15 posts - 23,536 through 23,550 (of 49,552 total)
fiddi (9/14/2011)
Timing = memory refresh after 4 hours and something can be "cleared" so that the view can be...
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
September 14, 2011 at 8:48 am
SQLDBA ARJUN (9/14/2011)
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
September 14, 2011 at 8:43 am
Ok... relatively let's see
Stefan Krzywicki (9/14/2011)
As for...
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
September 14, 2011 at 8:37 am
The scoring method is not published.
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
September 14, 2011 at 8:23 am
patla4u (9/13/2011)
HelloCan any tell me, How to do performance tuning of dynamic T-sql?
To be quite honest, much the same way as you tune any T-SQL. Identify the poorly performing code,...
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
September 14, 2011 at 1:22 am
Someone or something is dropping it. SQL is not going to randomly drop objects for no reason.
If it failed to create for any reason you would get an error...
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
September 13, 2011 at 5:16 pm
Lavanyasri (9/13/2011)
hi ,Is it required to run on system databases also ?
what are the temp db changes i need to do before turn on this activity .
Please, please...
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
September 13, 2011 at 5:13 pm
jcrawf02 (9/13/2011)
Evil Kraig F (9/12/2011)
So, for a different topic... Go Jets!
Jets? What are you, nuts? Are you thinking like Knute Rockne? Nobody does a flying wedge anymore! You should be...
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
September 13, 2011 at 3:46 pm
mtillman-921105 (9/13/2011)
Well, except Gail's taking a break from blogging for a while, so I guess we'll have to wait on new blog posts. 🙁
Yeah, cause I don't have any...
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
September 13, 2011 at 3:16 pm
Ninja's_RGR'us (9/13/2011)
You would TAKE LOG BACKUPS.
In all fairness, there are lots of things that cause a log to fill unexpectedly with regular log backups and it's nice to know 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
September 13, 2011 at 3:04 pm
! = NOT
So that's a query for status not equal to sleeping
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
September 13, 2011 at 12:43 pm
In other words...
select ProductID, SUM(OrderQty) AS SumOrderQty, SUM(ScrappedQty) AS SumScrappedQty
from Production.WorkOrder
group by...
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
September 13, 2011 at 11:35 am
Jpotucek (9/13/2011)
Thinking if I tell them to excuded .ldf and .mdf files EXCEPT the ones for the system databases I would be OK.. !?
Only if you like your instance...
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
September 13, 2011 at 11:03 am
qur7 (9/13/2011)
i understand where you coming form but I have been asked to do so in a test enviroment.
As in a non-production server?
If so, set the DB to simple...
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
September 13, 2011 at 9:56 am
That's extraordinarily odd, and slow. A DR SQL Server should have SQL installed and ready to start (if not running as a log shipping secondary) and just need the restore...
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
September 13, 2011 at 9:52 am
Viewing 15 posts - 23,536 through 23,550 (of 49,552 total)