Viewing 15 posts - 17,551 through 17,565 (of 49,552 total)
Steve Jones - SSC Editor (7/18/2012)
abatej (7/18/2012)
I can't believe no one has mentioned Asimov yet!Foundation?
I read that years and years ago. Have it in audio format, and have a 4...
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
July 18, 2012 at 11:29 am
And to reinforce the point.
CREATE PROCEDURE SearchHistory
(@Product int = NULL, @OrderID int = NULL, @TransactionType char(1) = NULL, @Qty int = NULL)
AS
SELECT ProductID, ReferenceOrderID, TransactionType, Quantity,
TransactionDate, ActualCost from Production.TransactionHistory
WHERE (ProductID...
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
July 18, 2012 at 11:06 am
dbaxter-1000885 (7/18/2012)
So what does SQL do from 7:22 until 10:41 between the time the database starts and the recovery begins.
Reading over the log, it has to check every VLF's header....
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
July 18, 2012 at 10:51 am
I'm not sure how to take that comment soo...
No, SQL does not always short circuit, it cannot be depended on like you can with C#. The basic reason is twofold
1)...
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
July 18, 2012 at 10:47 am
Cross apply to sys,dm_exec_sql_text
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
July 18, 2012 at 10:18 am
Gut feel here - severe VLF fragmentation and the recovery hasn't started (SQL's still reading over the log). When you get this back up, read Kimberly Tripp's blog post 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
July 18, 2012 at 10:02 am
Jasmine D. Adamson (7/18/2012)
It should be "Where @variable is null OR column = @variable" so we can take advantage of short-circuits.
SQL doesn't short circuit evaluations. Only happens in some odd...
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
July 18, 2012 at 10:00 am
Check the error log. Crash recovery logs in there.
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
July 18, 2012 at 8:16 am
danielfountain (7/18/2012)
IIRC you only used to be able to use Microsoft letters after your name and on emails for a set period.
The SQL exams never expired before. 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
July 18, 2012 at 8:07 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
July 18, 2012 at 6:15 am
Check that there isn't a 3rd party backup tool (eg hyperbak)
Check that you can restore the backup right after taking it (verifyonly is not good enough)
Check that the SQL instances...
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
July 18, 2012 at 6:13 am
CREATE TABLE Times (
SomeTime TIME,
SomeStatus INT
);
INSERT INTO Times (SomeTime, SomeStatus)
VALUES
('14:00', 0),
('15:00', 0),
('16:00', 1),
('17:00', 2),
('18:00', 2),
('19:00', 1),
('20:00', 0),
('21:00', 0),
('22:00', 1),
('23:00', 1),
('00:00', 0)
SELECT t.SomeTime ,
...
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
July 18, 2012 at 6:12 am
Log backups or restores take seconds unless there's GBs of data in the log. You're not likely to save significant amounts of time, and checking the log to see 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
July 18, 2012 at 2:50 am
To be honest, that'll be the client tool, whatever you are using to type in, execute and then read the query 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
July 18, 2012 at 2:49 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
July 18, 2012 at 2:38 am
Viewing 15 posts - 17,551 through 17,565 (of 49,552 total)