|
|
-
|
|
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 ......
|
|
-
|
|
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 ......
|
|
-
|
|
An interesting feature of the RUNSTATS facility – as well as collecting statistics asynchronously (in the background), it can also set a synchronous collection – at statement compilation time
If the real time statistics is enabled – the optimizer makes the decision. Real statisti......
|
|
-
|
|
A quick solution for extending capacity on a database server is normally a) add
more memory b) add disk space and expand containers C) additional processors d)add partitions.
If adding more procesors and system is SMP the processors will automatically share storage resources and memory. Co......
|
|
-
|
|
The strict definition of a SQL Server View is a virtual table that presents table(s) data.
Using the sp_refreshView – updates the metadata of the the view. Any view depends on underlying objects – and from time to time these objects are changed.
Typically this is useful when a column i......
|
|
-
|
|
Switching from using a CURSOR to a WHILE loop will mean they are not processing by a row. This is not true. The following examples illustrates this myth. Both examples are processing row by row:
Example 1 - CURSOR
create table #mytemp
(ID INT ,
avalue VARCHAR(100),
status INT
)
INSERT INTO #m......
|
|
-
|
|
To retain cosnsistency for baseline testing and assist in query tuning use the following 2 commands:
Use DBCC DROPCLEANBUFFERS to flush out already cached plans.This will force the SQL Statement to recompile intstead of re using the cache available
Use DBCC FREEPROCCACHE to clear buffers from the ......
|
|