Viewing 15 posts - 26,146 through 26,160 (of 49,552 total)
Always err on the side of restoring more log backups, not less. If in your case log backup 1 wasn't needed and you restored full, log 1, log 2, 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
May 13, 2011 at 9:28 am
terrykzncs (5/12/2011)
Obviously you need to test, test and test some more, but it does help to be aware that these little things do make a difference sometimes.
If it makes a...
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
May 12, 2011 at 11:34 pm
Because Task manager lies. Never use it to check SQL's memory, use the Total Memory counter (perfmon)
In short, task manager does not count locked pages, so if you're using AWE...
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
May 12, 2011 at 4:57 pm
Use the Attachements to attach an image to the post (or upload to a photo site), then use the [ img ] tag to show it in your post.
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
May 12, 2011 at 4:55 pm
Eric M Russell (5/12/2011)
You are correct about the Default Trace not logging DML statements. It will trace stored procedure calls and SQL select, even DDL, but not DML (go figure).
It...
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
May 12, 2011 at 4:51 pm
Garadin (5/12/2011)
Something like this instead:
SELECT po.vend_num,
vendaddr.name,
...
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
May 12, 2011 at 4:13 pm
jcrawf02 (5/12/2011)
why do I need an iPad2? suggestions? (32GB wifi version, guy at work selling it)
Err... you don't. 😉
(I'd get Swype, to alleviate my carpal tunnel issues - and...
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
May 12, 2011 at 4:08 pm
You can restore the full and the logs up until the missing one. No further.
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
May 12, 2011 at 3:33 pm
sqlstar2011 (5/12/2011)
BUFFER:BUF @0x0000000244FD1600bhash0x0000000000000000
BUFFER:BUF @0x0000000244FD1600bpageno(1:1230531)
BUFFER:BUF @0x0000000244FD1600bdbid110
BUFFER:BUF @0x0000000244FD1600breferences0
BUFFER:BUF @0x0000000244FD1600bUse17211
BUFFER:BUF @0x0000000244FD1600bstat0xc00109
BUFFER:BUF @0x0000000244FD1600blog0x21597979
BUFFER:BUF @0x0000000244FD1600bnext0x0000000000000000
PAGE HEADER:Page @0x0000000244458000m_pageId(1:1230531)
PAGE HEADER:Page @0x0000000244458000m_headerVersion1
PAGE HEADER:Page @0x0000000244458000m_type2
PAGE HEADER:Page @0x0000000244458000m_typeFlagBits0x4
PAGE HEADER:Page @0x0000000244458000m_level0
PAGE HEADER:Page @0x0000000244458000m_flagBits0x0
PAGE HEADER:Page @0x0000000244458000m_objId (AllocUnitId.idObj)8575
PAGE HEADER:Page @0x0000000244458000m_indexId (AllocUnitId.idInd)256
PAGE HEADER:Page...
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
May 12, 2011 at 3:31 pm
subsonic-abercrombie (5/12/2011)
Now with the R2 stuff in the mix, you gotta wonder how of it has seeped into the test questions and made what you knew previously.
None. 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
May 12, 2011 at 3:31 pm
Eric M Russell (5/12/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
May 12, 2011 at 3:29 pm
Maybe someone should point out to then that it's not just job applicants who need to just spell/grammar checkers on their job applications.
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
May 12, 2011 at 11:34 am
Looks like a page. The FileID:PageID is how SQL refers to a specific page. Read up on DBCC Page (undocumented) for getting the ID of the table that owns the...
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
May 12, 2011 at 11:32 am
Not necessarily. Locks are just one of the many things it could be waiting 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
May 12, 2011 at 10:24 am
Ok, now you're clear...
What's the primary key of the Purchasing table?
p.s. If you're going to use Try Catch, do something with the error, otherwise just leave the error handling out....
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
May 12, 2011 at 10:24 am
Viewing 15 posts - 26,146 through 26,160 (of 49,552 total)