There are different thoughts around Virtual vs IScSI in different scenarios , I prefer to be on ISCSI when my database sizes are huge.

Apart from that , I see...

Do you see any performance issues or complaints from your users other than it displaying in monitoring. ? If so I would recommend you do performance analysis using wait_stats...

Looks like you are kicking start a job from another job which is already running on schedule. you may need to remove the schedule of the job that is being...

Did you check dbcc sqlperf('logspace ') ? what amount of log is filled

For Crystal report , you need a license

For SQL server , if you just need management tools then no license is required where you can connect to any of...

Issue is when service pack has some script like this needs to be executed but the database is in restoring mode because it is involved in Always On secondary.

Resolution...

Yes, Hyper-V is not ideal in simple it do not understand the transactions level of granularity in SQL server which needed protect the data loss and point in-time recoveries.

Since...

I don't know exactly where is getting us_english either from session requestor or SQL srever or OS but when I see the system code of sys.dm_exec_requests

CREATE VIEW sys.dm_exec_requests AS

SELECT...

HTML Code be stored in SQL tables as text format and when rendered through application into browser it will display html pages but SQL Query analyzer do not understand what...

http://sqlserverbuilds.blogspot.com/ - Check here for all builds.,

Looks like you already have SQL server 2012 SP1 , CU9 and you might installed CU1 on top of it but anyway...

Will create specific tables for each table you enable CDC and alos there are common use tables for metadata

You do not need to uninstall or re-install, when you do a true-up or new agreement you just tell them how many cores you have on sql box, if it...

After i installed service pack 2 for SQL server 2012 SP1, x64 on windows server 2012 and have always on enabled with isolated disks. I was unable...

I'm seeing 32 CPU and are online when I run sys.dm_os_scheduler.

So that means SQL server is able to use all the 32 available. I checked no affinity is...

No of estimated rows are derived from last updated statistics. as long as your stats are updated the estimated number of rows will match to the actual number of...