SQL Server Education (by the geeks, for the geeks)
Hi Friends, I received a mail today from a DBA who was facing some issues with SQL Server Performance Monitor tool on Windows Server. And he was frustrated. Why? When he …
SQL Server Performance Monitor – Does Performance Monitor frustrate you? Read MoreHi Friends, Apologies for getting back late on this, I was buried under some assignments clubbed with hectic travel schedule. So, sometime back I had posted this to be solved by …
SQL Server – Strange things do happen, but why are they allowed in the first place – THE ANSWER Read MoreHi Friends, Solve this… (the picture speaks a thousand words) Any guesses? Comments?
SQL Server – Strange things do happen, but why are they allowed in the first place? Read MoreHi Friends, In one of our recent migrations, we got the following error when the client tried to fire xp_cmdshell system stored procedure through some client code. Msg 15153, Level 16, …
SQL Server xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the ‘##xp_cmdshell_proxy_account##’ credential exists and contains valid information Read MoreHi Friends, Ask any SQL DBA for his favorite SQL Server Keyboard Shortcuts and most would reply; ALT + F1. But what has gone wrong now? Option 1: Select the table …
SQL Server Keyboard Shortcuts – what happened to the amazing ALT + F1 keyboard shortcut? Read MoreHi Friends, Last week, I blogged about Trace Flag 4136: https://www.sqlservergeeks.com/sql-server-did-you-know-about-trace-flag-4136/ and bunch of other posts related to parameter sniffing: https://www.sqlservergeeks.com/sql-server-using-optimize-for-query-hint/ https://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/8/forceseek-hint-in-sql-server-2008-part-i https://www.sqlservergeeks.com/sql-server-forceseek-hint-in-sql-server-2008-part-ii-working-with-parameter-sniffing/ I got a question from reader asking me …
SQL Server OPTIMIZE FOR UNKNOWN to disable parameter sniffing at query level Read MoreHi Friends, This blog post is a result of a question asked by a DBA from my client side: “Why am I seeing RangeS-U locks along with RangeX-X locks when I …
SQL Server Key Range Locks – RangeX-X and RangeS-U Read MoreHi Friends, Parameter Sniffing, in general, is a good thing and your queries can benefit from that. Here are some of my blogs posts that you can read to get some …
SQL Server – Did you know about Trace Flag 4136 ? Read MoreHi Friends, Last week I spent some time with SQL Server Integration Services 2012 parallelism and thread monitoring. Here are some learnings: MaxConurrentExecutables setting at package level determines the number of …
SQL Server Integration Services 2012 (SSIS) thread monitoring and parallelism Read MoreHi Friends, I had built a SQL Server Hyper-V virtual machine on my laptop which has Windows Server 2008 R2 with Service Pack 1. I deployed the VM on my client’s …
SQL Server Hyper-V error – The application encountered an error while changing the state – VM could not be initialized – Failed to set/change partition property Read More