Viewing 15 posts - 1 through 15 (of 55,829 total)
If I have a query with multiple UNION ALLs, will the optimizer try and grab enough memory to run all the individual queues in one, or will it make...
June 24, 2022 at 1:21 am
Since Tally Table of dates was mentioned, here is how to construct it:
June 24, 2022 at 1:17 am
To compare data by using the New Data Comparison Wizard On the SQL menu, point to Data Compare, and then click New Data Comparison Identify the source and target...
June 24, 2022 at 1:07 am
Using joins to compare columns by priority among the table. For example, left join returns all values from the first table and null value for the not-matched records from...
June 24, 2022 at 12:19 am
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,...
June 22, 2022 at 5:11 pm
Are your applications already in production & you're just migrating? If so, then you can know what hardware it's on and what resources it's using.
Test. One of the nice...
June 22, 2022 at 4:38 am
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
Viewing 15 posts - 1 through 15 (of 55,829 total)