You'd have to store the individual results in some sort of temporary storage (table variable, temp table). Better yet, don't use a cursor. If you are cursoring through...

Good article. It was helpful to know about the allocation units. I am in the process of designing a data mart type application DB where we'll be storing...

If you are wanting to get some measurements on baseline IO throughput on your SAN, you may want to look into using some third party tools to help with that...

I don't see anything alarming here. All of the values are within acceptable ranges. The CPU usage seems a bit high for just one process, but it is...

The timeout itself is usually issued by the calling application. If it is using ADO, there are 2 timeout parameters that can be configured to lengthen the amount of...

Well, it is normal for resource usage to increase as new jobs/requests are being processed by the server. This could be bad of course depending on the size and...

Good, just checking. You never know, without asking, if someone is wanting to attempt to modify the system tables directly or not.

The data relevant to exploring SQL Server partitioning functions/schemes are spread throughout a number of views. You'll want to look at sys.partition_range_values, sys.partition_functions, sys.partitions, among possibly others. Use...

Keep in mind that you do not have to change your recovery mode to bulk-logged to use bcp. It is still faster than using INSERT INTO even when in...

I'd be curious to see how that runs on a large table > 1M rows. I don't have the time to test it myself, but I'd be curious. ...

Here's a way to do it without the CTE.

DECLARE @Calls TABLE (AccountNumber int, TelephoneNumber varchar(10), DateCalled datetime)

INSERT INTO @Calls

SELECT 1, 4026146434, '2008-11-17 17:01:27.023' UNION ALL

SELECT 2, 4026115201, '2008-11-19 17:01:27.023'...

You don't want to copy the MDF file if you are only looking to move one table over. Use bcp.

In that case, use LEN:

DECLARE @Table TABLE (Col1 int, Col2 varchar(50))

INSERT INTO @Table

SELECT 1, '123234345' UNION ALL

SELECT 2, '123456789124578'

SELECT *

FROM @Table

WHERE LEN(Col2) < 12

When you say text, do you really mean a text datatype or is it a varchar/char data type?

I'm asking for you to take the effort in creating...