I have received many many request to do another series since my series SQL Server Interview Questions and Answers Complete List Download. I have created small series of Coding Standards and Guidelines, as this is the second most request I have received from readers. This document can be extremely long but I have limited to very few pages as it is difficult to follow thousands of the rules. My experience says it is more productive developer and better code if coding standard has important fewer rules than lots of micro rules.
SQL SERVER – 2005 Explanation and Example – SELF JOIN
A self-join is simply a normal SQL join that joins one table to itself. This is accomplished by using table name aliases to give each instance of the table a separate name. Joining a table to itself can be useful when you want to compare values in a column to…
Read MoreSQL SERVER – 2005 – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005 – Download SQL Server MOM 2005
The Microsoft SQL Server Management Pack provides both proactive and reactive monitoring of SQL Server 2005 and SQL Server 2000 in an enterprise environment. Availability and configuration monitoring, performance data collection, and default thresholds are built for enterprise-level monitoring. Both local and remote connectivity checks help ensure database availability. Features…
Read MoreSQLAuthority News – Subscribe to Feed in Email
You can subscribe to SQLAuthority.com Feed using Email. Email will be delivered to your preferred email address when new post appears on SQLAuthority.com Subscribe to SQLAuthority Feed Through Email Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQLAuthority News – Dedicated Search Engine for SQLAuthority – Search SQL Solutions
Visit search.SQLAuthority.com I have been receiving many questions asking for tutorials, suggestions or questions about topics I already have wrote before but readers are have not found it or having difficulty to find them. I have almost around 200 articles on this blog so far and it is growing. One…
Read MoreSQL SERVER – 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length
One of the Jr. DBA at in my Team Member asked me question the other day when he was replacing TEXT field with VARCHAR(MAX) : How can I limit the VARCHAR(MAX) field with maximum length of 12500 characters only. His Question was valid as our application was allowing 12500 characters.…
Read MoreSQL SERVER – Retrieve Information of SQL Server Agent Jobs
sp_help_job returns information about jobs that are used by SQL Server Agent service to perform automated activities in SQL Server. When executed sp_help_job procedure with no parameters to return the information for all of the jobs currently defined in the msdb database.