Viewing 15 posts - 9,061 through 9,075 (of 49,571 total)
What exactly do you mean?
The query was doing table scans and now isn't? Something else?
May 14, 2014 at 4:43 am
Koen Verbeeck (5/14/2014)
This was a funny topic 😀 (especially the last replies)
Sorry, am a little short on patience today.
May 14, 2014 at 4:40 am
Um, really?
You have a working query, and you're asking what changes to make? Maybe replace the non-working query with the working query?
May 14, 2014 at 4:10 am
If you check using the ASCII function, they're different characters. The first is ASCII code 130, the second is ASCII code 44
SELECT ASCII('‚')
SELECT ASCII(',')
One was copied from Word and one...
May 14, 2014 at 3:59 am
shohelr2003 (5/14/2014)
GilaMonster (5/14/2014)
The trace will show the modifications, but it's high overhead. Maybe a trigger?
Yes, I found information that someone has opened Edit window but did not find what has...
May 14, 2014 at 3:22 am
Haven't we been over this a couple times already?
http://www.sqlservercentral.com/Forums/Topic1553317-391-1.aspx
http://www.sqlservercentral.com/Forums/Topic1549110-391-1.aspx
http://www.sqlservercentral.com/Forums/Topic1548615-391-1.aspx
May 14, 2014 at 3:18 am
Follow the articles I referenced, identify the queries with the highest CPU usage overall (not the one high one at a time you look at the server), tune them to...
May 14, 2014 at 12:57 am
Wait.
Once recovery completes the database will come online.
May 14, 2014 at 12:54 am
The trace will show the modifications, but it's high overhead. Maybe a trigger?
May 14, 2014 at 12:53 am
william.rees.howells (5/13/2014)
May 13, 2014 at 2:30 pm
william.rees.howells (5/13/2014)
First) We do a full backup of our DB every Sunday, and then a log backup every night until the next Sunday to enable point in time recovery.
That will...
May 13, 2014 at 1:54 pm
lsalih (5/13/2014)
Thank you both. So how you correct the query to print 1.9?
Um, maybe using the code I posted?
May 13, 2014 at 8:54 am
lsalih (5/13/2014)
hi Gail -Sorry, one correction... I just realized that the user wanted to get the actual decimal result, in this case the result should print 1.9.
It prints 1 because...
May 13, 2014 at 7:37 am
The first problem is you're declaring the variables as integer and then assigning a value with a decimal. SQL will truncate this, so set @val1 = 1.9 results in @val1...
May 13, 2014 at 7:21 am
Grant Fritchey (5/13/2014)
I'm being blunt and honest here, I see very little opportunity to tune this query. You should reassess the approach.
Agreed.
I've had several major tuning wins by removing temp...
May 13, 2014 at 7:11 am
Viewing 15 posts - 9,061 through 9,075 (of 49,571 total)