What happens if we shrink log file in sql server?
What guidelines should be followed to help minimize deadlocks?
how to invoke a trigger on demand? : Sql server database administration
Explain how does the report manager work in ssrs?
Is foreign key a primary key?
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.
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
How to include date and time values in sql statements?
Explain how many normalization forms?
Are semicolons required at the end of sql statements in sql server 2005?
what are default? Is there a column to which a default cant be bound?
How many types of triggers are there?
In what sequence sql statement is processed?