Viewing 15 posts - 39,196 through 39,210 (of 49,552 total)
viveks.dba (5/11/2009)
However, it is the best practice to do it offline to avoid locks on the tables incurred during index rebuild.
You sure about that?
An offline index rebuild takes locks on...
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 11, 2009 at 3:17 am
madhu (5/11/2009)
How n where can we get this SQLRAP tool.
It's not a tool. It's a service offered by Microsoft's Premier Support people. I don't know if you can get an...
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 11, 2009 at 3:14 am
What do you mean by 'availability'? Precisely what are you looking 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 11, 2009 at 1:34 am
Ask to be involved in the data capture for it. You probably would be anyway.
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 11, 2009 at 1:32 am
It won't cause problems, but it's unnecessary. If the indexes are identical in columns then they are redundant and you're paying the cost for updating both while getting the benefits...
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 11, 2009 at 1:31 am
Manie Verster (5/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
May 11, 2009 at 1:29 am
RBarryYoung (5/10/2009)
why the heck did they fix it in for 2005 after it was broken in 2000?
Because people use it. It wasn't intended to be used for concatenating 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 10, 2009 at 3:03 pm
Not something I've ever heard of, not something I can find any reference to on google.
Ask him if, next time it happens, he can check a few things:
log_reuse_wait_descr in sys.databases
DBCC...
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 10, 2009 at 2:51 pm
winston Smith (5/10/2009)
Apologies if its a question you find too personal to answer on a public forum, but what is your occupation?
Database consultant specialising in performance tuning, SQL development...
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 10, 2009 at 2:49 pm
The portion of the article that I was mostly referring to was the last paragraph.
If you’re a developer or Windows admin, try to get promoted internally rather than switching companies....
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 10, 2009 at 8:56 am
http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/
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 10, 2009 at 8:38 am
Please post udf and the exec plans (from both the VM and the prod box), as well as table defs and index defs.
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 10, 2009 at 8:34 am
Paul White (5/10/2009)
GilaMonster (5/10/2009)
You are correct in that conclusion.Can you provide anything authoritative to support that?
I am intrigued.
Itzik Ben-Gan mentioned it during his precon at PASS last year. He also...
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 10, 2009 at 6:45 am
Swayambhu narayan Samamtroy (5/10/2009)
Run DBCC Checkdb and post what is the message you are getting
He already has. See the third post in this thread.
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 10, 2009 at 6:34 am
The mdf file contains the data, the metadata, any indexes. The ldf file is the transaction log, a list of changes to data pages.
Have a read through this: http://msdn.microsoft.com/en-us/library/ms179316.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
May 10, 2009 at 3:44 am
Viewing 15 posts - 39,196 through 39,210 (of 49,552 total)