Amy.G (4/8/2013)

---

Oops, I think I misunderstood something. The data are in two separate tables...

Wait! What? LOL, what was the...

shubham.saxena67 (4/2/2013)

---

I Want to store image as in image datatype with compression of byte using a function

like fn_compress(@imagebyte image) also need to decompress the same.

could you help me to...

rajarshi_ghosh_05 (4/2/2013)

---

Guys, No luck. DBAs are not going to give me the permission to create table in tempdb so I come up with an idea to put both updlock and...

Jeff Moden (3/1/2013)That's why I almost always expect the code to be used on a huge number of rows. There are a whole lot of developers that don't know...

amy26 (2/26/2013)

---

No they are not on the same network and there is no VPN. When you say get a "secure link between the 2" what are you referring to?

I...

Without knowing the specifications of this design, the moment I see columns numbered numerically, I cringe. Then I cry. This design pattern usually indicates a bad design.

I would...

Is the physical network layer between the 2 agencies private? Is it a VPN, or some tunnel variant?

If so, then the encryption layer/privacy layer is in place and I...

I prefer mine undocked. With dual screen, I keep my SSMS in the right screen, email in the left (or Visual Studio) and keep the OE undocked in the...

Jay-246689 (2/20/2013)

---

hi,

Is CASTing cost an additional overhead to the query? I need to optimize our database initialization and i reviewing some of the sql scripts and found out that there...

vchauhan_me (2/21/2013)

---

Thanks for the reply from all of you, but i need the specific reason why separate rows (70,000 rows) are more preferable to store in DB in place...

I whipped this up quick, and looking at it you would probably want to combine all the EXACTSinto one UNION etc... but I broke them out so you can see...

I would have used a multi step UNION, with one of the columns returned the rank value you need. That would be more optimal than the UDF. I...

Saw this snippet somewhere and thought it was a good solution:

DECLARE @Year INT

SET @Year =2012

SELECT months,MAX(dates) AS DT_MONTH

FROM (SELECT MONTH(DATEADD(DAY, number-1, DATEADD(YEAR, @Year-1900, 0))) AS MONTHS,

DATEADD(DAY, number-1, DATEADD(YEAR,...

asco5 (2/8/2013)

---

hi i tried first one

select top 100 cause i need only the 100 first people who have the most entry

so i did

select top 100 ID,

count (*)

from [database].

.

group by...