Grant is right about the indexes and transaction logs. Be sure the database is in simple mode, and run the DBCC ShrinkDatabase(<databasename>, 10) to recover any disk space that...

I don't have a specific example to show you, but another approach is to use the SELECT command using the FOR XML switch. Then use XSLT transformations to convert...

My intent was code simplicity. There is no "One Right Way" to code, but some ways are better than others. I will be interested in seeing your results....

I always ask questions at the end of my interview. Usually, that turns into a discussion of their various current problems, and how I would approach them. That...

Yep, found it. It works. I just wasn't looking at the right menu options.

How to open a DTS package saved to a structured storage file (Enterprise Manager)

To open...

The numbers were wrong in all instances.

The -n (native format) is a great way to transfer data between SQL server tables, but that's not the case in this scenario. These are text files we receive...

Yep, seen that in CA State positions often.

I appreciate the thought put into this article. I've been consulting for 18 years, and been a mainstream SQL Server "Engineer" for the past 8 years. I think...

Just what I needed. Thanks! 😀

Kieth may be right that #2's will keep #3's working, but that don't mean I gotta like it :-D. My current project is a rescue project, and I have...

Maybe a 5.

When I started out in the IT field, DOS 2.11 was the dominant PC operating system. I learned to do everything in it, including tweaking the UMB...

The SQL Server 2008 Upgrade advisor is designed to work with SQL Server 2005 Reporting Services.

For more information look here:

http://msdn.microsoft.com/en-us/library/bb677622.aspx

Cheers!

Brandon_Forest@sbcglobal.net

Robert is right, the quote is not quite the same as in the book. The following email will explain the difference 😉

--**********************************************************************************

Hi Brandon

Of course you can publish this note....

Yep, I figured that out the hard way. I had a stored procedure called usp_ShrinkAllLogs, which used the BACKUP LOG <LogName> With Truncate_Only and DBCC SHRINKDATASE(<databasename>, 10). I...