What is partition, how will you implement it? : sql server analysis services, ssas
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.
How to list all columns in a table using odbc_columns()?
What are synonyms?
Explain “not null constraint” in sql server?
How will you collect the date from current date to last older 6 days date in sql server 2005
How to list all triggers in the database with sys.triggers in ms sql server?
After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )
3 Answers CarrizalSoft Technologies, iGate,
Why normalization is used?
What is function of ROLLUP ?
How do you find the error, how can you know the number of rows effected by last SQL statement?
when would you go for denormalization? : Sql server database administration