Well done. One word of warning. sys.xp_fixeddrives cannot read mounted volumes and accurately report the size. If you are running SQL 2008 R2 SP1 or above, take a look at...

This version cannot keep up with XML splitting or CLRs, but won't fail on reserved characters like ampersands. For a tool that is used in ETL and non-OLTP transactions, it...

Just a first crack at it, using a Split String function I have posted on this site as a tool http://www.sqlservercentral.com/scripts/SUBSTRING/124330/:

SELECT partnum

, partdescription

...

looking at your sample: DBCC CHECKTABLE ('dbo.tblSIFOB' REPAIR_ALLOW_DATA_LOSS)

the comma between the table and the repair option was missed.

Did you check your backup situation BEFORE running this?

DBCC CHECKTABLE('dbo.tblSIFOB',REPAIR_ALLOW_DATA_LOSS)

I've been using this script for some time and it has worked well for me. I hope it solves your needs.

DBCC SQLPERF(logspace);

GO

SELECT DISTINCT

...

From your error message, it looks like you table has failed a consistency check. First and foremost, you should check your backup situation. If a viable backup contains the information...

Internally, SQL Server matches the snapshot agents to SQL Jobs. You can access this information from the distribution database:

select *

from...

Yes. That is better preforming as long as no XML reserved words are used.

https://technet.microsoft.com/en-us/library/ms145315%28v=sql.90%29.aspx

That is a great article. I hadn't read that before, but it definitely brings the performance of different approaches to light.

The recursion comes in with the multiple executions of the SUBSTRING function. By using the Numbers table, or the tally table generated on the fly depending on your implementation, we...

The MAXDOP setting allows queries with higher calculated costs to run on multiple threads across many processors. This can be very advantageous and allow your more complex queries to complete...

Sure.

I created a table, TestData, that contains 1M rows.

IF OBJECT_ID( N'dbo.TestData',N'U' ) IS NOT NULL

DROP TABLE dbo.TestData

GO

CREATE TABLE dbo.TestData (

...

Try using PATINDEX instead of LIKE. I have had good luck using this method where indexes are available on the search column.

DECLARE @status NVARCHAR(50)

,...

Try this: http://www.sqlservercentral.com/scripts/calendar/120574/

Thanks, Joe. That is a great add to this process. It would be nice to calculate the holidays rather than persist them and have a yearly task to add the...