Revenant (3/24/2016)

---

Freemium

Sean Lange (3/24/2016)

---

ChrisM@Work (3/24/2016)

---

Sean Lange (3/24/2016)

---

--I posted in another thread by accident a couple of days ago--

Thank you Mr. Moden. Another interview cut short with the simple "Name one way...

Sean Lange (3/24/2016)

---

Eirikur Eiriksson (3/24/2016)

---

Sean Lange (3/24/2016)

---

--I posted in another thread by accident a couple of days ago--

Thank you Mr. Moden. Another interview cut short with the simple "Name one...

Brandie Tarvin (3/24/2016)

---

I need some SSIS script task help (2008 / 2012) over on this thread here. All assistance would be appreciated.

Google doesn't seem to recognize the first error at...

I'm not sure that LAG function would work here.

I have 2 options that work for this example, but you might have to do further testing.

SELECT at.ID,

at.Score,

...

Have you read this? Including the links https://www.brentozar.com/archive/2010/09/sql-server-dba-scripts-how-to-find-slow-sql-server-queries/

Also, the procedure is heavily commented to document functionalities, or you could use the help parameter.

EXEC dbo.sp_WhoIsActive @help =1;

2319

You'll have to wait for a while. 😀

So much trouble adding and removing quotes to a smallint column. Why?

You could add the zeros before converting the value to string.

SELECT field10,

field5,

...

Charmer (3/23/2016)

---

Hi Luis,

I am not sure but I think they are going to refer these tables in a ssrs report. I heard that they are using share point and report...

Read the following article: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

It explains what each part does. Be sure to understand how it works and ask any questions you might have. You could also read BOL to...

This might help. If you want your results to be grouped, you don't use the OVER clause, you need to use GROUP BY.

SELECT 'NW' AS Region,'chocolate Swirl' As Flavor, 1...

Charmer (3/22/2016)

---

Hi Friends,

I have a scenario that I have records incoming from a table and have to insert into another table. Incoming count is usually in millions. I have been...

You're right, I didn't test it.

An alternative could be something like this:

WITH CTE AS(

...

The major difference from the 2 runs seems to be the physical reads from a table. When it's slow, it's reading 12-13 thousand pages from disk. When it's fast, it...