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...
--Jeff Moden
June 24, 2022 at 1:21 am
Since Tally Table of dates was mentioned, here is how to construct it:
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
June 22, 2022 at 8:19 pm
Yes, parameters.
PARSENAME will still help in this case.
--Jeff Moden
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())
--Jeff Moden
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?
--Jeff Moden
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...
--Jeff Moden
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,...
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
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...
--Jeff Moden
June 22, 2022 at 3:31 am
Viewing 15 posts - 1 through 15 (of 55,829 total)