Syndicated Blogs - Tejas Shah's Blog

Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked


	Syndicated Blogs

Upload Image

Close it

Select File

This blog is for SQL SERVER developers. I am trying to publish the things that i face in my development career, so other developers can get help out of this BLOG.


	Like

Invite Friends

Browse by Tags · View All

Tejas Shah	30
SQL SERVER 2005	11
SQL Server	10
SSIS	8
T-SQL	8
SQL Yoga	7
SSIS Task	7
SQLYoga	5
SQL Developer	5
DBA	5

Archive · View All

October 2012	5
October 2009	5
November 2012	3
December 2009	3
November 2009	3
September 2011	2
August 2010	2
April 2011	2
March 2010	2
September 2012	1

Tejas Shah's Blog

Home · Most Liked · Most Discussed · Fans (26) · Preferences

2
Liked

1
Comments

SQL SERVER: Display Row count of all the tables

Recently we have performance issue in SQL SERVER and we decided to move some large tables to different file group, so we can improve SQL SERVER performance, as it uses other disks I/O. Now challenge is to identify large tables from many tables (approx 700 tables).There are few ways to display row co......

Tejas Shah Posted on Aug 23 2010 2:02AM
Profile · Facebook

1
Liked

SQL SERVER: Find executing queries

Recently my company owner reported that SQL SERVER is running slow. I searched for it and get following T-SQL query. SQL SERVER provides dynamic views, which contains current information about all details. SELECT OBJECT_NAME(ObjectID) as ObjectName, st.Text, DB_NAME(database_ID) as dbname, ......

Tejas Shah Posted on Aug 1 2010 2:02AM
Profile · Facebook