Viewing 15 posts - 16 through 30 (of 55,829 total)
There's different school of thoughts over whether the identity column should be a candidate of clustered index or not (mostly in favour of having it as clustered index).
What's your...
June 22, 2022 at 2:58 am
Hi all,
I have been using FORMAT()
FORMAT(Tab.date, 'yyyy-MM-dd') AS 'date_begin',
but been told it would be slow when it comes to big queries.
How can I still want the...
June 21, 2022 at 9:24 pm
@Johan ... Do you have the code where you created and populated the #TallyDate table so that newbies can run your test?
Also, your good code doesn't need the DATEADD/DATEDIFF thing. ...
June 21, 2022 at 9:12 pm
In addition to what Jeff Moden has outlined - take a look at the BUFFERCOUNT and MAXTRANSFERSIZE parameters for both backup and restore. Adjusting those values can improve performance...
June 21, 2022 at 9:08 pm
I would strongly recommend sticking with "integer" as the type. Add a domain (or range_of_values) property to limit the size rather than a data type name. Remember, the logical...
June 21, 2022 at 8:57 pm
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.
June 20, 2022 at 11:47 pm
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...
June 20, 2022 at 6:53 pm
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...
June 20, 2022 at 6:19 pm
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...
June 20, 2022 at 3:42 pm
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...
June 20, 2022 at 3:13 pm
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...
June 20, 2022 at 3:01 pm
Here's Microsoft's take on it, as well.
June 20, 2022 at 2:45 pm
But I don't know the rest, Jeff - what do you mean?
Understood.
There are other things to consider but let's start off with some of the basics...
Ask yourself what it...
June 20, 2022 at 2:40 pm
Thank you for your reply.
I took a look at your spreadsheet and immediately found a pretty nasty issue... about 2/3rds of the rows have duplicated Ticket Numbers.
Scott suggested...
June 20, 2022 at 2:18 pm
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...
June 20, 2022 at 2:12 pm
Viewing 15 posts - 16 through 30 (of 55,829 total)