WayneS

Forum Replies Created

Viewing 15 posts - 691 through 705 (of 5,588 total)

RE: Are the posted questions getting worse?

Evil Kraig F (3/3/2013)
Hey guys, I've got a bit of a quandry trying to avoid some recursion while dealing with an XML build. If anyone's willing to spend some...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

March 4, 2013 at 9:15 am

#1593059
RE: FOR XML and trying to avoid nested cursors

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.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

March 4, 2013 at 9:15 am

#1593057
RE: Early Software

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....
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 23, 2013 at 5:07 pm

#1590620
RE: The new Analytic functions in SQL Server 2012

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 29, 2013 at 9:29 pm

#1582455
RE: Are the posted questions getting worse?

Koen, I like your #SQLFamily icon in your signature. You ought to put it somewhere and tweet it so others can use it also.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 23, 2013 at 9:59 am

#1580183
RE: Are the posted questions getting worse?

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:
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 16, 2013 at 9:53 am

#1577922
RE: Getting field value from notepad

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 15, 2013 at 11:43 am

#1577457
RE: Ghost Cleanup

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 15, 2013 at 8:35 am

#1577369
RE: Ghost Cleanup

okbangas (1/15/2013)
As far as I understand it, there is something missing from the explanation. If we assume that only what's written in the scenario has happened, the scenario is...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 15, 2013 at 8:07 am

#1577355
RE: T-SQL 2012 #2

Koen Verbeeck (1/14/2013)
Great question about a new 2012 feature. Thanks Ron!
(and thanks for including me ;-))
+1
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 14, 2013 at 11:59 am

#1577035
RE: Are the posted questions getting worse?

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=jRe1EmMfVEY
Excellent. I'll have to show my kids
Awesome. Just completely awesome.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 7, 2013 at 9:36 am

#1574396
RE: Storage Subsystems and RAMDisks

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,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 2, 2013 at 1:13 pm

#1573063
RE: Are the posted questions getting worse?

Happy Birthday Jason.
Enjoy the hippo...
http://www.youtube.com/watch?v=rEc8rGonrQw
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 21, 2012 at 10:02 am

#1571000
RE: Are the posted questions getting worse?

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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 21, 2012 at 8:57 am

#1570957
RE: Are the posted questions getting worse?

jasona.work (12/17/2012)
Ah, the week before X-Mas...
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...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 18, 2012 at 7:58 am

#1569589

Viewing 15 posts - 691 through 705 (of 5,588 total)