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 28    Older >>
 

Track database growth

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

Status and Name Please

By Andy Warren 2014/06/11 | Category: databases
Rating: (not yet rated) |  Discuss |   Briefcase | 1,726 reads

Size of database files for an instance of SQL Server

Size of database files for an instance of SQL Server  Read more...
By Andrés Michaca 2014/05/07 | Source: SQLServerCentral.com | Category: file size
Rating: |  Discuss |   Briefcase | 1,013 reads

Track database growth

Script to keep track your database growth - Works with SQL 2000, 2005 & 2008  Read more...
By Irwan Tjanterik 2014/09/23 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 9,271 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,229 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,598 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,745 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,229 reads

Maximum number of Databases.

By Jagadish Punnapu 2011/12/08 | Category: databases
Rating: (not yet rated) |  Discuss |   Briefcase | 2,205 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,067 reads

Track database growth

Script to keep track your database growth - Works with SQL 2000, 2005 & 2008  Read more...
By Irwan Tjanterik 2014/09/23 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 9,271 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,214 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,220 reads

Model Database

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

Track database growth

Script to keep track your database growth - Works with SQL 2000, 2005 & 2008  Read more...
By Irwan Tjanterik 2014/09/23 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 9,271 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,879 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,487 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,558 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,657 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,070 reads
   Items 1 to 20 of 28    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)    
t-sql (2)    
user (2)    
administration (1)    
all (1)    
alter table (1)    
data mining (1)    
db_name() (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)    
windows (1)