|
|
-
|
|
When you attempt to execute a Powershell script you may see something like the following error message:
File C:\general.ps1 cannot be loaded because the execution of scripts is di
sabled on this system. Please see "get-help about_signing" for more details.
At line:1 char:14
+ ./general.ps1 All S......
|
|
-
|
|
A developer made a small change to a sql statement - and assumed that this would not have a significant impact on performance. The change caused the optimizer to use a Clustered Index Scan – with over 10 million records – as opposed to a NonClustered Index Seek, which was using an effi......
|
|
-
|
|
1. The purpose of mincommit
is to delay the write to disk of the log records. The count is the number of commits.
Depending on your app, you may have to consider increasing logbufsz
Test thoroughly ......
|
|
-
|
|
I worked as a Remote DBA for 3 years, to an international company. I was employed to supplement an existing Developer\DBA – in more advanced tasks. For example, performance tuning , occasional capacity planning, advice on failover – and troubleshooting issues
The interesting aspects of ......
|
|
-
|
|
An ETL based process importing data into a Datawarehouse was experiencing some sever performance problems. The job normally takes 4 hrs – but on this occasion was still running after 10 hrs. Application support contacted me, to analyse the cause.
Talking to application support – they ......
|
|
-
|
|
scheduling,viewing, performing admin tasks
Allows DB2 discovery to discover and collate informatio......
|
|
-
|
|
I have the thresholds set at 95% for tablespace used. When the threshold is met
a message is triggered like:
USERSPACE1 in MYDB has 95 pct used. Instance: db2inst1 First Occurrence: Tue Feb
01 15:29:58 2011 Last Occurrence: Tue Feb 01 15:29:58 2011 Email client: smtp1.mypr......
|
|
-
|
|
Upon upgrading a SQL Server 2000 to SQL Server 2005 Standard Edition instance – this error message appeared on a SQL Server trace error event:v
Msg 2801, Level 16, State 1, Procedure myTrigger, Line 13
The definition of object ‘myTrigger’ has changed since it was compiled.
T......
|
|
-
|
|
Depending on the time available – I will normally commit a RESTORE VERIFY ONLY on a backup.
With the statement:
RESTORE VERIFYONLY FROM DISK = ‘E:\backuppath\mydb.bak’
I’m not advocating that RESTORE VERIFYONLY – will 100% guarantee that your database has full data......
|
|