|
|
-
|
|
Calculate the physical size of a SQL Server database table (data and indexes), if rows exist. These steps present a good estimate
Use sp_spaceused ‘myTableName’.
To maintain up to date data, use DBCC UPDATEUSAGE before the sp_spaceused.
For a specific table:
DBCC UPDATEUSAGE(&l......
|
|
-
|
|
I collect database usage information in two different ways. Snapshots and Monitoring Events. Either method collects real-time database usage information such as SQL queries, buffer pool activity and locking information.
An event monitor is a statement that defines a monitor to record defined eve......
|
|
-
|
|
A developer asked me if he could install “microsoft.office.interop.excel.dll” on a Production database server. This dll is part of the Microsoft Excel 11.0 Object Library.
This would satisfy his requirement to run a transformation on an Excel file, as part of a SSIS job.
The database s......
|
|
-
|
|
A DB2 instance wouldn't start at boot time. I checked db2set and it was AUTOSTART=YES.
After some investigation I discovered the missing fmc section from inittab.
The fmc refers to the Fault Monitor Coordinator.
I resolved the problem by executing:
/opt/IB......
|
|
-
|
|
The Storage \ SAN administrator asks “ can I have some targets to aim for in testing
a new storage IO subsystem
installation”. Of course, as the SQL Server DBA I normally reply by saying “ I
don’t have any targets apart from activity type ......
|
|
-
|
|
As part of the Performance Tuning series – Performance Stack, this section looks at Buffer Managment tuning. The purpose of the series is a general approach to Performance Tuning – independent of database server platform. A large proportion of DBAs support more than one type of databas......
|
|
-
|
|
The Storage manager asks the DBA questions about SQL Server Storage suggestions. As the DBA you will need to answer or advise the recommendations. This could happen when a) a new storage array is under consideration b) Performance analysis c) Data Centre migrations.
These are questions I&rsqu......
|
|
-
|
|
The theme for T-SQL Tuesday 21 is reveal your crap to the world.
Like anyone, we all have significant amounts to share, particularly if you work in a busy production environment. Deadlines are tight, business users want everything yesterday which all amounts to decreasing standards of quali......
|
|
-
|
|
The first phase of the optimization is called the Trivial Plan. If the Optimizer decides the submitted query is simple, it will generate a single Trivial Plan. The Optimizer will not spend additional time in selecting the Optimal Plan.
This code displays the occurrence of the Trivial plan. The fi......
|
|
-
|
|
Use the uncatalog\catalog of a database to rename a database. An alternative to the db2relocatedb method.
If this is an option, uncatalog the db and then catalog it with a new alias:
$ db2 create db mydb
$ db2 uncatalog db mydb
$ db2 catalog db mydb as a_new_name
The database name name re......
|
|