SQL Server Education (by the geeks, for the geeks)
Hello Geeks, Beginning with SQL Server 2005, as part of the Database Maintenance Plans, MS introduces the “History Clean Up” tasks. SQL Server stored procedure SQL Server sp purge jobhistory removes …
SQL Server sp purge jobhistory – To delete job history Read MoreSQL Server – The description for Event ID 22 from source MSSQLServerOLAPService cannot be found. Either the component that raises this event is not installed on your local computer or the …
The description for event id 22 from source mssqlserverolapservice cannot be found Read MoreIn the previous article of this series, we discussed about the overall SQL server architecture and the Network Interface (specially). In this article we’ll discuss about the next, but very important …
SQL Server Architecture Part 2: The Relational Engine Read MoreHi geeks, First of all I would like to make an apology for not posting any blogs for the last two months (was busy with my work) but it’s better late …
SQL Server Execution Plan – Part 1 (Basics) Read MoreHello Geeks, I would like to thank Amit Sir for giving me the opportunity to blog on SQL Server topics. This being my first blog, I am staring with SQL server …
SQL Server sp_help_job – To get the status of a SQL Job Read MoreHello, SQL Server Constraints can be defined as rules that govern the values that are inserted into a column. These rules help in enforcing data integrity. For example if a NOT …
SQL Server Constraints Read MoreHello Readers, This is the first part of the series of articles describing the SQL Server architecture. But before starting the discussion, I would like to thank Amit Sir for giving …
SQL Server Architecture Part 1 Read MoreHi geeks, hope you all enjoyed my last blog on SQL Server Statistics Only database. In this blog we will explore one possible solution to the problem all database developer and …
SQL Server Track Deprecated Features with Extended-Events Read MoreHi Geeks, First of all I would like to thank Amit Sir and SQLServerGeeks.com for giving me this opportunity to blog. This is my 1st blog on SQL Server Statistics Only …
SQL Server Statistics Only Database Read More