WHAT OPERATOR PERFORMS PATTERN MATCHING?
Answers were Sorted based on User's Feedback
What are statistics, under what circumstances they go out of date, how do you update them?
What is stored in the mssqlsystemresource database? : sql server database administration
What is the purpose of sql profiler in sql server? : sql server database administration
In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
What is Transparent Data Encryption?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
what are the critical issues you have resloved in your company
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.
What is the New in SQL server 2008?
How can we call UDF(User Define Function) using C# code in ASP.net ?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Can a synonym name of a table be used instead of a table name in a select statement?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)