What is the diff between Dynamic queries and static queries1 8332
wht's the differece between sqlserver05 and sqlserver20003 3204
what is meant by deafult in sql server?2 3255
any one can explain Self mapping Delegation Remote Credentials1 3569
What is the difference between views and stored procedures? Can we have input parameters for views?6 14936
Which databases are part of SQL server default installation? Explain the usage of each?2 4525
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?3 8205
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 6814
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?817
How do you Implement SSIS Packages in your Project?
on line cluster can we make if yes tell me the procedure
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How you trouble shoot when any job fails
what is package and it uses and how can u call a package
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
how can u get last observation in an unknown dataset ?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
wat wil hapn if we give the both read and deny read permission to user?
How to trouble shoot if unable to connect SQL Server
Delete duplicate rows without using rowid.
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
tell me the disaster recovery plan
If the job running very slow what is the action you do