Learnsqlwithbru - learnsqlwithbru.com - Learn SQL With Bru
General Information:
Latest News:
How to find the Table which has Maximum Columns in a database 1 May 2013 | 10:04 pm
If you are interested to know about the table (in a particular database) that has most number of columns and how many columns.. You can run the below script.. SELECT NAME AS Table_Name, max_column_id_...
Download SQL Server 2012 Service Pack 1 15 Nov 2012 | 07:14 pm
Last week Microsoft released Service Pack 1 for Microsoft SQL Server 2012. If you have been waiting for the Service Pack 1 to be released, to apply on your existing SQL Server 2012 installations, then...
How to refresh Test, Dev Systems with Prod Data? 31 Jul 2012 | 08:34 pm
When I attended PASS Summit last October, there were many people whom I met during breakfast and lunch and sometimes in the lobby and we discussed a variety of topics on SQL Server. During one of tho...
Error when trying to use Database Engine Tuning Advisor 28 Jun 2012 | 10:01 am
Recently, I received an email from a user saying that on one of their SQL Servers, a developer was trying to use Database Engine Tuning Advisor (DTA) and the user was unable to use the tool, as there ...
Planning to take a Microsoft Certification Exam? 22 Jun 2012 | 11:11 pm
For those who are new to Microsoft Certifications or who have not taken a certification exam in the recent times, there are some changes in the exam format. I was looking for information on SQL Server...
Why Learn SQL? 14 Jun 2012 | 11:30 pm
If you have not yet encountered SQL (structured Query Language), then you may not be aware of the advantages which can be had from learning this particular programming language for yourself. However, ...
Alter an existing object rather than Drop and Create 29 Feb 2012 | 07:00 pm
In this blog I would like to write on a topic that I see many developers (and few DBA’s too) doing without trying to understand or think about the complete picture of what is affected. The task of mak...
Using DBCC UPDATEUSAGE to correct inaccuracies 2 Feb 2012 | 07:00 pm
Recently a friend of mine asked to help, their SQL Server was not showing correct database free space information even when they have added new data file. As they add new data into their database the ...
SSRS – Setting Page Properties for a Report 20 Jan 2012 | 07:05 pm
In the blog we shall learn how to change Report Properties in SQL Server Reporting Services. When you are in Business Intelligence Development Studio (in SQL 2005 or 2008, 2008 R2), with the report in...
Using sp_delete_backuphistory to delete backup history 17 Jan 2012 | 07:00 pm
You might be aware that system database msdb in SQL Server contains tables related to backup and restore operations of that Instance. Every time a database backup is performed, details regarding that ...
