Viewing 15 posts - 3,256 through 3,270 (of 59,067 total)
A question though.... what is the ultimate use of the text files? What is going to use them and how?
The reason I ask is a whole lot of people export...
June 22, 2022 at 8:21 pm
used in forensics to determine nightly load record processing... research... not going to load it into another backend...
Just a quick way to review...
Interesting. In that case, I WOULD be...
June 22, 2022 at 8:19 pm
Yes, parameters.
PARSENAME will still help in this case.
June 22, 2022 at 8:10 pm
Like I said...
In fact, this may actually contain a much better answer especially since the target consumer will actually be Power BI.
SELECT LangName = @@LANGUAGE
,DateFormat = CONVERT(DATE,GETDATE())
June 22, 2022 at 8:08 pm
I can't help on the PowerShell but, even if I could, I'd still ask the following question...
How will the resulting CSV files be used and by what?
June 22, 2022 at 5:36 pm
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...
June 22, 2022 at 5:28 pm
The FORMAT function return type is NVARCHAR , which is a string.
https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?view=sql-server-ver16
You can get the same result by replacing FORMAT with
CONVERT(varchar(10), [YourDateField], 120)
Again, though, if you...
June 22, 2022 at 5:11 pm
Hi hakiyu. Glad to "meet" you and welcome aboard.
Since you have asked such a open-ended question, I can only respond with an open-ended answer. It IS possible that you might...
June 22, 2022 at 4:34 am
Hello friends,
I have a requirement where I have to compare the two fields using regular expressions.
Example, I have a parameter with value 'ABCDEF.%30a.3%a' or 'BBBB.%10a.5%a' where %30a or %10a...
June 22, 2022 at 4:04 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 22, 2022 at 3:31 am
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
Viewing 15 posts - 3,256 through 3,270 (of 59,067 total)