Friday, July 30, 2010
but I could access the event viewer from another machine. Here is what the event viewer error message says.
Here are the steps I have been advised to follow by Aaron Mountford (gen-i consultant) to resolve this.
I have registered the two dlls as follows.
Click Start, click Run, type regsvr32 Msxml3.dll, and then click OK
Click Start, click Run, type regsvr32 %systemroot%\system32\inetsrv\wamreg.dll, and then click OK.
Thursday, July 29, 2010
This is what I did to achieve this.
SELECT rn_create_date, SUBSTRING(CONVERT(varchar(20), Rn_create_date, 22), 18, 3) AS Expr1
Here is the link to the BIDN blog where I have posted
You have to either press Ctrl+N or Click on New Query to start it up.
Here is a way to start up the New Query window automatically.
Click on Tools-- Options click on the + to exapnd environment and click on General.
The following screen comes up.
Click on the drop down beside start up and choose ' Open Object Exlpoer and New query'.
Click Ok. Next time when you open SSMS the query window will automatically be opened for you.
Here is link to the blog I posted in my BIDN blog.
Friday, July 23, 2010
The commoan screen appear.
Do the following:
- To hide, d:/>attrib +h +s +r
- To revert d:/>attrib -h -s -r
The folder ill be still hidden even if you set 'show all hidden files' under folder view options
Make sure you keep a note of your fodler name otherwise you cannot unhide it.
Thursday, July 22, 2010
• Start schema is simpler and hence good to use for small data warehouses. The rules that apply here are as follows:
• Each dimension is represented by a single dimension table
• Each dimensional table is related to or linked to a fact table.
• The relation is merely a master and detail relationship with Primary key being the dimension and reference key in the fact table.
• When there are 5 or more dimensions referring to one fact table it appears like a star and hence the name star schema
• In terms of ease of use you need less complex queries and easy to understand
• This design has redundant data and hence hard to maintain and change.
• Lesser query execution time due to lesser number of queries
• Snowflake schema starts like a star schema and more complex and hence it is good to use the snow flake schema for large data warehouses. The rules that apply here are as follows:
• Each dimension is represented by a two or more dimension tables
• Each dimensional table is not directly related to fact table
• Here the tables that describe the dimensions are normalised.
• In terms of ease of use you have to use more complex queries
• There is no redundancy and easy to maintain and change
• More query execution time because of more foreign keys
I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...