Viewing 15 posts - 30,586 through 30,600 (of 49,552 total)
The mappings are not stored in SQL. They're stored in the package file itself.
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
September 17, 2010 at 11:02 am
hallhome (9/17/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
September 17, 2010 at 11:00 am
Jeff Moden (9/17/2010)
GilaMonster (9/17/2010)
Steve Jones - Editor (9/17/2010)
Too slow! Removing a lot of SPAM this morning, and disabling some accounts.
Yeah, there was quite a collection this morning. I think I...
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
September 17, 2010 at 10:59 am
ricardo_chicas (9/17/2010)
that means that adding more log file do not help in any way?
No. Only use for multiple tran logs is when there's insufficient space on a single drive 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
September 17, 2010 at 10:58 am
Ninja's_RGR'us (9/17/2010)
Hmm, makes you wonder if we need to make another article about dealing with severe problemes at work under pressure. And by we I mean you :hehe:.
Thank you...
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
September 17, 2010 at 10:56 am
ricardo_chicas (9/17/2010)
I have several blocking process on tempdb,
Blocking on what? What's the wait_resource? What's wait type?
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
September 17, 2010 at 10:38 am
Steve Jones - Editor (9/17/2010)
CirquedeSQLeil (9/17/2010)
But what does the null represent?Mean editor?
Bad editor. No cookie.
😀 :hehe:
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
September 17, 2010 at 8:48 am
CirquedeSQLeil (9/17/2010)
Alvin Ramard (9/17/2010)
GilaMonster (9/17/2010)
CirquedeSQLeil (9/17/2010)
Arghh. To'o late Ste've m'ust hav'e rem'oved' it.
You didn't miss much. Some nasty names for Steve, a claim that a certain piece of...
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
September 17, 2010 at 8:43 am
Steve Jones - Editor (9/17/2010)
Too slow! Removing a lot of SPAM this morning, and disabling some accounts.
Yeah, there was quite a collection this morning. I think I made like 10...
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
September 17, 2010 at 8:37 am
CirquedeSQLeil (9/17/2010)
Arghh. To'o late Ste've m'ust hav'e rem'oved' it.
You didn't miss much. Some nasty names for Steve, a claim that a certain piece of (non-working) was now 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
September 17, 2010 at 8:35 am
Blood moon
The moon was red last night, I'm guessing due to the dust in the air. The spring winds are picking up, but the rains haven't started. It's bone dry...
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
September 17, 2010 at 8:34 am
Krasavita (9/17/2010)
Thank you very much. Do you know any articles that I can read more about that subject.
Not offhand, but a quick google search should turn up a few.
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
September 17, 2010 at 8:33 am
Apologies, I was thinking of someone else.
It's generally not recommended to rebuild indexes below 1000 pages as there's little performance gain. Especially for very small indexes (<25 pages) you'll likely...
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
September 17, 2010 at 8:13 am
http://www.google.com/search?q=%22page+split%22+%22SQL+Server%22
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
September 17, 2010 at 7:41 am
I'm quite sure that you've been part of discussions before around the minimum page count where it's considered useful to rebuild indexes....
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
September 17, 2010 at 7:38 am
Viewing 15 posts - 30,586 through 30,600 (of 49,552 total)