|
|
-
|
|
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......
|
|
-
|
|
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 ......
|
|
-
|
|
Connecting to SQL Server from Excel is an easy process.
Users want to distribute an Excel document, for example, within
a network. Particuarly as there are plenty of libraries the user can access from Excel
as a presentation layer.
To implement this solution you will need:
Microsoft Excel
Vi......
|
|
-
|
|
SQL Kill connections on a database, sometimes is the most efficient way forward.I had to copy a whole bunch of MDF\LDF files from a server , but was experiencing some problems regarding user connections.
I was trying to detach using this code:
#####################code start######################......
|
|
-
|
|
BACKUP failed to complete the command BACKUP LOG is a common SQL Server error message.
In large IT departments a member of the Operations Team logs the call to a DBA queue.
An example message is
The 09.30 log backup also failed checked sqllog - 28-06-2011 09:30:22 Backup of
......
|
|
-
|
|
To analyse SQL Server IO requirements and decide on RAID levels for different applications is complicated – with some expensive decisions. As the DBA I have to make recommendations with analytics to justify decisions.
Firstly, my approach is end-to-end – look at everything from tuning,......
|
|
-
|
|
The SQL Server 2008 Books Online (October 2009) is one of my primary sources of
technical information about SQL Server 2008.
Best practises for SQL Server 2008
Tutorials
Conceptual outlines of SQL Server 2008 architecture
API details
Every SQL Server DBA......
|
|