|
|
-
|
|
When choosing a licensing structure for SQL Server 2008 consideration should be given to the different licensing models:
a)Server plus device client Access license (CAL)
b)Server plus user client access license (CAL)
c)Processor license
In calculating efficient pricing, consider such factors as......
|
|
-
|
|
There is a nightly backup | copy | & restore job as part of an ETL. Last night the job failed – with the error:
RESTORE detected an error on page (0:0) in database MYDB as read from the backup set.
The correlating message in the Event Viewer is:
The backup data at the end of "J:\mydriv......
|
|
-
|
|
A brief note on collations. In this case:
SQL_Latin1_General_CP1_CI_AS
V
SQL_Latin1_General_CP850_CI_AS
What is the difference?
Firstly, some terminology:
Code Page – 1-4 digit number specifying code page. This code page define the bit patterns for the characters
Case Sensitivity - CS ......
|
|
-
|
|
Requirement to restore a copy of a backup taken from another DB2 instance and replace the existing one
Steps:
1)Take a full backup of the database of INSTANCE 1
db2 force applications all
db2 backup database MYDB
Transfer the backup copy to a relevant path
db2 force applications all
db2 rest......
|
|
-
|
|
In a conversation with a colleague we started discussing materialized views. Firstly, he wanted to know do materialized views exist in SQL server? and if so, how are the implemented and maintained for decent performance.
Materialized do exist in SQL server – commonly refered to as Indexed Vi......
|
|
-
|
|
As part of a SQL server monitoring review and agent upgrade, I was asked by the Tivoli Engineer to create a list of situations, that monitoring would be useful. The architecture used is Tivoli Monitoring /
Some considerations are:
1) By commiting to having to many situations monitored &ndash......
|
|
-
|
|
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......
|
|
-
|
|
There is a warning in the SQL Server Books Online – to stop using sp_password, as
in future editions, this procedure will cease to be used.
In effect, sp_password calls ALTER LOGIN.
To run ALTER LOGIN – an example is:
ALTER LOGIN jackvamvas WITH password =......
|
|
-
|
|
After a restore on a database – I saw a (resticted user ) next to a database.
Solved the problem by:
ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE mydatabase SET MULTI_USER
GO
Republished from http://www.sqlserver-dba.com.......
|
|
-
|
|
I had to export some data from a Mysql database, for the purpose of creating a spreadsheet,
which would be used for presentation purposes and also to import into a DB2 database.
Initially I considered using an ODBC connection from my laptop, I do not have ODBC drivers for mysql on my laptop. ......
|
|