Reworked sp_msforeachdb by Aaron… nice post

 No Responses »
Oct 122011
 

We all have been using the sp_msforeachdb sp without giving it a though or going through the code.. because it is such fun running these sp’s that we kind of ignore the background process and relative performance issues that go along with these, and overall we are happy that we have something that gives us the power to run a query against all instead of running the query one db at a time.

Thanks to out SQL experts like Aaron / Kimberly / Paul and team and tons of other experts who provide such wonderful advice and help us rethink our strategies when it comes to databases.

ok, so I was talking about a good article by Aaron where he rightly points out the older version of sp_msforeachdb sp and he has a reworked version.

http://www.mssqltips.com/sqlservertip/2201/making-a-more-reliable-and-flexible-spmsforeachdb/

 Posted by maninder at 8:20 pm  Tagged with: ,

ETL World Record!

 No Responses »
Feb 142011
 

Nice Post to show the Efficiency of SQL Server 2008.. Check it out.

How fast was the data load?

More than one terabyte of data was parsed from flat files, transferred over the network and loaded into the destination database in less than 30 minutes, a world record beating all previously published results using an ETL tool. That is a rate in excess of 2 TB per hour (650+ MB/second). To be precise, 1.18TB of flat file data was loaded in 1794 seconds. This is equivalent to 1.00TB in 25 minutes 20 seconds or 2.36TB per hour

http://blogs.msdn.com/b/sqlperf/archive/2008/02/27/etl-world-record.aspx

 Posted by maninder at 8:07 am  Tagged with: , ,

SQL Server – New Drives Use 4K Sector Size

 No Responses »
Feb 012011
 

Nice Post by: BOB DORR (Microsoft Customer Service and Support (CSS) SQL Support)

I would recommend everyone using SQL Server to go through these Posts.. Nice Post help you understnad what you would have missed.

http://blogs.msdn.com/b/psssql/archive/2011/01/13/sql-server-new-drives-use-4k-sector-size.aspx

It Talks about the Drive with sector size of 4K. The new focus of the HDD manufacturers.

 Posted by maninder at 9:53 am  Tagged with: ,

How to Move Data and Log Files for Replicated Databases

 No Responses »
Jan 182011
 

use the MODIFY Command rather than using other methods.

MODIFY FILE ( NAME = logical_file_name, FILENAME = ‘ path/physical_file_name ‘ )

After you are done running the above command, you can set the database offline or detach the database and then move the physical MDF/NDF/LOG Files to another location as specified in the command above.

Bring the database online or attach the files.

 Posted by maninder at 9:20 am  Tagged with:

Discussion About SQL Server I/O

 No Responses »
Jan 142011
 

Very Awesome BLOG Post By BOB Dorr. Thanks BOB for this nice post.

Again Everybody has to read this.(If you fall in the percentage who wants to understand the internals)

http://blogs.msdn.com/b/psssql/archive/2011/01/07/discussion-about-sql-server-i-o.aspx

 Posted by maninder at 10:03 am  Tagged with: ,

PowerPivot Technical Diagram: PowerPivot Client/Server Architecture

 No Responses »
Dec 272010
 

As Per CAT (Customer Advisory Team)

Because Power Pivot for Excel and Power Pivot for SharePoint involve many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster contains all of the key components that make up Power Pivot in one view. This view includes nearly all of the logical architecture components and illustrates how these components work together

http://sqlcat.com/whitepapers/archive/2010/04/23/powerpivot-technical-diagram-powerpivot-client-server-architecture.aspx

 Posted by maninder at 7:21 pm  Tagged with:

Cannot Drop Database because of a DDL Trigger for Drop Database Event

 No Responses »
Nov 152010
 

There are situations where the database might have a DDL Trigger for DROP Event. In that case you will not be able to drop the database and it will throw a error when you try to DROP the database.

The only thing(s) you can to do in this case is Drop the Trigger Or Change the Trigger Code before the Event and do whatever you need to.

 Posted by maninder at 9:32 am  Tagged with: ,
 Older Entries
© 2010 D B A N A T I O N Suffusion theme by Sayontan Sinha