@MichaelGreen either orders of magnitude better query performance (95%) ... or query plan compile time takes longer than the old queries used to execute (2%) ... or no change (3%)
this my sql query:
SELECT * FROM
(SELECT * FROM ClassifiedAd
WHERE city_id = :city
AND currency = :currency
AND price > 100)
UNION DISTINCT
(SELECT c.* FROM
ClassifiedAd c
WHERE c.city_id = :city
AND c.currency = :currency
AND (c.price >...
In a PostgreSQL (9.3) database, I have a one-to-many relationship between Accounts and Customers, so within the Customers table, I have a globally-unique id for the primary key of each Customer, plus the corresponding Account id. But I would also like to assign each one an Account-specific id - ...
@dezso a lot of people say "supposebly" too, that doesn't make it right
Sadly, performant is one of those pervasive "words" that will find its way into the dictionary eventually, because the tide can't be stopped. Ref: ginormous.
My memory is that SQL Server 2005 and earlier used to not return any row if no GROUP BY was specified (a google and stackoverflow search indicates that other people had the same experience), do you know when/why it changed? — Andrew Bickerton42 mins ago
What is the difference between supposedly and supposably? Both are real words but seem to have confusingly similar definitions.
Supposably: Capable of being supposed : conceivable
Supposedly: According to what is generally assumed or believed
@ypercube And I've never heard of it being used in the other context. Every time I've heard "supposably" it was a mispronunciation. A friend of mine from Oregon knows she does it but can't fix it.
Supposably has been a word used in the written record since 1739 according to the OED.
Supposedly since 1597. Both have almost the same meaning, 'to presume something is true,' however supposedly means 'to presume truth without evidence'.
Both are considered correct Standard English. Supposably...
> Supposably is quite rare in actual use; I believe it's more an inkhorn term than one actually found in the wild, so to speak. Thus, I fear that when you encounter it you are probably really encountering somebody who meant to say "supposedly".
Yes it is possible to get back the table and data in sql which is dropped accidentally.here somethink i had like this....
SQL> create table AKULA_KHASIM(name varchar2(20),job varchar2(20));
Table created.
SQL> insert into AKULA_KHASIM values('Tanishq','ApplicationDeveloper');
1 row created.
...
The following script is very slow when its run.
I have no idea how to improve the performance of the script.
Even with a view takes more than quite a lot minutes.
Any idea please share to me.
SELECT DISTINCT
( id )
FROM ( SELECT DISTINCT
ct.id AS id
FROM...
According to MS's knowledgebase, "Except for COUNT, aggregate functions ignore null values."
Does anyone know how I can get it to work correctly, that is, return a null if it attempts to aggregate with a null in the values?
Example:
SELECT SUM("col")
FROM (
SELECT NULL "col"
UNION
...
@billinkc My proposal was to add ONE revision in the history, the very first version posted, to prevent this very thing. Not to track all changes made in the first 5 minutes.
I don't know. Perhaps because you wrote "how I can get it to work correctly" while you meant *"how I can get it to work the way I want it" — ypercube45 secs ago
Your saying "how I can get it to work correctly" seems to imply that the documented behaviour is not correct. So, perhaps someone disagreed with that premise, considering such a question not useful. — Andriy M46 secs ago
This is my query:
insert into [Consolidated_LoB].[dbo].[consold]
([shp_to_pstl_cd]
,[LoB]
,[catlg_nbr]
,[shpd_qty])
select [POSTAL_CODE]
,[LoB]
,[PART]
,[SHIPPED_QUANTITY]
from [ITB_Pank].[dbo].[ITB_consoldtd]
and the message I receive is:
Arithmeti...
@RoyiNamir The udf may be computed once or twice, I'm not sure. Without the whole query and an execution plan, I don't think anyone can help more. Is there a performance problem?
No. just asked If I should worry about , or what elase can I do ( I f i wanted to run it once excatly) m but if you say that I have to see the execution plan , then I will.....**I thought that it's like getdate()** that even if it appears anywhere , multiple , it will be calculated once.
> The Gallup-Healthways Well-Being Index uses a holistic definition of well-being and self-reported data from individuals across the globe to create a unique view of societies’ progress on the elements that matter most to well-being: purpose, social, financial, community and physical. It is the most proven, mature and comprehensive measure of well-being in populations.
> Previous Gallup and Healthways research shows that high well-being closely relates to key health outcomes such as lower rates of healthcare utilization, workplace absenteeism and workplace performance, change in obesity status and new onset disease burden.
Somehow this got cut... I hear this all the time on NPR and it drives me nuts. Don't get me wrong I do like NPR but sometimes their yuppie dialect makes me want to punch someone in the face.
@Zane I skipped mine in 2013 because it was going to be super lame. They were having a picnic at a park. Then someone eventually added on an after party in a crappy club in the suburbs and charged $50 per person. It wasn't worth the flight home.
But I'm not big on stuff like that. I didn't do my undergrad or MBA graduation ceremonies because I felt like they were a waste of my time and money.
SELECT
DeadlockGraph,
LastStart = DeadlockGraph.value(N'(deadlock/process-list/process[1]/@lasttranstarted)[1]', N'datetime')
FROM
(
SELECT DeadlockGraph = XEvent.query(N'(event/data/value/deadlock)[1]')
FROM
(
SELECT XEvent = CAST(event_data AS XML)
FROM sys.fn_xe_file_target_read_file(N'system_health*.xel', NULL, NULL, NULL)
WHERE [object_name] = N'xml_deadlock_report'
) AS x
) AS y;
(Assuming you haven't disabled system_health or changed where it stores the data.)
I have a table with a whole bunch of data. In that table there is a row, with not unique ids, so there can be dublets of them - I have found them by doing this query:
SELECT theid FROM thetable
GROUP BY theid
HAVING COUNT(*) > 1
In the table there is also columns like street1,street2,city1,cit...
Msg 15562, Level 16, State 1
The module being executed is not trusted. Either the owner of the database of the module needs to be granted authenticate permission, or the module needs to be digitally signed.
The "owner of the database of the module"? "authenticate permission"? "digitally signed"?
Well the three things I quote: (1) doesn't even make sense - I presume the second "of" should be "or" (2) authenticate as what? (3) digitally signed sounds like something I do when I'm getting esurance and avoiding paperwork.
The specific problem I'm conquering is calling sys.fn_xe_file_target_read_file from a multi-statement TVF. Setting database owner to sa doesn't fix it, but trustworthy on does.
@AaronBertrand I know this isn't the first case of the kind, but... typing so many words to post a question instead of bingling for "output line in basic"?
Did I ever mention that you guys and gals are the best?
2
You are all responsible for about 50% of my success in my chosen career and a huge influence in why I dedicate a lot of time helping other people learn this shit.
this my sql query:
SELECT * FROM
(SELECT * FROM ClassifiedAd
WHERE city_id = :city
AND currency = :currency
AND price > 100)
UNION DISTINCT
(SELECT c.* FROM
ClassifiedAd c
WHERE c.city_id = :city
AND c.currency = :currency
AND (c.price >...
What is the difference between supposedly and supposably? Both are real words but seem to have confusingly similar definitions.
Supposably: Capable of being supposed : conceivable
Supposedly: According to what is generally assumed or believed
Supposably has been a word used in the written record since 1739 according to the OED.
Supposedly since 1597. Both have almost the same meaning, 'to presume something is true,' however supposedly means 'to presume truth without evidence'.
Both are considered correct Standard English. Supposably...
Yes it is possible to get back the table and data in sql which is dropped accidentally.here somethink i had like this....
SQL> create table AKULA_KHASIM(name varchar2(20),job varchar2(20));
Table created.
SQL> insert into AKULA_KHASIM values('Tanishq','ApplicationDeveloper');
1 row created.
...
The following script is very slow when its run.
I have no idea how to improve the performance of the script.
Even with a view takes more than quite a lot minutes.
Any idea please share to me.
SELECT DISTINCT
( id )
FROM ( SELECT DISTINCT
ct.id AS id
FROM...
According to MS's knowledgebase, "Except for COUNT, aggregate functions ignore null values."
Does anyone know how I can get it to work correctly, that is, return a null if it attempts to aggregate with a null in the values?
Example:
SELECT SUM("col")
FROM (
SELECT NULL "col"
UNION
...
This is my query:
insert into [Consolidated_LoB].[dbo].[consold]
([shp_to_pstl_cd]
,[LoB]
,[catlg_nbr]
,[shpd_qty])
select [POSTAL_CODE]
,[LoB]
,[PART]
,[SHIPPED_QUANTITY]
from [ITB_Pank].[dbo].[ITB_consoldtd]
and the message I receive is:
Arithmeti...
I have a table with a whole bunch of data. In that table there is a row, with not unique ids, so there can be dublets of them - I have found them by doing this query:
SELECT theid FROM thetable
GROUP BY theid
HAVING COUNT(*) > 1
In the table there is also columns like street1,street2,city1,cit...
