Brandie Tarvin (9/21/2011)

---

Be careful with this assumption. Initial file sizes can be changed (increased) through a number of methods. I've even caught SQL Server 2005 doing an auto-adjust once or...

MadTester (9/22/2011)

---

Reevaluate indexes. You may be carrying unnecessary baggage.

Run a script to start with, find duplicate indexes. Drop them.

Then look at the usage of remaining indexes.

If you have only updateson...

Philip Yale-193937 (9/19/2011)

---

Two things strike me reading this:

1. I presume you're not actually out of disk space yet, so what will you gain from actually shrinking the data file? ...

As far as I can tell the log files are not growing dramatically they are just large. Some of the database tables have got 6 million rows in them, which...

I'm on 2008. I've got 2008 RS on my lap-top, but the db server is 2008.

Well eventually I'll be deleting a lot of data probably at least 50% of the rows in some tables if not more. The nature of our business is a lot...

I think we do take regular back-ups. Like you I hope we do. (Actually, what I think we do is take snapshots of the virtual machines the databases are on.)

I...

Hello Pradeep,

Thanks for your reply, it's the similar to what I'm thinking I need to do.

The database is in SIMPLE recovery mode (or should be). If I understand your...

The straight-forward answer is no, see Jack Corbett's reply on the duplicate post.

The other thing and this is restating what Imu92 says is that even if you could you...

Have a look at these links:

http://www.sqlservercentral.com/articles/Performance+Tuning/2924/

http://stackoverflow.com/questions/543580/equals-vs-like

It is not an easy question to answer because it all depends on what you are doing. Use the Execution plan...

I just wanted to add my thanks for a well-written article. I didn't quite agree with it all, since rigidity can be just as detrimental to an organisation as complete...

I had a similar problem today. Although this might be obvious to most people you can add COLLATE to other clauses not just the WHERE clause.

With my problem the...

I can't really help you with MS Access. Sorry about that.

sp_help and sp_columns are system stored procedures and I don't know if their equivalents exist in Access. Perhaps they...

If you run this:

EXEC sp_help MyTroublesomeTable you'll find five returned recordsets. The second of which details information about the columns within the table. The column Nullable should give you...