Follow me !
Search this blog
-
Recent posts
Tags
AIX Apple automation backup best practices Bootcamp cloud cursor db2 db2 compression db2 hadr db2 performance db2 tuning db2 v9.5 db2 v9.7 db2move db2pd google indexes install iPad iPhone linux Macbook memory NULLID Oracle package performance restore runstats script shell script sql SQL805N SQL Server stored procedure tablespace time machine tuning ubuntu ubuntu 9.04 upgrade Windows on Mac wordpressDisclaimer
The posts here are solely my personal views and opinion. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with technical support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. I do not represent any vendor or product.
Category Archives: sql server
Quick way to get size of databases on a sql server instance
Here is a dirty little sql that will give you the size of all the databases in your instance : select DB_NAME(database_id) as DatabaseName, sum((size*8/1024) SizeInMB from sys.master_files group by database_id; This will list all the databases in the instance and … Continue reading
Posted in how to, sql server
Tagged database size, master_files, size of database in sql server
Leave a comment
SQL Server recovery using differential backup
One of my DBAs said while trying to restore differential backup he was getting : Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward … Continue reading
Posted in database, how to, sql server
Tagged Msg 3117, restore, restore differential backup, restore with no recovery, SQL Server
Leave a comment
I call it smart sp_who2
If you have been working on SQL Server, you would have definitely used sp_who2. One of the limitations of sp_who2 is that you cannot filter the result set directly and we all know how frustrating that can be sometimes. Obviously … Continue reading
Posted in sql server
Tagged filter sp_who2, join sp_who2, query sp_who2., smart sp_who2, sp_who2, sql server tidbits
Leave a comment
Search for keyword in SQL Server Objects
Have you ever had to search for some keyword in a database object code. Here is a piece of sql that will search through the database (not data) for a keyboard : select DISTINCT a.name from sysobjects a (NOLOCK) join … Continue reading
Posted in sql server
Tagged find a word, occurrence of a word, search for keyword, sql server search, sys objects
Leave a comment