Steps to install Service Pack for SQL Server 2005 – Multiple Instances
Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :-
Step 1 : First page of...
2014-07-28 (first published: 2014-07-21)
8,001 reads
MSSQLFUN
How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation. SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’ FROM SYS.SERVER_PRINCIPALS WHERE SID =...
2014-07-17
6 reads
How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation.
SELECT @@SERVERNAME...
2014-07-17
1,848 reads
Mainstream Support End || SQL Server 2008 and SQL Server 2008 R2
Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 was ended on July 8th 2014. This will result no enchantment or no future release of SPs. Somehow,...
2014-07-14
How to restore MSDB & MODEL database – SQL Server System Databases?
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail....
2014-07-14
4 reads
Mainstream Support End || SQL Server 2008 and SQL Server 2008 R2
Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 was ended on July 8th 2014. This will result...
2014-07-14
608 reads
How to restore MSDB & MODEL database – SQL Server System Databases?
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as...
2014-07-14
16,105 reads
How to change TempDB system Database files location?
Steps to change TempDB system Database files location :- 1) Check current file location of TempDB Exec SP_helpDB TempDB You can use below query as well for file location...
2014-07-07
3 reads
How to change TempDB system Database files location?
Steps to change TempDB system Database files location :-
1) Check current file location of TempDB
Exec SP_helpDB TempDB
You can use below...
2014-07-07
14,401 reads
Cumulative Update – 2 for SQL Server 2014 RTM Is Now Available !
The 2nd cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since...
2014-07-02
2 reads
Blogs
Advice I Like: Experience and Aptitude
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
Plan Time for Self-Development
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
BK’s Bookshelf: Never Split the Difference
By Brian Kelley
I picked up Never Split the Difference: Negotiating As If Your Life Depended On...
Forums
Which Affiliate Advertising Companies to Choose?
Affiliate marketing has become a popular way for businesses to expand their reach and...
Insiders Selling Data
Comments posted to this topic are about the item Insiders Selling Data
Join 2 tables
Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M ServerA N...