What is the difference between functions and stored procedures?
No Answer is Posted For this Question
Be the First to Post Answer
Explain features and concepts of analysis services?
How do I view a trc file?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What does normalization do to data?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
Difference between: - Delete & Truncate - Table & View - Constraints & Triggers
Explain hostprotectionattribute in sql server 2005?
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
Does index speed up select statements?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Explain what is the function of sql server agent windows service?
How to Check if table exists in sql server?