No announcements
Found 4055386 threads
-
0 VotesHow do i make the below query Sargable ?
Yes, I did.Answered | 6 Replies | 2461 Views | Created by Chaithanya Reddy - Thursday, April 18, 2013 5:32 AM | Last reply by Gert-Jan Strik - Thursday, April 18, 2013 9:20 PM
-
11 Votes
Selectivity and SARGAbility?
How other engines handles things like year, substring etc I don't know.Answered | 12 Replies | 824 Views | Created by Samantha v - Saturday, December 16, 2017 4:49 AM | Last reply by Erland Sommarskog - Tuesday, December 19, 2017 10:43 PM -
0 Votes
Optimizing below query
Yes, it make sense, especially if the table is huge..Answered | 7 Replies | 924 Views | Created by SouravDutta - Wednesday, June 14, 2017 5:15 AM | Last reply by Uri Dimant - Wednesday, June 14, 2017 7:11 AM -
0 Votes
How do I get below query?
please check once, I have added one more record.Answered | 14 Replies | 777 Views | Created by Sunil404 - Monday, January 15, 2018 10:31 AM | Last reply by Visakh16 - Wednesday, January 17, 2018 6:35 AM -
1 Votes
How to get below query
Maybe this is just a fun exercise you are doing, but permit me to say that in the general this does not make sense.Answered | 10 Replies | 1226 Views | Created by SUNGG - Wednesday, October 9, 2019 5:25 PM | Last reply by Erland Sommarskog - Thursday, October 10, 2019 9:49 PM -
4 Votes
How can I replace the cursor in the below query?
Answered | 3 Replies | 1076 Views | Created by Mayooran99 - Thursday, April 16, 2015 10:03 AM | Last reply by scott_morris-ga - Thursday, April 16, 2015 12:42 PM -
1 Votes
What database change should I make to improve the performance of this query
I changed the data types of hbarcode and zbarcode to int and recreated the cluster index and the query performed very much faster.Answered | 5 Replies | 5936 Views | Created by desgordon - Tuesday, November 22, 2011 2:23 PM | Last reply by desgordon - Wednesday, November 30, 2011 2:45 PM -
0 Votes
I want to Optimise the below Query ??????
Do not put a scalar select inside the select list.Answered | 10 Replies | 2373 Views | Created by Wazid Ali - Friday, April 5, 2013 9:26 AM | Last reply by Wazid Ali - Monday, May 20, 2013 3:54 PM -
0 Votes
how do i start to make a query in sql server manegment studio ???????????
Hi, If your question is geared toward how to write TSQL Queries (irrespective of what client tool you use), please follow this link ...Answered | 4 Replies | 4242 Views | Created by zvi w - Wednesday, May 30, 2012 11:38 PM | Last reply by Sanil Mhatre - Thursday, May 31, 2012 3:13 AM -
0 Votes
how do i achieve the below requirement
Hello FranklinSentil, You can design the expected dataset via "Query Designer" to join "Customer", "Account type", "withdraw" and ...Answered | 3 Replies | 1225 Views | Created by FranklinSentil - Saturday, April 12, 2014 6:03 PM | Last reply by Elvis Long - Friday, April 18, 2014 2:43 AM -
0 Votes
what do I have to modify on below query to keep same order?
Often they do, but not always.Answered | 7 Replies | 895 Views | Created by cojimarmiami - Tuesday, June 3, 2014 1:28 PM | Last reply by johnqflorida - Tuesday, June 3, 2014 8:49 PM -
0 Votes
How to combine below 4 queries into a single query?
I try all above suggestions, but they do not work.Answered | 7 Replies | 830 Views | Created by TAN TH - Thursday, October 30, 2014 2:53 AM | Last reply by Visakh16 - Thursday, October 30, 2014 6:32 AM -
3 Votes
How to Speed Up This Query
Hello, there are two main performance killers used in your query - NOT IN clause String operations So, the main idea to make this ...Answered | 7 Replies | 3818 Views | Created by M Thomas - Wednesday, September 21, 2011 1:40 AM | Last reply by - Thursday, February 4, 2016 1:43 AM -
0 Votes
How do I make a loop?
Below is sample code how to use loops in C# console application class ForLoopTest { static void Main() { ...Answered | 7 Replies | 3039 Views | Created by KBobMan - Saturday, October 16, 2010 10:17 PM | Last reply by Rajesh Rolen - Tuesday, October 19, 2010 10:47 AM -
0 Votes
How to make the query faster
I have test the sql in query analyzer.Answered | 11 Replies | 3945 Views | Created by hi123456 - Saturday, July 10, 2010 6:52 AM | Last reply by Naomi N - Sunday, July 11, 2010 4:29 PM -
2 Votes
DeadLock Occurred What should I do
A common cause of deadlocks is that more data than needed is touched because: 1) additional indexes are needed to avoid scans 2) existing indexes are not ...Answered | 8 Replies | 835 Views | Created by Aadhira - Friday, September 11, 2015 4:48 AM | Last reply by Shanky_621 - Friday, September 11, 2015 1:02 PM -
0 Votes
How do i use these queries in Stored Proc.
Now what i have done is i just put that queries in stored proc with inputvariable @EtlLoadId = 0 and i get three different windows for each query ...Answered | 11 Replies | 4544 Views | Created by SqlRockss - Saturday, October 30, 2010 8:00 PM | Last reply by Erland Sommarskog - Sunday, October 31, 2010 7:42 PM -
2 Votes
How to generate the result for below Query
Try the below: create Table Table1(ID int, Name Varchar(50)) Insert into Table1 Values (1,'SP'), (2,'MN'), (3,'GG') create Table Table2(ID int, ...Answered | 3 Replies | 1456 Views | Created by JACK GANESH SP - Tuesday, June 11, 2013 3:17 AM | Last reply by Tom Cooper - Tuesday, June 11, 2013 3:32 AM -
2 Votes
DAX expression for below query
How should i write DAX expression in Direct query for above scenario?Answered | 1 Replies | 1037 Views | Created by rsathish.redcrackle - Monday, June 25, 2018 5:18 PM | Last reply by willson yuan - Tuesday, June 26, 2018 2:58 AM -
0 Votes
how do I translate if then to a query
I'm a newbie and I'm trying to figure out how I can write a query.Answered | 3 Replies | 4527 Views | Created by witdaj - Wednesday, April 20, 2011 4:21 PM | Last reply by Vern Rabe - Wednesday, April 20, 2011 4:51 PM - Items 1 to 20 of 4055386 Next ›
No announcements
