How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

---

What is unpivot?

0 Answers  

---

How to add code to the existing article (using improve article)?

0 Answers  

---

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

---

What are the indexes in sql server?

0 Answers  

---

---

Differentiate between a local and a global temporary table?

0 Answers  

---

What is logshipping and its purpose?

0 Answers  

---

In what version of sql server were synonyms released?

0 Answers  

---

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?

2 Answers   Cognizant,

---

What are examples of triggers?

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---