I'm doing some more checking but, just to be on the safe side, I added a warning to the flower box on the function I posted.

I have 10 text files and file 4 at nth row has special character that cant be loaded to sql server table

required is to log the issue

AND

ignore processing the...

All that's nice but no one has identified how to identify duplicate entries  for the various ticket responses possible for a given ticket number or prevent them.  Or is "no...

And, just to make you feel better about abandoning FORMAT, I've not yet seen it where it's not at least 20 times slower than code like what Frederico suggested even...

Hi,

I'm looking for a third-party backup and restoration solution because native restore takes roughly 7 hours for a 4TB database.

Some of the object restore solutions really do a full...

• This reply was modified 3 years, 9 months ago by Jeff Moden. Reason: Bolded the important part here

I'll also add that a lot of very well intentioned folks rail against the use of stored procedures because they "not portable".  What they mean by that is that a...

Here's Microsoft's take on it, as well.

https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver16

Understood.

There are other things to consider but let's start off with some of the basics...

Ask yourself what it...

Thank you for your reply.

Scott suggested...

This link gives a few reasons for choosing shorter varchar lengths.

In terms of storage, CHAR(n) columns are always n characters long.

VARCHAR(n) columns are anything between 2 and...

Remember, too, that the logical data model should be easily understood and use by business people.  In fact, if possible, keep all developers out of the first one or...

1. There is no way that I'd ever create column names with spaces in them.  It relegates you to always have to use brackets around every column name...

I took a look at your spreadsheet and immediately found a pretty nasty issue... about 2/3rds of the rows have duplicated Ticket Numbers.

As for being new to the game, you...

No joy on the "new" formula.  It has about the same performance for the DATETIME datatype and is 50% slower for the DATE datatype.  It's also not "symmetrical" with how...

I'm also exploring a different method using the following formula for finding the week start, midweek, and end dates (the 1 needs to be changed to a 4 and 7...