Category Archives: Experts

MSDB Size growing

Posted on September 12, 2019 by Vinay

msdb is growing due to queue. their is a great blog to help to reduce this How to reduce MSDB size from 42Gb to 200Mb query to get object size: USE msdb GO SELECT TOP(10) o.[object_id] , obj = SCHEMA_NAME(o.[schema_id]) … Continue reading →

Posted in Experts, Others, Performance Tuning, Troubleshooting | Tagged | Leave a comment

Day 1: MySQL History

Posted on May 1, 2018 by Vinay

Swedish Company: MySQL AB by – Michael Widenius (Monty), David Axmark and Allan Larsson Name Combination: Michael’s Daughter name –“My” and SQL Initially – PHP DB Extension to open source – not suitable for DBMS – Developed in(C & C++) … Continue reading →

Posted in Experts, Future DBA, History, Imp dates, MySQL, Others, RDBMS, What I learned today, Whitepapers | Tagged | Leave a comment

More IMPORTANT miscellaneous info

Posted on April 19, 2012 by Vinay

This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff. Okay, continue with Miscellaneous Info here is some more important stuff/ information about sql server. >>Ghost cleanup task runs every 5minuts … Continue reading →

Posted in Basic, Experts, Limitation, Others | Tagged , | Leave a comment

Suspect Database

Posted on December 19, 2011 by Vinay

Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to check and correct the issue. And sql server dba has to monitor it. Check the database consistence using DBCC CHECKDB … Continue reading →

Posted in Backup and Restore, Disaster Recovery, Experts, Troubleshooting | Tagged , , | Leave a comment

Miscellaneous Info

Posted on July 18, 2011 by Vinay

Some undocumented and important stuff   DMV: dbcc showcontig – index_physical_stats will scan complete index pages even if you use where clause Backup : uses 960k speed can reduce to 64k. Virtual File Space … for 32 bit system. Default big … Continue reading →

Posted in DMV, Experts, General, Others, Tool | Tagged , , | Leave a comment

Things to consider…

Posted on August 21, 2009 by Vinay

Hi…. I found some interesting COOL and Caution stuff on sql server, Will try to keep this updated…. Cool Stuff: 1.SSMS: now you can take output copy into excel with heading. SSMS Tips and Tricks http://blogs.msdn.com/billramo/archive/2009/05/15/dat315-session-review-for-ssms-tips-tricks-session.aspx 2.SSMS: Code Collapse and … Continue reading →

Posted in Computers and Internet, Experts | Tagged | Leave a comment

Experts Links – Very IMP

Posted on June 25, 2009 by Vinay

Sql server Experts: Aaron Alton The HOBT Aaron Bertrand Aaron Bertrand Aaron Lowe SELECT Thoughts FROM dbo.Brain Adam Machanic data manipulation for fun and profit Adam Rink My SQL Server Blog Adrian Downes Establish. Execute. Evolve. Alan Koo Microsoft Business … Continue reading →

Posted in Experts | Leave a comment

Ken Henderson Passed away…

Posted on March 18, 2009 by Vinay

Ken Henderson Passed away.. Hey today while surfing shocked i found this news that my feverate author…Guru. of sql server is passed away on jan 27 2008. http://blogs.msdn.com/sqlrem/archive/2008/01/28/ken-henderson-we-will-always-remember-you.aspx    

Posted in Experts | Leave a comment

my Favorite Part 1

Posted on July 21, 2008 by Vinay

  Hi Friends,   Today I would like to share my favorites on Sql server…   My Favorite Links A list of the bugs that are fixed in SQL Server 2000 Service Pack 4 After restore Database, transactional replication can’t … Continue reading →

Posted in Computers and Internet, Experts, General, Webcast, Whitepapers | Tagged , , | 2 Comments