Viewing 15 posts - 4,276 through 4,290 (of 19,564 total)
SimonLiew (7/25/2013)
My advice is not to benchmark how many people passed in their first attempt. Everyone's different. Passing an...
August 27, 2013 at 1:56 pm
erikd (8/27/2013)
SQLRNNR (8/27/2013)
erikd (8/27/2013)
Ah. That's weird. Why does that happen? I jumped from 2005 to 2012, and never ran into that happening. I feel pretty lucky :Whistling:
I should probably clarify...
August 27, 2013 at 10:49 am
erikd (8/27/2013)
Ah. That's weird. Why does that happen? I jumped from 2005 to 2012, and never ran into that happening. I feel pretty lucky :Whistling:
I should probably clarify a little...
August 27, 2013 at 10:42 am
erikd (8/27/2013)
Koen Verbeeck (8/26/2013)
kakumanukalyan (8/26/2013)
SELECT ContactID,Concat('$',AVG(TotalDue)) AS [Avergare Total Due]FROM Sales.SalesOrderHeader
GROUP BY ContactID
ORDER BY 1 ASC
Not really a fan of doing this in the database layer. If the result is...
August 27, 2013 at 9:31 am
sknox (8/27/2013)
SQLRNNR (8/27/2013)
For me, the wording of the question implies that a requirement of a heap be that it is completely devoid of indexes.
Then you're not thinking in set-based...
August 27, 2013 at 8:47 am
Hugo Kornelis (8/27/2013)
SQLRNNR (8/26/2013)
A Heap can have nonclustered indexes. A heap just means that...
August 27, 2013 at 12:56 am
Though it is easy enough to figure the intent of this question, I disagree with it.
A Heap can have nonclustered indexes. A heap just means that the table is...
August 26, 2013 at 11:56 pm
anoop.mig29 (8/26/2013)
GilaMonster (8/24/2013)
anoop.mig29 (8/24/2013)
@Gail problem is there are 2 dr of a single primary and only is participating in DR drill so i cannot stop ls backup job at primary.
I...
August 26, 2013 at 11:10 pm
GilaMonster (8/26/2013)
33 slides for 3 hours. Should be enough.
With that many slides you could easily stretch it into an 8hr preso :hehe::w00t:
August 26, 2013 at 1:11 pm
JAZZ Master (8/26/2013)
SQLRNNR (8/23/2013)
Daniel Bowlin (8/23/2013)
Ray K (8/23/2013)
SQLRNNR (8/22/2013)
opc.three (8/22/2013)
GanttHostess
Freihofers
Bakery
Donut run
Cinnamon Roll
flaming tire
August 26, 2013 at 9:36 am
Jeff Moden (8/25/2013)
GilaMonster (8/25/2013)
Jeff Moden (8/25/2013)
GilaMonster (8/25/2013)
What's your favourite index-related myth?What's yours?
I have a few, but I need fodder for the PASS presentation (that's due today) 😀
Not necessarily my favorites...
August 26, 2013 at 9:23 am
Koen Verbeeck (8/26/2013)
kakumanukalyan (8/26/2013)
SELECT ContactID,Concat('$',AVG(TotalDue)) AS [Avergare Total Due]FROM Sales.SalesOrderHeader
GROUP BY ContactID
ORDER BY 1 ASC
Not really a fan of doing this in the database layer. If the result is NULL,...
August 26, 2013 at 9:06 am
GilaMonster (8/25/2013)
What's your favourite index-related myth?
Tables don't need a clustered index
CI sorts the records in order on a page
August 25, 2013 at 6:04 pm
Read the following thread. It should provide some examples and a caution about doing the concatenation at the database level rather than the presentation level
http://www.sqlservercentral.com/Forums/Topic1407950-392-1.aspx
August 24, 2013 at 9:37 am
Daniel Bowlin (8/23/2013)
Ray K (8/23/2013)
SQLRNNR (8/22/2013)
opc.three (8/22/2013)
GanttHostess
Freihofers
Bakery
Donut run
August 23, 2013 at 4:20 pm
Viewing 15 posts - 4,276 through 4,290 (of 19,564 total)