Rebuilding the indexes will remove fragmentation. Look at DBCC SHOWCONTIG

Michael brings up good points. 1TB in a notebook isn't the same as 1TB in a SAN, but that exasterbates the problem even more. People assume it is and keep...

They've been mailed out. Lots of responses that I expect to see on click throughs.

Not sure what I've done that triggered a filter. Possibly there was a filter update from...

Sorry about that. I scan lots of other sites and try to pick up all the SQL Server content that there is. It's kind of a hit and miss, just...

Sorry, an announcement coming. I've set up separate feeds here:

WMV: http://www.sqlservercentral.com/Xml/Rss/Articles/Editorial%20-%20WMV/

iPod (MP4)

http://www.sqlservercentral.com/Xml/Rss/Articles/Editorial%20-%20iPod/

MP3

http://www.sqlservercentral.com/Xml/Rss/Articles/Editorial%20-%20MP3/

I think you'd need to to two passes of the file, or perhaps some strange scripting.

Honestly Whitt, I think simpler is better. I'd pull the whole file into SQL Server...

I certainly don't mind interviewing, but I'd like to think someone would hire me 🙂

Course, hoping I don't ever have to find out 😉

And just thought of this: add a separate BAT/CMD file for each new drive letter. It will help you keep organized, you can count the number of files to be...

What's "best", is a hard question. And it varies by manager and company.

To me, the best is someone that fits with the team, gets along, works hard independently but within...

Keep in mind that the log can be bigger than the data size. It depends on transaction volume. I could have a 1MB database with 1 table, 1 row, 1...

SQL 2K5 includes the SQL Native Client, which isn't included with the SQL 2000 tools, nor with W2K or XP. I think Vista has it, but that problem is likely...

It sounds like the user just doesn't have INSERT permissions on the table in the other database. SELECT permissions are different from INSERT permissions.

You don't need datawriter. Create a...

select * From sysschedules

Goes for all jobs. Maintenance plans are jobs.

Also keep in mind that blocking is normal and expected. It should just be of a short duration. If you're having longer durations, I'd trace (Profiler) the user you think...

Johan has some good ideas. I think you need to go with the custom role that you have, work out the permissions.

And write us an article! I'm sure other people...