Viewing 15 posts - 23,926 through 23,940 (of 49,552 total)
Rajo (8/25/2011)
please suggest can we runDBCC SQLPERF("sys.dm_os_wait_stats",CLEAR); in production hour
or
what is the best solution to clear the wait stats
All that's going to do is wipe out the accumulated...
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 25, 2011 at 8:17 am
chandan_jha18 (8/25/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
August 25, 2011 at 6:26 am
alter TRIGGER tr_UI_tblA ON boat FOR Update,Insert
AS
begin
if update(color)
INSERT INTO Audit_tblA
SELECT inserted.bid,deleted.color,inserted.name, 'U', getdate(),SYSTEM_User
FROM Inserted join deleted on inserted.bid=deleted.bid
ELSE
INSERT INTO Audit_tblA
SELECT *, 'I', getdate(),SYSTEM_User
FROM Inserted
end
GO
The UPDATE function returns true 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
August 25, 2011 at 6:22 am
Welsh Corgi (8/24/2011)
CREATE TRIGGER DML_ON_TABLEA ON TABLEA AFTER INSERT,DELETE,UPDATE AS BEGIN SET NOCOUNT ON; ...
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 25, 2011 at 6:18 am
TOP (99.9999) PERCENT is a row-limiting TOP (if the row count is large enough and SQL cannot assume that it's not). TOP (x) ORDER BY is ignored for non-row limiting...
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 25, 2011 at 5:45 am
Can you post the query 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
August 25, 2011 at 5:32 am
Clustering is High Availability, not scale-out.
Scale-out in SQL is difficult, there's no automatic way of doing it. You may find it easier to tune the database and scale up.
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 25, 2011 at 5:27 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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 25, 2011 at 5:25 am
Ninja's_RGR'us (8/25/2011)
If it's THAT urgent, then I recommend hiring someone. Those articles are amazing but it takes time to assimilate them.
I'm available (though international work is difficult). Usually takes...
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 25, 2011 at 5:24 am
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 25, 2011 at 5:18 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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 25, 2011 at 5:16 am
On what?
Stack dumps are application errors (Not T-SQL errors) and they are typically memory bugs.
If you're planning on writing low-level windows applications (using C++) you'll find lots of information on...
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 25, 2011 at 5:15 am
You sure about that scan?
An index scan won't have a seek predicates property, only index seeks can have seek predicates.
Seek predicates are what the seek looks for in the b-tree,...
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 25, 2011 at 4:51 am
It's an access violation
2011-08-24 18:14:26.890 spid120 * Exception Address = 00000000010E6BD0 Module(sqlservr+00000000000E6BD0)
2011-08-24 18:14:26.890 spid120 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2011-08-24 18:14:26.890 spid120 * Access Violation occurred writing address 0000000000000009
An access...
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 25, 2011 at 4:45 am
No idea. Apply SP4, if the problem persists call customer support. They have tools to read and diagnose stack dumps, we don't.
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 25, 2011 at 2:54 am
Viewing 15 posts - 23,926 through 23,940 (of 49,552 total)