Viewing 15 posts - 10,561 through 10,575 (of 49,552 total)
From books online:
To build a recommendation of the optimal set of indexes, indexed views, or partitions for your databases, Database Engine Tuning Advisor requires a workload. A workload consists 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
December 23, 2013 at 5:01 am
It's never perfect. We've told you the best way, but you still have to test and check all recommendations.
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
December 23, 2013 at 4:53 am
Jeff Moden (12/22/2013)
Ah. Understood. He made it sound like he had the physical file and that it was just named incorrectly.
Hard to tell what's going 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
December 23, 2013 at 4:52 am
Jonathan beat me to it (I started rewriting the procedure into dynamic SQL and got busy with other things). Here's another blog post on the subject http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
December 23, 2013 at 4:52 am
Did you try Books Online?
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
December 22, 2013 at 2:04 pm
Jeff Moden (12/22/2013)
navimir (12/22/2013)
Can I delete the secondary data file in emergency mode?there will be any data loss??
the secondary data file was wrongly created with extension .mdf instead of .ndf
No....
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
December 22, 2013 at 1:56 pm
Developer edition runs fine on Windows 7. Whether the Win 7 OS can do failover clustering is another matter, but that's the OS, not SQL.
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
December 22, 2013 at 9:51 am
You're going to have to restore from backup if you want that database back, unless you can somehow recover or find that missing data file. With a missing file in...
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
December 22, 2013 at 6:17 am
Use sys.partitions
As for a non-aligned index, this
CREATE INDEX FactInternetSales_Part_CustomerKeyNonaligned ON dbo.FactInternetSales_Part(CustomerKey) ON [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
December 21, 2013 at 2:03 pm
They're fully logged operations.
http://www.sqlservercentral.com/articles/Recovery+Model/89664/
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
December 21, 2013 at 2:00 pm
No
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
December 21, 2013 at 1:58 pm
Do you have or have you ever played with service broker on Setup 2?
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
December 21, 2013 at 3:20 am
Is there any way you can post that procedure? Obfuscate the table and column names, those aren't important, it's the form of the procedure (including any hints) that I'm interested...
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
December 21, 2013 at 3:19 am
Sean Lange (12/20/2013)
This sounds like a Jeopardy question.I will take "Obscure out of context IT questions" for 800 Alex.
It's the Daily Double!!!
Can I have "Questions you need to hire 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
December 20, 2013 at 1:26 pm
Does this get the weird question of the week award? http://www.sqlservercentral.com/Forums/Topic1525137-391-1.aspx
I believe the answer is "A SAN"
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
December 20, 2013 at 12:54 pm
Viewing 15 posts - 10,561 through 10,575 (of 49,552 total)