Viewing 15 posts - 38,476 through 38,490 (of 49,552 total)
Pleasure.
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
June 12, 2009 at 12:10 pm
About the only regret is that I took a job immediately as I finished my degree. A week after I accepted the job I got an offer for a full...
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
June 12, 2009 at 11:06 am
GDI Lord (6/12/2009)
[OT]What is it with the high visibility of the South Africans here (seemingly) all of a sudden? Are we taking over the forum?
[/OT]
SADeveloper.net is down, pending a new...
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
June 12, 2009 at 10:54 am
In Bulk logged recovery bulk operations are minimally logged. When the transaction log backup runs, it goes through the database and finds all of the extents that were changed 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
June 12, 2009 at 8:01 am
#include "Usual caveats and warnings about using undocumented commands"
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
June 12, 2009 at 7:46 am
Shouldn't be a problem. Log backups can be taken in both full and bulk logged and can restore fine on another server. Just don't switch to simple or you'll have...
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
June 12, 2009 at 7:32 am
Select Col1, Col2, Col3
FROM SomeTable
WHERE Col3 = x
AND Coln < DATEADD (HOUR, -24, GETDATE())
Or have I misunderstood your requirement? If so, please post some sample data and expected...
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
June 12, 2009 at 7:26 am
Have you looked in Books Online? On MSDN[/url] and Technet[/url]?
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
June 12, 2009 at 7:17 am
Grant Fritchey (6/12/2009)
Now if only people will read and follow the advice here.
Read it is a possibility. Expecting everyone to follow the advice might be a little too much to...
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
June 12, 2009 at 7:09 am
darth.pathos (6/6/2009)
It's this second part that's really giving me trouble.suggestions appreciated...
Chris
Do some googling for the undocumented stored proc sp_MSforeachtable
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
June 12, 2009 at 7:08 am
Sergiy (6/11/2009)
Christopher Stobbs (6/11/2009)
Index should be: (BitField, DateField).If BitField is really a BIT field then it cannot be included into an index.
Sure it can. It's only the LOB data types...
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
June 12, 2009 at 6:57 am
600 MB of a 6 GB database isn't much. It's 10% of the data file size. Which, incidentally, is the default autogrow %
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
June 12, 2009 at 6:56 am
Update usage does not update stats. It updates the space used metadata. That's what's wrong in this case.
Jeff is 100% correct. You need to run updateusage before running that. 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
June 12, 2009 at 6:50 am
RPSql (6/11/2009)
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
June 11, 2009 at 2:25 pm
mmartin (6/11/2009)
Maybe it is corruption on a non-date field.
If it was corruption the error would not say 'date time conversion'. It would say something like this "SQL Server detected 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
June 11, 2009 at 2:16 pm
Viewing 15 posts - 38,476 through 38,490 (of 49,552 total)