Browse by Tags

SQL server data base restore script
Friday, July 03, 2009 7:29 AM

this is a quick trick that i googled from bits and pieces in a caffe when my laptop didn’t have a Management studio installed i found a way to execute sql scripts to my instance of sql express well to restore you need to have the logical names of files in the database backup to know that just type RESTORE FILELISTONLY FROM DISK = ‘<path to your backup file>... Read More...

by amir.magdy | with no comments

Filed under: tips, SQL Server

Database or Object Size in SQL server [sp_spaceused]
Monday, June 01, 2009 1:02 AM

Space used by the objects in the database is a tricky subject, this can be very useful when planning your database maintenance plan a system stored procedure as you probably had figured is called sp_spaceused gets you the needed information that procedure can be used in multiple ways use Northwind exec sp_spaceused when this is executed against your database... Read More...

by amir.magdy | with no comments

Filed under: tips, SQL Server

SQL Profiler custom filter
Friday, November 23, 2007 8:13 AM

the tip is simple u need to make a filter that filters and shows only your DB transactions on a server. what u need to do is to change your web.config by adding a string that you can later filter on 1: < add key ="Main.ConnectionString" 2: value ="data source=Server;initial catalog=dbName; 3: User ID=sa;Password=userName;application name=thisIsTheFilter"... Read More...

by amir.magdy | 1 comment(s)

Filed under: tips, asp.net, SQL Server