Viewing 15 posts - 691 through 705 (of 5,590 total)
Evil Kraig F (3/3/2013)
March 4, 2013 at 9:15 am
if you use FOR XML RAW, you can also use the ELEMENTS and XSINIL clauses which should expose those other levels that you're looking for.
March 4, 2013 at 9:15 am
I got hooked on computers when I took my first programming class in college - a required course as part of the EE stuff I was doing at the time....
February 23, 2013 at 5:07 pm
zombieisdead2020 (1/29/2013)
I see first_value and last_value function, but do not see second or third value function!How can I write for example second_value() function by using analytical window function?
You will probably...
January 29, 2013 at 9:29 pm
Koen, I like your #SQLFamily icon in your signature. You ought to put it somewhere and tweet it so others can use it also.
January 23, 2013 at 9:59 am
Anyone in the Charlotte, NC area with an electric leaf blower (preferably battery powered!) that I can borrow for next year's PASS Summit? :w00t::crazy:
January 16, 2013 at 9:53 am
You can use OPENROWSET() to open the file. I have a script in the code library section of my blog[/url] for using this function.
However, like Jason asked, what is the...
January 15, 2013 at 11:43 am
IgorMi (1/15/2013)
Hi,Interesting question!
The expected one data page will be listed after rebuilding the index on the table.
alter index PK_Test on dbo.Test rebuild
dbcc ind ('TestDB','Test',1)
Thanks,
IgorMi
Absolutely correct (and this was pointed...
January 15, 2013 at 8:35 am
okbangas (1/15/2013)
January 15, 2013 at 8:07 am
Koen Verbeeck (1/14/2013)
Great question about a new 2012 feature. Thanks Ron!(and thanks for including me ;-))
+1
January 14, 2013 at 11:59 am
Steve Jones - SSC Editor (1/7/2013)
GSquared (1/7/2013)
Of course, my favorite bit about the Death Star is still: http://www.youtube.com/watch?v=jRe1EmMfVEYExcellent. I'll have to show my kids
Awesome. Just completely awesome.
January 7, 2013 at 9:36 am
kevin.kembel (12/21/2012)
GSquared (12/20/2012)
Table variables, temp tables, and worktables, only spill out of RAM onto drives, if they have to because of lack of available RAM, per MS.
I'd heard temporary tables,...
January 2, 2013 at 1:13 pm
SQLRNNR (12/21/2012)
The Dixie Flatline (12/21/2012)
In SSC Heaven, all the OPs do proper backups....And do proper restores.
And they don't restart their servers to fix data corruption issues.
And they post specific questions...
December 21, 2012 at 8:57 am
jasona.work (12/17/2012)
When everyone who could manage it, took the week off, and those who couldn't may as well have for all the "work" that gets done...
While...
December 18, 2012 at 7:58 am
Viewing 15 posts - 691 through 705 (of 5,590 total)