What's new in sql management studio for sql server? : sql server management studio

0 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,

---

Explain multiserver query

0 Answers  

---

Explain mixed authentication mode of sql server?

0 Answers  

---

How to insert data with null values?

0 Answers  

---

What is ms sql server triggers?

0 Answers  

---

What is cdc in sql server?

0 Answers  

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

0 Answers  

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

How to replace null values in expressions using isnull()?

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

What is a rollup clause?

0 Answers  

---