Viewing 15 posts - 33,766 through 33,780 (of 49,552 total)
Why? What are you trying to achieve here?
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
March 1, 2010 at 8:12 am
Gary T (3/1/2010)
"SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x22412a3d; actual: 0x2241223d). It occurred during a read of page (1:246058) in database ID 20 at offset...
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
March 1, 2010 at 8:12 am
I don't have a problem with using identities. What I do have a problem with is using identities as the only unique identifier of the entire table.
When the primary...
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
March 1, 2010 at 12:42 am
If you query sys.databases, what's the state_desc of the DB that you cannot 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
March 1, 2010 at 12:05 am
Ajith Kumar A.J (2/28/2010)
Is the following statement is valid,ALTER TABLE table1 ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE;
No. Where did that syntax come from? Looks like maybe Oracle.
if not how...
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
March 1, 2010 at 12:02 am
Paul White (2/28/2010)
GilaMonster (2/28/2010)
One gentleman had a 100 billion row table.Did you mention that size isn't everything? 😉
Well, I was asking for the largest single table so I could make...
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
February 28, 2010 at 11:56 pm
There's no info on the MS website for two reasons:
The exam format changes from time to time
The exact format isn't mean to be public information
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
February 28, 2010 at 2:11 pm
In my PASS session on statistics, I asked the audience for the largest table anyone had worked with....
One gentleman had a 100 billion row table. He wouldn't tell me what...
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
February 28, 2010 at 10:54 am
That's a little extreme, don't you think?
There are documented ways (and scripts) to rebuild msdb. eg here - http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/06/619304.aspx
Sure, a reinstall will fix it, but you'll have wasted all...
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
February 28, 2010 at 10:10 am
Two things that you may want to read:
Managing Transaction Logs[/url]
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
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
February 28, 2010 at 9:39 am
JohnnyDBA (2/28/2010)
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
February 28, 2010 at 9:34 am
The biggest problem you are likely to have is drivers. A 64-bit SQL Server cannot use 32 bit ODBC/OLEDB drivers, hence you need to ensure that there are 64-bit drivers...
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
February 28, 2010 at 1:19 am
The general rule is that you can always upgrade (so 611 onto a server with databases in 612 or 655) but you can never downgrade.
There's a partial list here: http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/28/database-version-vs-database-compatibility-level.aspx...
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
February 28, 2010 at 1:09 am
I'm waiting for a second opinion from an expert on corruption. Please be patient.
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
February 28, 2010 at 1:06 am
CirquedeSQLeil (2/27/2010)
Paul White (2/27/2010)
GilaMonster (2/27/2010)
Someone is a little over-sensitive to corrections and disagreements. Not just that thread, several previous ones too.
I had noticed that too, but thought 'Welsh Corgi' had...
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
February 27, 2010 at 10:01 am
Viewing 15 posts - 33,766 through 33,780 (of 49,552 total)