Reputation
25,637
Next tag badge:
389/400 score
150/80 answers
Badges
3 32 83
Newest
 Enlightened
Impact
~1.4m people reached

2h
answered Where does SSMS Last database backup date come from?
13h
answered Tell SQL Server a query is ad hoc and not to optimize based on it
16h
comment SQL Server 2014 Avaliability Group DbMgrPartnerCommitPolicy
Let us know if the latest patch addresses the problem. I have not seen this in my environment.. So just curious to know.
18h
comment Problem connecting to SSRS reporting services - SQL Server 2014 to SSRS 2012
What version of SSMS are you using to connect to sql server 2005 Reporting server ? Seems problem with SSMS version.
19h
comment Index planning for many columns with different usage
@Zerotoinfinity I have it turned it on in my environment and no problems at all, but your environment is different than mine :-) .. so YMMW. It partitions the memory based on CUP and NUMA nodes which increases concurrency and performance. Also, for MAXDOP setting, you can use the script from here
19h
comment Index planning for many columns with different usage
@Zerotoinfinity since you are have a large number of CPUs, are you having Trace Flag - T8048 turned ON. Refer to Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 with high-performance workloads for some knobs to TUNE for your workload that will help you.
20h
reviewed Close DBMS_METADATA.GET_DDL not displaying complete DDL for big tables
20h
reviewed Close Issues with SQL Developer
20h
comment Index planning for many columns with different usage
You would never get around with a "universal" Index that fits all your queries. You should identify which are important and expensive (interms of IO and CPU time), so that you can create proper indexes and possibly rewrite them. Also, since you are on sql 2012 and if you are using AlwaysON, you can redirect the readonly SELECT queries to the readable secondary to offload the load from Primary.
22h
awarded  Enlightened
23h
comment SQL Server Agent logs in as guest on a linked server
Are the job owners same ? You may find SQL Server Agent jobs and user contexts. Also, sysinternals has whoami.exe that you can play around to debug your problem.
23h
revised SQL Server Agent logs in as guest on a linked server
added 11 characters in body
1d
revised How do I provide a failsafe for retrieval of data from excel to SQL
added 18 characters in body
1d
awarded  Nice Answer
1d
comment Does CPU utilization affect the cost of foreign NUMA access?
+1 really good and thorough answer.
1d
comment SQL Server 2014 Avaliability Group DbMgrPartnerCommitPolicy
Did you check windows event log ? Also, can you post the exact error with error number ? Any chance you did a force failover ?
1d
revised Select when group by contains more than one row with the same value?
added 22 characters in body
1d
revised Nice web GUI for inside of your database server?
edited tags
1d
revised Error: Cannot Generate SSPI context
deleted 2 characters in body
1d
revised Error: Cannot Generate SSPI context
edited body