Viewing 15 posts - 30,196 through 30,210 (of 49,552 total)
Craig Farrell (10/5/2010)
GilaMonster (10/5/2010)
Alvin Ramard (10/5/2010)
GilaMonster (10/5/2010)
Local version:
Q: How do you eat an elephant?
A: One bite at a time.
That's the opposite of:
Q: How do you put an elephant in 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
October 5, 2010 at 3:54 pm
Alvin Ramard (10/5/2010)
GilaMonster (10/5/2010)
Local version:
Q: How do you eat an elephant?
A: One bite at a time.
That's the opposite of:
Q: How do you put an elephant in a refrigerator?
A: Open 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
October 5, 2010 at 3:40 pm
Craig Farrell (10/5/2010)
Which begs the question, why the heck are there extents in the first place for anything but LOB data...
An extent is nothing more than a contiguous 8 pages...
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
October 5, 2010 at 3:08 pm
Derrick Smith (10/5/2010)
(I'm just shy of MCDBA..which I should get, but I don't want to pay for it myself :))
Not any more... All the MCDBA exams (excluding maybe 1) are...
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
October 5, 2010 at 2:52 pm
sqlbuddy123 (10/5/2010)
My two cents..You can check these books to become a master
I'll disagree slightly...
Books alone will not make you a master. Books + experience + experimentation may, with sufficient dedication...
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
October 5, 2010 at 2:38 pm
Craig Farrell (10/5/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
October 5, 2010 at 2:34 pm
LutzM (10/5/2010)
Or, like my boss used to say: "If you need to swallow an elephant: slice it!" (It might have a different interpretation down there in SA thought 😉 )
Local...
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
October 5, 2010 at 2:30 pm
Derrick Smith (10/5/2010)
Actually IIRC, all of the databases involved in replication can be set to simple.
Yup. Replication does not depend on a specific recovery model.
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
October 5, 2010 at 1:10 pm
WayneS (10/5/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
October 5, 2010 at 12:30 pm
Brandie Tarvin (10/5/2010)
WayneS (10/4/2010)
CirquedeSQLeil (10/4/2010)
I just realized who our drop database OP was. DohHmm. This made me go look at previous posts. Quite interesting...
What did I miss?
This:
GilaMonster (10/4/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
October 5, 2010 at 11:31 am
CirquedeSQLeil (10/5/2010)
Wow - I think I would pull that PM and my boss aside. That is bogus.
The PM's boss fully supports him. I'm an external consultant (ie slave), so...
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
October 5, 2010 at 11:24 am
Continues: http://www.sqlservercentral.com/Forums/Topic998574-65-1.aspx
No further replies to this thread 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
October 5, 2010 at 11:19 am
And just when I thought the project I'm on couldn't get any worse..
We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting with...
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
October 5, 2010 at 11:06 am
The trace events haven't changed names. To semi-replicate the default trace on SQL 20p00, create a server-side trace with the same events (hint, get profiler to create the script) then...
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
October 5, 2010 at 7:22 am
tt-615680 (10/5/2010)
Grant Fritchey (10/5/2010)
Which, do the same as the default trace or capture RPC:Complete & SQL:BatchComplete events?
Yes, I know there are many queries or sysyem sp's that cannot be used...
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
October 5, 2010 at 7:07 am
Viewing 15 posts - 30,196 through 30,210 (of 49,552 total)