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

Status and Name Please

By Andy Warren 2014/06/11 | Category: databases
Rating: (not yet rated) |  Discuss |   Briefcase | 1,630 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 | 948 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 | 8,057 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,164 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,464 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,606 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,164 reads

Maximum number of Databases.

By Jagadish Punnapu 2011/12/08 | Category: databases
Rating: (not yet rated) |  Discuss |   Briefcase | 2,197 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,061 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 | 8,057 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,207 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,219 reads

Model Database

By bitbucket-25253 2010/03/15 | Category: model database
Rating: (not yet rated) |  Discuss |   Briefcase | 3,711 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 | 8,057 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,694 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,281 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,512 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,638 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,047 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 | 2,013 reads
   Items 1 to 20 of 27    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)