Enclose each of the queries within the following while you unit test them. This will return statistics such as physical/logical page reads, CPU time, plan text, etc. for comparison.

SET STATISTICS...

At my old job, I would keep a can of expresso ground Cafe Bustello in my desk, and I would sometimes reload the coffee maker using a double or tripple...

Just like the cast for Hollywood films, TV shows, or the makeup of city councils or corporate boards, you'll find that diversity within IT is hit and miss depending on...

curious_sqldba (5/31/2016)

---

KSQLDBA (5/31/2016)

---

What is "SQL Fertilization" any links?

its job description. I have googled it and i noticed that many jobs are asking: "Some experience with SQL fertilization helpful" I m...

Yeah, I gess it's best to play it safe. You never know...

RE: "SQL Fertilization"

So, perhaps somone is looking for a sperm donor. If musicians, atheletes, and high IQ university students are in demand, then why not a DBA?

That's why you always have an open position available for a great developer. If one is available, and they rarely are, you hire them if they want to work for...

N/A is a character value, you cant mix types within same column, so you must CONVERT() the date to character.

umailedit (5/27/2016)

---

Why is this not possible?

Candidates can be placed in front of a terminal in another room (so you don't know if they...

I myself am a middle-aged white man. My fellow DBA team members consist of: a middle-aged Nigerian-American man, a younger Nigerian-American woman, a younger Tanzanian-American man, two middle-aged Indian-American men...

Rod at work (5/27/2016)

---

Recombinant (5/27/2016)

---

For a long time I have disagreed with bosses and organisations in some jobs but then got on OK in other jobs. Things came to a...

peter.row (5/26/2016)

---

Eric M Russell (5/23/2016)

---

If you're deleting a total of 100 million rows, then deleting in batches of 10,000 would be too small, because there will be 10,000 iterations of...

Below is a bulk delete script a wrote a couple of years ago. At the time, I had database recovery model set to SIMPLE (truncate log on checkpoint). It also...

If you're deleting a total of 100 million rows, then deleting in batches of 10,000 would be too small, because there will be 10,000 iterations of the loop. Each loop...

There are some conversational style SQL Server related podcasts where the host interviews a different professional in each show.

http://www.sqldownunder.com/Podcasts

http://www.sqlserverradio.com/

Stuff by...