Can select statements be used on views in ms sql server?
How many types of cursors are there in SQL Server?
5 Answers 247Customer, CarrizalSoft Technologies,
How important do you consider cursors or while loops for a transactional database?
SQL Server Architecture ?
Explain about remote stored procedure?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Hi..here i would like to know the Backup and Restore models?
Why we are using the sql language?. What is the purpose of using this?
what is a transaction? : Sql server database administration
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 know whether our backup is succesfully taken?
Do you know what is replace and stuff function in sql server?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?