Viewing 13 posts - 1 through 13 (of 13 total)
select top 10000 instance_id, job_name = sj.name, run_date, run_time, run_duration
--,convert(DATETIME,RTRIM(run_date)) as myrundate
--,convert(int,(run_time / 10000)) as run_time_hour
--,convert(int,(run_time / 100))%100 as run_time_minutes
--,convert(int,(run_time / 1))%100 as run_time_seconds
--,convert(int,(run_duration / 1000000)) as run_duration_days
--,convert(int,(run_duration / 10000))%100...
January 28, 2020 at 5:44 pm
I believe you are using <sys.
May 23, 2018 at 9:23 pm
You may find Microsoft product lifecycle @ http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=&Filter=FilterNO
Vijred
July 21, 2014 at 3:42 am
I use to create unique MonthID based on Year and month combination.
select (datepart(yy,SalesDate)-2010)*12+datepart(MM,SalesDate) as MonthID, sum(total)
group by (datepart(yy,SalesDate)-2010)*12+datepart(MM,SalesDate)
-- Assuming 2010 as the minimum month
June 20, 2014 at 12:24 am
Thanks for your quick response. If they are not able to recover, can I download the ISO from different MSDN subscription and install?
May 19, 2014 at 9:42 am
I believe the performance gain with truncate before drop is minimal to no gain. This is what I could practically see while deleting large table!
May 1, 2014 at 5:33 am
Someone please help me understand the logic? The result changes if I use NVARRCHAR instead of VARCHAR.
February 12, 2014 at 11:42 pm
Hi,
I believe you VPN into other network, please check runas command with /netonly option.
Refer following blog for additional information: http://vijredblog.wordpress.com/2014/02/05/connect-with-domain-controller-credentials-after-vpn-solution/
Thanks,
Vijay
February 12, 2014 at 5:23 am
This is great book, it helped me to enhance my DBA skills;
I have noticed a correction in the Query (session 4.6) which is already discussed in previous response.
Thanks,
Vijay
February 12, 2014 at 4:18 am
Thank you Durai for your time and help!
Yes, you are correct ARITHABORT was ON for my SQL Query window but was disabled on SSMS session.
FYI:
Used following query to verify the...
January 28, 2014 at 4:16 am
Yes, it is on the same server but on a different database.
Thanks,
Vijay
January 27, 2014 at 4:55 am
Viewing 13 posts - 1 through 13 (of 13 total)