Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Databases Rss

   Items 1 to 20 of 25    Older >>
 

Track database growth

Script to keep track your database growth - Works with SQL 2000, 2005 & 2008  Read more...
By Irwan Tjanterik 2014/01/16 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 7,867 reads

Smart Index Rebuild - All Databases

Rebuilds all indexes from all databases over a specified fragmentation threshold.  Read more...
By Tim Hollobon 2013/12/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,060 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 12,191 reads

Database Growth History

This script uses the backup tables to get info on the growth of your database files.  Read more...
By Nicholas Williams 2013/05/07 | Source: SQLServerCentral.com | Category: growth
Rating: |  Discuss |   Briefcase | 5,262 reads

Smart Index Rebuild - All Databases

Rebuilds all indexes from all databases over a specified fragmentation threshold.  Read more...
By Tim Hollobon 2013/12/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,060 reads

Maximum number of Databases.

By Jagadish Punnapu 2011/12/08 | Category: databases
Rating: (not yet rated) |  Discuss |   Briefcase | 2,190 reads

Set standard database options

Ensure all your databases have standardised options by running this script weekly.  Read more...
By Ed Vassie 2011/09/19 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 2,059 reads

Track database growth

Script to keep track your database growth - Works with SQL 2000, 2005 & 2008  Read more...
By Irwan Tjanterik 2014/01/16 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 7,867 reads

Relationship between users and Databases

Show the users inside the databases  Read more...
By Ricardo Leka 2011/05/30 | Source: SQLServerCentral.com | Category: user
Rating: |  Discuss |   Briefcase | 2,184 reads

How to output datafiles location using sp_helpdb?

This is a quick way of outputting the location of your database files/dbsize/date created on your instance.   Read more...
By anthonyszm 2010/07/02 | Source: SQLServerCentral.com | Category: sp_helpdb
Rating: |  Discuss |   Briefcase | 1,214 reads

Model Database

By bitbucket-25253 2010/03/15 | Category: model database
Rating: (not yet rated) |  Discuss |   Briefcase | 3,702 reads

Track database growth

Script to keep track your database growth - Works with SQL 2000, 2005 & 2008  Read more...
By Irwan Tjanterik 2014/01/16 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 7,867 reads

How to Create a Reporting Services 2005/2008 Template

  At most large companies one business requirement is that all reports have the same look and feel.  This may vary...  Read more...
By Patrick LeBlanc 2009/11/24 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 4,570 reads

MSDE – Database Size Limit

Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...  Read more...
By Patrick LeBlanc 2009/10/13 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,196 reads

Windows Internal Database

This past Friday I received a call from our systems team stating that they were running low on Disk Space...  Read more...
By Patrick LeBlanc 2009/09/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,479 reads

SQL Server 7.0 – Transaction Log Not Backing Up

I have not worked with SQL Server 7.0 in a loooong time.  So when I received a call from a...  Read more...
By Patrick LeBlanc 2009/09/14 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,616 reads

Using SQL Server Data Mining Add-Ins for Office 2007 to Predict Database Growth Trends - Part 2

I want to show you another easier way to pull information to help predict database growth again using the Data Mining Tools.  Read more...
By Additional Articles 2009/07/22 | Source: MSSQLTips.com | Category: data mining
Rating: (not yet rated)  Rate this |   Briefcase | 2,016 reads

Find information about all databases

ALL database information  Read more...
By umar iqbal 2009/04/28 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 1,974 reads

Database Growth History

This script uses the backup tables to get info on the growth of your database files.  Read more...
By Nicholas Williams 2013/05/07 | Source: SQLServerCentral.com | Category: growth
Rating: |  Discuss |   Briefcase | 5,262 reads

Growth remaining for SQL Server 2005 databases

This script is little bit similar to the one posted for SQL Server 2000 that finds how much space you have left.  Read more...
By Mahidhar Vattem 2009/01/30 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 868 reads
   Items 1 to 20 of 25    Older >>
 
Tags
blogs (4)    
learning (4)    
sql server (4)    
patrick leblanc (3)    
script (3)    
articles (2)    
indexing (2)    
microsoft (2)    
security (2)    
sp_helpdb (2)    
sql server 2005 (2)    
sql server 7 (2)    
user (2)    
administration (1)    
all (1)    
alter table (1)    
data mining (1)    
empty columns (1)    
excel (1)    
file size (1)    
files and filegroups (1)    
frag (1)    
fragmentation (1)    
grant (1)    
growth (1)    
logins (1)    
metadata (1)    
model database (1)    
msde (1)    
permissions (1)    
primary key (pk) (1)    
rebuild (1)    
redundant columns (1)    
relationship (1)    
remove empty columns (1)    
remove redundant columns (1)    
reporting services (ssrs) (1)    
role (1)    
run (1)    
scripting (1)    
setup (1)    
size (1)    
sp_msforeachdb (1)    
system stored procedure (1)    
t-sql (1)    
windows (1)