This statement prompts the question of what the possibilities are to correlate different time...

Would you be so kind to elaborate a little further on this, I for one don't think I fully understand your point...

I must be getting old and slow, just cannot fit the answer to today's date, took a guess for the fun of it though, no pain no gain:-D

😎

Great post Gail and thank you for making the effort!

Far too often (now echoing Jeff) tests are shaped to the expected results regardless of the actual results (if that makes...

ROFL

😎

mburbea (5/23/2015)

---

I bring up the lack of randomness as it works in the favor of delimitedsplit8k, as the optimizer can basically get to reuse its row plans. (Running the test...

Happy to help and you are most welcome

😎

Quick question, are you using absolute or relative path?

😎

s.kandepi3 (5/22/2015)

---

I have a execute SQL task where i placed the result set of the query in the object variable. It has 2 values.I m trying to pass these values...

I agree with Gail here, if the system is not designed for it, implementing out-scaling will be difficult at the best. Jeff taps on a very valuable point, why is...

mburbea (5/22/2015)

---

Sadly, you're a victim of an optimization bug that makes your test data much less random than it should be. Sql server 2012+ can treat newid as a runtime...

Bex (5/22/2015)

---

I have a one-off need to get some XML data into a table

<Persons>

<Person>

<STAFFID>12345678910</STAFFID>

<SURANME>Bloggs</SURNAME>

<FIRSTNAME>Joe</FIRSTNAME>

...

Adam Bean (5/22/2015)

---

Hey all,

Finally working on my certification. Just passed 70-462 (Administering Microsoft SQL Server 2012 Databases) today on my first shot, woohoo! I don't think 70-461 (Querying Microsoft SQL...

Lynn Pettis (5/22/2015)

---

Here is a snippet I found in a recently developed piece of code:

Stored proc parameter: @reportstring NVARCHAR(max)

DECLARE @tmpTbl TABLE ( value NVARCHAR(200) )

SELECT @tmp = ''

SELECT @i =...

Just ran a quick test on...