How to secure data in the SQL Server Database?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 9th, 2010

Revoke db_datareader and db_datawriter permission from the database.

Answer Question  Select Best Answer

How to send mail from SQL Server?

vishalparate

 Profile Answers by vishalparate Questions by vishalparate

• Mar 30th, 2010

With SQL Server 2005, there is no need to use MAPI client to send emails. Fellow developers who have used MAPI in the previous versions of SQL Server are well aware of the challenges it had. However i...

Answer Question  Select Best Answer

What is fill factor?What should be the ideal value of fill factor for any index?Justify the answer.

raiyaans

 Profile Answers by raiyaans Questions by raiyaans

• Jan 12th, 2012

The fill factor simply says how large or how full to get our index pages
you can set it as 70% ,

If set to 100% it might me a bad thing if we had a lot of DML activity but if this is a read only table then
fill factor=100% is fine.

Answer Question  Select Best Answer

List down the advantage and disadvantages of Covering indexes.

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 12th, 2011

Covering Indexes are useful for Input / Output intensive workloads.
Covering indexes are smaller in size
Covering Indexes are sorted by values
It is easier to cache date in Covering Indexes

Covering Indexes cannot be used to select all the columns / entire table.

Answer Question  Select Best Answer

How to Store Images in SQL Server 2005?

vigneshmca

 Profile Answers by vigneshmca Questions by vigneshmca

• Sep 9th, 2010

You can store images by BLOB (Binary Large object). Conversion should take place in front-end?or SQL supports image as datatype. Try it.

Answer Question  Select Best Answer

What are the steps to configure DB mirroring?

sthakk3

 Profile Answers by sthakk3 Questions by sthakk3

• Dec 9th, 2010

Database mirroring maintains two copies of a single database that must reside on different server instances of SQL Server Database Engine.Database mirroring is a primarily software solution for increasing database availability.

Answer Question  Select Best Answer

how do you run PL/SQL block from SQL Server

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 12th, 2011

Try these and see...

Go To Options -> Run SQL
Set "Statement Delimiter" to None

Go To Options -> Technical Parameters
Tick "Use SQLExecDirect"

Answer Question  Select Best Answer

what is high water mark? Give an example where it can be useful ?

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 12th, 2011

High Water Mark (HWM) represents total number of extent blocks used by a table. The value of High Water Mark could sometime be more then the actual size required/used by a table. This is because, some...

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 28th, 2011

Steps to set / modify Global Setting for Query Studio: 1. Stop the Cognos 8|ReportNet server. 2. On the Cognos 8|ReportNet Server, go to the directory /c8|crn/templates/ps/async/ 3. Either create a n...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

suji  

 Profile Answers by suji Questions by suji

• Member Since Sep-2005 | Nov 7th, 2011

---

I would use full-text indexing as you are on the latest version. Create and store the html in varbinary(max) column and set its associated file type to ".html" in a file type column. Then enable full-text index, so indexer will parse the data and search only the text content while ignoring the HTML tags. We had been using blob to store the documents, with the new features have come out in the later versions, this seems to be best option. We are in the process of migrating one of the app to use varbinary and to take advantage of the search feature. There is another way of storing using filestrem. Here is a good read-up from MS . FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. Applications can leverage the rich streaming APIs and performance of the file system and at the same time maintain transactional consistency between the unstructured data and corresponding structured data http://blogs.msdn.com/b/manisblog/archive/2007/10/21/filestream-data-type-sql-server-2008.aspx Here is another old report from MS back in 2006 explains about using oldway of BLOG http://research.microsoft.com/apps/pubs/default.aspx?id=64525 There are multiple options for you, pick the best approach that matches your needs Thanks, Suji

suji

 Profile Answers by suji Questions by suji

• Nov 7th, 2011

I would use full-text indexing as you are on the latest version. Create and store the html in varbinary(max) column and set its associated file type to ".html" in a file type column. Then enable fu...

Improve Answer

suji

 Profile Answers by suji Questions by suji

• Jan 15th, 2012

From your SQL Server Management Studio, you open Object Explorer, go to your database where you want to load the data into, right click, then pick Tasks > Import Data. Select the options based on the excel file

Answer Question  Select Best Answer

interviewer ask.. can we replace where clause by group by clause

let say

select * from table_name where some_condition

so how we replace where clause by group by clause

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Feb 16th, 2012

As a basic rule of query building: 1. The WHERE clause should be used to limit the number of rows returned by or affected by the a SQL statement. 2. The GROUP BY clause is used to group a selec...

Answer Question  Select Best Answer

murali chennupati

• Jul 5th, 2014

From jobs->new->step->categories->ssis->select db->select the package & schedule.

Answer Question  Select Best Answer

In application supporter for .net, interviewer ask me how you support the application,but I could not answer properly. Please explain answer technically?

Ravi Sharma

• Jun 2nd, 2015

We provided end to end solutions. Taking the requirement from client side, analysis on that requirement. Providing the analysis documents. Starting developing part then testing and deployment.

Answer Question  Select Best Answer

Display employee name, designation, Dob who are born in the same year.

Emono ename Designation Dob
101 Raj Developer 24-06-1992
102 mahesh Engineer 15-06-1992
103 Rajesh Mechanic 02-02-1991
104 suresh Jr Engineer 01-01-1990

Afsar

• Oct 25th, 2017

TD QUERY:
SELECT EXTRACT (YEAR FROM DOB), ename, Designation, Dob
FROM TABLE TAB1
GROUP BY EXTRACT (YEAR FROM DOB)

Answer Question  Select Best Answer

Genie_Cool

• Jun 4th, 2007

Dirty Pages: Data that has been modified and Stored in the buffer cache and has not yet been written in to the hard disk. (Transaction Logs)Dirty reads: Reading the data that is actually read by Trans...

Answer Question  Select Best Answer

sahu

 Profile Answers by sahu Questions by sahu

• Jan 28th, 2006

Ans:Database returns an error message when a constraint is violated.Differnet type of constrains;1.Domain Constraints:A Domain constraint deals with one or more columns2.Entity Constraints3.Referentia...

Answer Question  Select Best Answer

Nirav

• Jul 25th, 2006

You can use Bulk copy program (BCP) to  convert a data from row to text or text to row

Answer Question  Select Best Answer

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 22nd, 2005

Create [shared/public] database link connect To identified by using Any problem Don't hesitate write to rahultripathi@myway.com

Answer Question  Select Best Answer

Raj Sekhar

• Aug 17th, 2006

Trigger are two types:1) Insteadof trigger2) After trigger

Answer Question  Select Best Answer