After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
what is a join and explain different types of joins? : Sql server database administration
What happens when transaction log is full?
what is dbcc? : Sql server database administration
what are the advanced features in sql 2008?
CLR Integration ? what is Notification services ?
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What are the advantages of using sql server over ms access or why should one use sql instead of ms access
What is inline variable assignment?
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?
What is update locks?
Explain tablesample?