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...

SQLRNNR (5/22/2015)

---

IMHO - those recommendations are the lowest common denominator if you MUST have...

Brandie Tarvin (5/22/2015)

---

They kind of look like smoke detectors, usually installed in the ceiling tiles. They cover about a...

noise

Grant Fritchey (5/22/2015)

---

Question for the crew since this is a fairly international audience, plagiarism

I understand that some cultures look at it very differently than most Western European-based ones do. There's...

GilaMonster (5/22/2015)

---

Yes, excellent idea, just go and change max server memory from ~28 GB with SQL using all of it down to 4GB and back up because that 95% figure...

Quick question, is there a dinosaur in the decision making team, haven't seen this kind of architecture since AS/400?

😎

Quick note, if manually setting the...

GilaMonster (5/22/2015)

---

Please, stop fiddling with the memory. From the symptoms, stats and details you've posted, the memory is NOT the problem. At most it's a symptom of the problem, a...