Viewing 15 posts - 601 through 615 (of 1,158 total)
To answer a way you could do it in a single statment.
select a.SumAmt, (a.SumAmt * 5) as Totalamount
from
(Select (A1 + A2 + A2) as SumAmt) as a
February 2, 2012 at 5:44 am
johnitech.itech (2/2/2012)
Thank you 🙂 for your answer ,You save my time as i have the same Questions:hehe:
Didnt save you any time as you could have wrote the exact same thing...
February 2, 2012 at 5:40 am
SQLRNNR (2/1/2012)
Excellent dog!!!!!!!!!!
German shepherd 😀
February 2, 2012 at 5:05 am
Koen Verbeeck (2/2/2012)
SQL Kiwi (2/2/2012)
I just pass these by completely. On other sites, the question would simply be closed or deleted as too poor to exist.
Are you saying we...
February 2, 2012 at 5:04 am
An in place upgrade is what it says. All binaries and databases are upgraded in situ. Its generally not best practice as if it goes wrong you will...
February 2, 2012 at 3:17 am
You have 4 options that I can see:
-3rd party command line tool
-3rd party dll and .net script task in SSIS
-3rd party dll and .net CLR function
-Build your own
I'd err on...
February 2, 2012 at 3:00 am
Here's one way.
I can think of at least one other.
DELETE FROM LastUpdates
WHERE LastUpdateID NOT IN
(
SELECT TOP 10 LastUpdateID
FROM LastUpdates
ORDER BY DateLastUpdated DESC)
February 1, 2012 at 9:44 am
No reason why you cant increase it.
I've got it increased to 1/4 of my available cores on all servers. I dont expect to ever use that many...
February 1, 2012 at 8:09 am
Koen Verbeeck (1/31/2012)
Brandie Tarvin (1/31/2012)
Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list. Agree? Disagree?
Agree.
Just because...
February 1, 2012 at 3:35 am
sqlzealot-81 (2/1/2012)[hrAm very new to this server side tracing. Righ now am in a position to get the trace for my mid night at production. unfortunately, we need to caputre...
February 1, 2012 at 3:12 am
azhar.iqbal499 (1/31/2012)
We just need latest copy of our Database at target Server. We want to do this process at mid night. our DB size is 11GB and we...
February 1, 2012 at 3:07 am
Bru Medishetty (1/31/2012)
I wrote an article on this. It can be tweaked to your choice (in terms of how frequent you want to get alerts).http://www.mssqltips.com/sqlservertip/2307/automate-monitoring-sql-server-error-logs-with-email-alerts/%5B/url%5D
Personally, I prefer to be notified...
January 31, 2012 at 8:14 am
Viewing 15 posts - 601 through 615 (of 1,158 total)