WayneS

Forum Replies Created

Viewing 15 posts - 916 through 930 (of 5,588 total)

RE: Are the posted questions getting worse?

Speaking of L&L's... have you'll ever tried them with folks locally and remotely? (talking India here...)
That's what I'm trying to figure out... leaning towards separating them.
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 20, 2012 at 1:06 pm

#1436706
RE: Are the posted questions getting worse?

GSquared (1/20/2012)
jcrawf02 (1/20/2012)
This is frickin' hysterical: http://arstechnica.com/microsoft/news/2012/01/microsoft-pimps-it-old-school-with-a-pricey-text-adventure-game.ars
OMG!!
I've got people staring at me as I laugh maniacally right about now!
Too much!
Love it!
I was going to skip this, but anything that gets...
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 20, 2012 at 9:16 am

#1436592
RE: Are the posted questions getting worse?

Congrats Brandie.
Does this mean you are well on your way to writing full time and forgetting all about SQL?
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 19, 2012 at 8:11 pm

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

Jason, Geoff, Mark, Tim and KWymore...
Thanks, I'm very glad that you'll like it.
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 19, 2012 at 7:53 pm

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

Jack Corbett (1/19/2012)
Good article Wayne. One thing I like to see in articles like this though is how you might solve the same problem without using 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 19, 2012 at 7:51 pm

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

Zeev Kazhdan (1/19/2012)
Finally they will have what Oracle had delivered ages ago....
and MySql, and DB2, and... well, nearly everyone else. It is long overdue, and should have been in 2008.
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 19, 2012 at 7:48 pm

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

j-1064772 (1/19/2012)
How do the newfangled Analytics functions compare with the Quirky Update method used for - among other things - creating running totals in term of performance ?
The Analytic functions...
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 19, 2012 at 7:47 pm

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

RichB (1/19/2012)
Any idea what the performance of these things is like?
Did you click on that "TSQL Challenges Winner" icon in my signature? (Well, that is using the aggregate functions and...
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 19, 2012 at 7:42 pm

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

Christian Buettner-167247 (1/19/2012)
WayneS (1/18/2012)
Comments posted to this topic are about the item <A HREF="/articles/SQL+Server+2012/76704/">The new Analytic functions in SQL Server 2012</A>
Great information, thanks for that.
To me it was not clear...
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 19, 2012 at 7:40 pm

#1436267
RE: Are the posted questions getting worse?

Dang, it was one of those days... I forgot all about my article being published today. (Time to get busy)
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 19, 2012 at 7:35 pm

#1436266
RE: help to write a query to retrieve all attributes for a

aitchkcandoo (1/16/2012)
WayneS, that article was dead on, spot on. Thanks.
Thought it might help. Thanks for reading it, and you're quite welcome.
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 17, 2012 at 8:23 am

#1434641
RE: Are the posted questions getting worse?

Gianluca Sartori (1/16/2012)
WayneS (1/16/2012)
So, what kind of laptop do you have?
The same as Glenn Berry's:
http://sqlserverperformance.wordpress.com/2011/08/27/new-dell-precision-m4600-mobile-workstation/
Very strange, I don't have issues at all with my VMs. Did you have the same...
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, 2012 at 2:52 pm

#1434304
RE: Are the posted questions getting worse?

Chad Crawford (1/16/2012)
WayneS (1/16/2012)
So, what kind of laptop do you have?
Slacks M-Th, Levis on Friday and the weekend.
cute. got'cha beat... jeans all week
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, 2012 at 2:50 pm

#1434302
RE: What, when and who? Auditing 101 - Part 2

Nice article Roy. Thanks!
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, 2012 at 2:27 pm

#1434293
RE: Are the posted questions getting worse?

Gianluca Sartori (1/16/2012)
SQL Kiwi (1/16/2012)
WayneS (1/16/2012)
I was wondering if there would be one or two SSMS, due to the changes of it in 2012.
It's quite handy - after a reboot,...
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, 2012 at 2:05 pm

#1434279

Viewing 15 posts - 916 through 930 (of 5,588 total)