Sorry for being unclear.

I performed the restores using SSMS-GUI the 2nd restorei checked the 'Overwrite the existing database(with replace)'.

• This reply was modified 5 years ago by  Daryl AZ.

Ex.

Typing 'Select * from MyTable..' in SSMS SqlPrompt then brings up a list of tables fitting that spelling.

Using arrow key down to go to specific table.

At...

I am a huge fan of Sql Prompt. Prior it seemed i would manage to memorize most of the database for quick querying.

Do you know of a method to...

I understand now that this is newID() functionality.

I am familiar with using CTEs for recursion for ',' delimiting and see the difference. It just sorta, kinda, maybe...

Original Expected results were lines 1 - 3 (key: PO1, 11, 2015/07/25) have one GUID and Line 4 (key po1, 11, 2015/07/26) have a different GUID.

Using the cteReceiveGuid for...

I have never had a Truncate issue so I would start at the select into.

a) How much space is available for the database? Was the delay caused by...

I went to 2012 SSMS without any 2012 databases.

The Visual Studio-isk ability to pull files onto different monitors feature was worth the update by itself.

That was my thought direction also.

One idea

During the insert since the non-clustered index (includes) is also being created/populated, swapping out the PKEY index would be removing overhead and would be...

I understand the value of a clustered index.

I was questioning whether switching from a clustered index on an Identity to a clustered index on non-sequential keys would affect performance of...

Thanks for the location of the Sql2008 SqlServer2005_bc.msi file. Worked like a charm!

My test database on prod database (3rd party app) are not running on the same OS. ...

I think somebody has a faulty memory. When I run against Sql2000 and sql2008 I get the same results from your sample.

projectidapCountarCount

A22

B33

C20

projectidapCountarCount

A12

B13

C20

Note: I did run both from Sql2008 SSMS...

Create a function that takes a comma delimited sting and returns a two column table. (ID, LookupValue)

Select yada

FROM MyTable

Left Join fnc_tableFromString(@argMyString) theName ON myTable.name = theName.name

where myTable.id is null

create proc YourProc

@arg1 varchar(25) = null

as

set nocount on

select * from mytable

where (@arg1 is null or mytable.mycolumn = @arg1)

Nice snippet Lowell.

That looks like a nice piece of code to place in the tool chest!

Cast your text type as a varchar(max)