Viewing 15 posts - 10,561 through 10,575 (of 49,566 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...
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.
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.
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/
December 23, 2013 at 4:52 am
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....
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.
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...
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]
December 21, 2013 at 2:03 pm
They're fully logged operations.
http://www.sqlservercentral.com/articles/Recovery+Model/89664/
December 21, 2013 at 2:00 pm
No
December 21, 2013 at 1:58 pm
Do you have or have you ever played with service broker on Setup 2?
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...
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...
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"
December 20, 2013 at 12:54 pm
Viewing 15 posts - 10,561 through 10,575 (of 49,566 total)