Ok so how often are you running Tlog backups? If you are running frequent Tlog backups as part of your backup plan then I wouldnt worry about it....
Aside from configuring AWE you need to make sure you have enabled 3GB and Physical Address Extensions PAE switch in the boot.ini file, you also need...
What Service Pack are you on? From the symptoms you are reporting it appears that you are on sp4, read this http://support.microsoft.com/?kbid=899761...
If 75% of your data in empid will be duplicate then indexing this column will be useless, for your first senario you could create a composite...
To let users freely query the database and create views as desired is a WORST practice in my opinion. If this is a small database with tables that...
Is your database using the Simple Recovery Model or are there any jobs that are truncating your Transaction Log?
Ok sounds like your Time Dimension will play "Dimensional Roles" on the Fact Table. In this design you can build only one Time Dimension, and out of...
Ok I know your Database contains several million rows, but what is relevant right now is your Customer Table (OLTP), how big is the customer table?...
Johnslg Why would you want to put three different date hierarchies in one time dimension??? As far as partitioning I would just partition the fact...
In the case of Time dimensions the Surrogate Key is best represented as an integer like dineshasanka mentioned (20071001) sometimes this will be...
It is odd you would inquire about Teradata on a SQL Server forum. Last few companies I've worked at use Teradata. Teradata is intended for high end...
To anwser your question NO, never use business key (Natural Key) in lieu of true surrogate keys for dimensions as this can impose major problems in...
What type of replication are you planning to implement? Raulie
Have you followed Satya's suggestions? He gave many tips on how to get your queries to run the same on both databases to narrow and troubleshoot your...
Run this command to see if you can repair any minor errors DBCC CHECKDB ('KShipU', REPAIR_FAST) this will not expose you to data loss. Raulie
This sounds right. Raulie
To build a query of all your users on the server you can use SELECT p.name, p.type_desc, p.is_disabled, p.default_database_name, l.hasaccess,...
What service pack do you have installed on AS? The .mdmp mini dump files are generated when the system reboots you can read the contents of this file...
If the granualarity of the time dimension does not require Time then trim it from your fact table and only use dates. Raulie
Separate names with a comma.
