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...
--Jeff Moden
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...
--Jeff Moden
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. ...
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
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.
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
June 20, 2022 at 3:01 pm
Here's Microsoft's take on it, as well.
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
June 20, 2022 at 2:12 pm
Viewing 15 posts - 16 through 30 (of 55,829 total)