Viewing 15 posts - 22,381 through 22,395 (of 39,961 total)
Roy is correct. The FAQ says any recovery model works.
September 22, 2009 at 7:59 am
There may not be anything to clean up. You might just be out of space. Data files grow over time as data is added, and most of these are not...
September 22, 2009 at 7:28 am
Can't search back. Which site, Lynn?
September 21, 2009 at 12:09 pm
No, you need to grow the tables if they aren't registering in the counters.
September 21, 2009 at 12:08 pm
I'd recommend the book route as well.
If you want to go back and read through the archives, you can also use 4 Guys From Rolla[/url] as a good site...
September 21, 2009 at 10:45 am
You can still do it in a large company, just need to use groups and spend a little more time on it. Or lock things down and take requests for...
September 21, 2009 at 10:44 am
Haven't finished the Cowboys game yet, but Romo definitely looked off. :(, and that's my team. Good to see the Broncos win, but I suspect they might go quite a...
September 21, 2009 at 10:43 am
September 21, 2009 at 9:50 am
Also be aware that a SQL file needs free space in it. It is not like a Word or Excel file in that it is the size of the data.
September 21, 2009 at 9:49 am
You can also right click the databases in SSMS and view the space. That can be easier to understand.
September 21, 2009 at 9:48 am
I'm not sure it's elegant since you'll end up confusing people that look at the design.
Multiple tables, like Product, ProductDetail, ProductStatus, would form a sub-model I've used that approach as...
September 21, 2009 at 9:47 am
Sorry, you'll have to live with real technical content in addition to all the complaints, vents, rants, and recommendations.
Besides, if I have to see Lynn's soccer talk here, you'll have...
September 21, 2009 at 9:46 am
Use the SET commands. STATISTICS IO ON, compare reads/writes.
you could use Trace/Profiler as well.
Less reads, CPU might be the way to go.
September 21, 2009 at 9:24 am
I'm pretty open here, and I question a company hard. The first thing I want to do is meet the team(s) I will work with. That can be the developers,...
September 21, 2009 at 9:23 am
An MDB is an Access file. If it's an mdf/ndf/ldf, those are SQL Server files.
September 21, 2009 at 9:14 am
Viewing 15 posts - 22,381 through 22,395 (of 39,961 total)