<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
Databases
Items 1 to 20 of 23
Next 20 >>
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
|
4,278 reads
Smart Index Rebuild - All Databases
Rebuilds all indexes from all databases over a specified fragmentation threshold.
Read more...
By
Tim Hollobon
2012/11/08
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
1,662 reads
Maximum number of Databases.
Read more...
By
Jagadish Punnapu
2011/12/08
|
Category:
databases
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,170 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,027 reads
Track database growth
Script to keep track your database growth - Works with SQL 2000, 2005 & 2008
Read more...
By
Irwan Tjanterik
2011/07/19
|
Source:
SQLServerCentral.com
|
Category:
databases
Rating:
|
Discuss
|
Briefcase
|
6,336 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,087 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,186 reads
Model Database
Read more...
By
bitbucket
2010/03/15
|
Category:
model database
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,680 reads
Track database growth
Script to keep track your database growth - Works with SQL 2000, 2005 & 2008
Read more...
By
Irwan Tjanterik
2011/07/19
|
Source:
SQLServerCentral.com
|
Category:
databases
Rating:
|
Discuss
|
Briefcase
|
6,336 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,195 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
|
3,171 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,111 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,451 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
|
1,939 reads
Find information about all databases
ALL database information
Read more...
By
umar iqbal
2013/05/21
|
Source:
SQLServerCentral.com
|
Category:
databases
Rating:
|
Discuss
|
Briefcase
|
1,840 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
|
4,278 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
|
845 reads
how get primary key in any database
drop the primary key name is different for each database
Read more...
By
Furanshizuku
2009/01/29
|
Source:
SQLServerCentral.com
|
Category:
primary key (pk)
Rating:
|
Discuss
|
Briefcase
|
1,233 reads
Security
Read more...
By
Steve Jones
2008/12/04
|
Category:
security
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,152 reads
How to Drop Unused Empty Redundant columns
Often during the development lifecycle columns are added to tables that become redundant or remain unused. this script removes unused (empty) columns
Read more...
By
Chris Morton
2008/11/27
|
Source:
SQLServerCentral.com
|
Category:
alter table
Rating:
|
Discuss
|
Briefcase
|
1,119 reads
Items 1 to 20 of 23
Next 20 >>
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)
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)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
