SQL Server Journey with SQL Authority

Posted in Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology | 7 Comments

7 Responses

1. on July 8, 2008 at 6:31 pm | Reply C.Y

   This is the best SQL Blog ever. TY.

   
   
2. on July 9, 2008 at 3:37 am | Reply Mike

   Cool tip. I really enjoy your blog! I come here whenever I have a SQL problem. Thanks!

   
   
3. on July 10, 2008 at 6:14 pm | Reply Abhijit

   Hi Pinal,
   Does it shows the excat data. Suppose there is bulk operation happed in that case it will show the excat data..?

   
   
4. on July 11, 2008 at 6:50 pm | Reply Amit Jain

   Hi Pinal,

   Is there any way to use replace function for ntext data type. If i want to change a particular text in all columns and all tables in a database. How can i resolved it ?

   Please suggest. Thanks in advanced

   
   
5. on July 18, 2008 at 9:16 pm | Reply Lynn

   I think you need to run DBCC UpdateUsage before you run sp_spaceused in order to get a correct result.

   
   
6. on October 22, 2008 at 3:07 pm | Reply Sri

   You will need to have sa role to find the space usage of all databases. Is there any work around for this?

   
   
7. on March 2, 2013 at 12:06 pm | Reply Pratik Pawar

   Sir m storing image of visitorsand visitor data in a visitor table. The database has become to heavy i doubt its becuz of the size of image is there any way to know the size occupied by a specific column plz. let me know on my email id

   
   

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Notify me of follow-up comments via email.

Notify me of new posts via email.