David Webb-CDS (5/15/2015)

---

Your customer comes to you and says the query he has run daily for the last two years is suddenly taking hours instead of seconds. You gather...

Eric M Russell (5/15/2015)

---

Sean Lange (5/15/2015)

---

Luis Cazares (5/15/2015)

---

It's important for us that you'll be a good fit in our team, so the following question will define if you get the...

Grant Fritchey (5/15/2015)

---

Sean Lange (5/15/2015)

---

Luis Cazares (5/15/2015)

---

It's important for us that you'll be a good fit in our team, so the following question will define if you get the job...

Luis Cazares (5/15/2015)

---

It's important for us that you'll be a good fit in our team, so the following question will define if you get the job or not.

Leading commas or...

bpsavi123 (5/15/2015)

---

Hi,

i have task where i need to update the 2 columns from 2 different tables.I need to get one column from one table and update to the other table.If...

But the problem is that what you are trying to do needs to be done in the website code....

This a bit of a challenge. This site is dedicated to sql server. The other challenge is we don't...

lynn.sferrino-foxworthy (5/15/2015)

---

i have a piece of code that is pulling from a list of values for a web page form. i want to set this list to always show...

Uday3421 (5/14/2015)

---

i'm confuse about trigger and i want to get explained about trigger syntax and it's each line that what is dose also how it could get modified by the...

Good question. I am not really too surprised that so few people got this correct. It is a topic that comes up frequently around the forums. Like Hugo I tend...

GilaMonster (5/14/2015)

---

Question for the people here...

Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...

First off, with regards to view design:

1. You may want to add WITH(NOLOCK) to your FROM statements, if they're not already there and you can tolerate the possibility of a...

Prem-321257 (5/13/2015)

---

I need help with tuning this query. This below takes about 55 minutes to run :

User_Login_test is a VIEW - the view structure is union to multiple tables.

SELECT...

Any particular datatype you want? To CAST a value you have to wrap the value in the cast function.

Err...yeah. :blush: Thanks Phil.