Jeff Moden (8/25/2015)

---

No need to Google. Here's a chart...

Hi Josh

IIRC a hard tally table is usually slightly faster than an inline one. Google will tell you for sure.

WHERE 1 = 1 is only a placeholder, no tricky stuff,...

Jeff Moden (8/24/2015)

---

Josh Leane-155117 (8/24/2015)

---

Hi Chris, I tried your suggestions,

1) clustered index on tally table didn't make any difference, still 120 secs on test data

2) using LEN(@vstrText) < N...

Thanks for the additional suggestions Chris. I tried with the Tally table in the function, that slowed it slightly from 5 secs to 7 secs. Presumably due to...

Hi Chris, I tried your suggestions,

1) clustered index on tally table didn't make any difference, still 120 secs on test data

2) using LEN(@vstrText) < N made huge difference, down...

Hi,

It was permissions for the service account. The data files are installed to E:\MSSQL.1\MSSQL\Data and the SQLServer2005MSSQLUser$ group had full control over the Data folder, so could create DBS,...

Hi,

no, there aren't any read-only filegroups and the result from select * from sys.databases just lists the dbs that should be present

The dbcc not being able to create a shapshot...

Hi Paul

Definitely all drives are NTFS, and plenty of Gb free space on all drives.

I'm running SP2 build 9.00.3077.00

Thanks, Josh

Hi Paul

The output from running DBCC CHECKDB (adventureworks) WITH ALL_ERRORMSGS is

Msg 5030, Level 16, State 12, Line 1

The database could not be exclusively locked to perform the operation.

Msg 7926, Level...

Hi, thanks for the replies, appreciate it

I was doing this origanially on a dev server. I ran

DBCC CHECKDB (adventureworks) WITH NO_INFOMSGS, ALL_ERRORMSGS

and get

Command(s) completed successfully.

Then start a...