Since you are parsing the column, adding a clustered index will not help since the optimizer will probably do a full table scan during that operation.

You can add an identity...

It seems to me that there is a parsing question here.

When using the IN for string comparision, it will be using the database collation.

Default Collation of the SQL Server installation...

Hi Jeff,

I know you are a big fan of Tally tables and I have not used them since you gave a talk a long time ago at SNESSUG.

Therefore, I took...

Nice article Jeff. The function that you wrote determines if it is a integer. If there is decimal data, the regular expression has to be changed. Unfortunately,...

Are you sure there is not bad data in that column?

I was able to blow up your convert WHERE clause with a space and non numeric data.

-- Database selection does...

This snipet will show you what a timestamp looks like when allowing the system to generate on the insert.

USE tempdb;

go

CREATE TABLE stamp_test(

TestDate DATETIME NOT NULL,

TestStamp TIMESTAMP

);

GO

SET...

Hi All,

A quick update to this question I posted a month ago. The evaluation version of Backup Exec that comes with most LTO3 + drives does not restore an...

Nice example Crazy Eights,

I guess my question is why use the cross apply?

Is there any advantage to using that statement?

I turned on statistics for both your query and...

🙂

Hi Jeff & Lowell,

All and all, it is cool stuff and I have squirelled the E16 example away.

I will have to remember to use it in the real world.

-John

Hi Jeff,

I think you presented Tally Tables at the SQL Server Users Group in Southern New England last summer.

I guess I am old school and need to think more in...

Hi Crazy Eights,

I have used the identity insert before on bulk loads when I wanted to keep the identity column the same and not change the value to a plain...

I hope this explains your question in depth.

First, SQL Server only supports UTF16 with the NCHAR, NVCHAR and NTEXT datatypes. That means, a character is represented by 2 bytes...

You are converting the dates which are near midnight and after to whole dates and then grouping.

The results are whats to be expected, two dates in yyyymmdd format.

I guess my...

Hi SQL Novice,

I picked this script up somewhere on the INTERNET. Execute it inside the database that you are interested in shrinking. It will tell you the files...

One solution is to put the whole DDL statement to create the table in the code instead of the SELECT into. For the field with a identity, change it...